- 08 Sep, 2023
- 0 Comments
- 33 Secs Read
Find largest table in oracle
As a DBA, we must know the largest tables in the database. There are many things that get impacted with the largest objects like DB performance, growth, index rebuild etc. The below query gives you the top largest tables in oracle database.
SQL Script :
1 2 3 4 5 6 7 8 9 | SELECT * FROM(selectSEGMENT_NAME,SEGMENT_TYPE,BYTES/1024/1024/1024 GB,TABLESPACE_NAMEfromdba_segmentsorder by 3 desc ); |