Thursday, November 17, 2011

Query to find the 10 Largest Objects in DB

 
SELECT * FROM
(
select
SEGMENT_NAME,
SEGMENT_TYPE,
BYTES/1024/1024/1024 GB,
TABLESPACE_NAME
from
dba_segments
order by 3 desc
) WHERE
ROWNUM <= 10

0 comments:

Post a Comment