Database Object for Database space usage

As salamo alaikum wa rahmatullah

DBA_TABLESPACES
DBA_SEGMENTS
DBA_EXTENTS
DBA_FREE_SPACE
DBA_LMT_FREE_SPACE
DBA_THRESHOLDS
DBA_OUTSTANDING_ALERTS
DBA_ALERT_HISTORY
V$ALERT_TYPES

-> select reason_id, object_type, scope, internal_metric_category,
internal_metric_name from v$alert_types
where group_name = 'Space';


Sample select queries.

-> select tablespace_name, block_size, contents, extent_management from dba_tablespaces;

-> select tablespace_name, count(*) NUM_OBJECTS,sum(bytes), sum(blocks), sum(extents) from dba_segments group by rollup (tablespace_name);

-> select owner, segment_name, tablespace_name,extent_id, file_id, block_id, bytes from dba_extents where segment_name = 'XXX$';

-> select tablespace_name, sum(bytes) from dba_free_space group by tablespace_name;

--

Thanks and Regards

Mohammad Shahanwaz

oracle's passion