Hello,
Can you please tell me how to write a sql statement to fetch the top 10 table sizes (Bytes) in the table DBA_SEGMENTS.
Thanks,
NIkee
Printable View
Hello,
Can you please tell me how to write a sql statement to fetch the top 10 table sizes (Bytes) in the table DBA_SEGMENTS.
Thanks,
NIkee
something like this --
select substr(segment_name,1,30), bytes from (select segment_name, bytes from dba_segments order by bytes desc) where rownum < 11
- Rajeev
Thank you.
-Nikee