HPE Community
Operating System - HP-UX
1828411 Members
3423 Online
109977 Solutions
New Discussion

schema object size

 
SOLVED
Go to solution
steven chang_1
Regular Advisor

‎02-17-2004 08:04 PM

‎02-17-2004 08:04 PM

schema object size

hello:

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

Thank you!!

steven
0 Kudos
Reply
1 REPLY 1
Thierry Poels_1
Honored Contributor

‎02-17-2004 08:31 PM

‎02-17-2004 08:31 PM

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.
Reply
The opinions expressed above are the personal opinions of the authors, not of Hewlett Packard Enterprise. By using this site, you accept the Terms of Use and Rules of Participation.