Home » RDBMS Server » Server Administration » Table Sizes
Table Sizes [message #365544] Thu, 01 October 1998 14:03 Go to next message
Kevin Rose
Messages: 6
Registered: September 1998
Junior Member
Anyone know how to tell how many bytes\meg a table occupies ? Im trying to get some type of sizing for the size of a table.
Re: Table Sizes [message #365560 is a reply to message #365544] Fri, 13 November 1998 13:56 Go to previous message
Bruce
Messages: 21
Registered: November 1998
Junior Member
Kevin,

The DBA_SEGMENTS table will give you the bytes taken up by the extents of a table. That is to say AQUIRED space, not OCCUPIED space. While you're in there, you can look at the space AQUIRED by it's indexes.

To estimate the OCCUPIED space, perform an ANALYZE COMPUTE on the table, then, from DBA_TABLES, multiply the number of rows by the average row length. This is a bit crude as not all blocks are filled to capacity but it will give you a better number than the ones from thin air.

Bruce
Previous Topic: System Requirements for Server
Next Topic: Re: explain plan
Goto Forum:
  


Current Time: Sun Oct 25 09:36:18 CDT 2020