Find out the physical size of an Oracle table

Posted on March 2, 2008

0


In order to find out the physical size of an oracle table, you can query system table USER_SEGMENTS. The following SQL returns all storage infomation about a table in Oracle:

SELECT * FROM USER_SEGMENTS WHERE 
         SEGMENT_TYPE = 'TABLE' 
             AND SEGMENT_NAME = 'TABLE_NAME'

You can do the same for index as well.

Posted in: Development