Select sum(bytes) / 1048576 Size in Mb
From dba_extents
Where owner = upper('owner')
and segment_name = upper('tablename');
Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes.
Christopher R. Spence
Does anyone have a script that gives actual space used instead of size of
extents allocated?
Thanks
Rick
-Original Message-
Sent: Wednesday, September 19, 2001 10:05 AM
To: Multiple recipients of list ORACLE-L
Select sum(bytes) / 1048576 Size in Mb
From dba_extents
Where owner =
Rick Lex,
Have you tried the:
DBMS_SPACE.unused_space package?
It gives used and unused number of bytes and blocks for an item. Below is
the syntax:
PROCEDURE unused_space(segment_owner IN VARCHAR2,
segment_name IN VARCHAR2,
segment_type
Title: RE: sizeiof table!!!
Here's a modification of one that I use
1 select
2 tablespace_name, MB_FREE, MB_TOTAL,mb_total-mb_free mb_used,
3 round((MB_TOTAL-MB_FREE)/MB_TOTAL*1000)/10 pct_used
4 from
5 (select tablespace_name, trunc(sum(free_bytes/1024)) MB_FREE , sum(total_bytes/1024