Trace: • Oracle Database - System Global Area (SGA) • Oracle Database - Shared Pool • Oracle Database - shared server architecture • Oracle Database - System Identifier (SID) • Oracle Database - skip_unusable_indexes parameter • Oracle Database - SORT_AREA_SIZE parameter • Oracle Database - SORT JOIN (or SORT MERGE JOIN) • Oracle Database - sorts (Disk) • Oracle Database - sorts (memory) statistics • Oracle Database - Space

You are here: Home » Database management system (DBMS) » Oracle Database » Oracle Database - Space

About
Articles Related
For ...
- a table

Oracle Database - Space

About

To find the space that use an object in oracle database, you can use:

the package DBMS_SPACE
or the data dictionary

Articles Related

Oracle Database

For ...

a table

An other way, perform the statisics and you can find the space for a table with this formula :

SELECT num_rows * avg_row_len FROM dba_tables

database/oracle/space.txt · Last modified: 2011/01/10 15:25 by gerardnico