Sunday, June 22, 2014

Oracle: 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

1 comment:

  1. This is one of the most incredible article I've read in a really long time. I hope you update this blog often because I’m anxious to read more about.
    stitching price list
    ladies kurti stitching

    ReplyDelete