cancel
Showing results for 
Search instead for 
Did you mean: 

schema object size

SOLVED
Go to solution
steven chang_1
Regular Advisor

schema object size

hello:

How can I get sum schema object size from oracle internal view .

Thank you!!

steven
1 REPLY
Thierry Poels_1
Honored Contributor
Solution

Re: schema object size

Hi,

how about:

Select owner, tablespace_name, segment_type, count(*), sum(bytes)
from dba_extents
group by owner, tablespace_name, segment_type;

good luck,
Thierry.
All unix flavours are exactly the same . . . . . . . . . . for end users anyway.