Browsing All Posts published on »March, 2008«

Find out the physical size of an Oracle table

March 2, 2008


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: 1: SELECT * FROM USER_SEGMENTS WHERE 2: SEGMENT_TYPE = 'TABLE' 3: AND SEGMENT_NAME = 'TABLE_NAME' You can do the same for index as well.