Subscribe:
RSS feed
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.
March 2, 2008
0