| Table Sizes [message #365544] |
Thu, 01 October 1998 14:03  |
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  |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
