Oracle Database - Space (Size)

Card Puncher Data Processing

About

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




Discover More
Card Puncher Data Processing
Oracle Database

Documentation about the Oracle database
Oracle Segment Extent Data Block
Oracle Database - (Fragmented) (Unused|Free) space (Reclaim|Shrink|resize)

Used and free space. A data file contains ordered extents (by block Id). One segments is made up of one of several extents (not ordered, contiguous). Over time, updates and deletes on objects within...
Card Puncher Data Processing
Oracle Database - DBMS_SPACE Package

The UNUSED_SPACE procedure of the DBMS_SPACE package returns space information on a segment: the position of the high water mark (ie the last block within the extent which contains data) and the amount...
Card Puncher Data Processing
Oracle Database - Table Size

How to calculate the space of a table ? Then: The above shows us: we have 55 blocks allocated to the table 53 blocks are totally empty (above the HWM) 1 block contains data (the other block...



Share this page:
Follow us:
Task Runner