Storage
These views provide information about internal storage in the database, including datafiles, tablespaces, free extents, used extents, and segments:
- DBA_DATA_FILES
Lists all data files in use by the database.
- DBA_EXTENTS
Lists every allocated extent for every segment.
- DBA_FREE_SPACE
Lists every free extent. With DBA_EXTENTS, should account for all storage in DBA_DATA_FILES.
- DBA_FREE_SPACE_COALESCED
Lists every extent that is at the start of a block of free extents.
- DBA_ROLLBACK_SEGS
Lists all rollback segments.
- DBA_SEGMENTS
Lists all segments.
- DBA_TABLESPACES
Lists all tablespaces.
- DBA_TS_QUOTAS
Shows the granted quota and used storage in tablespaces by user.
Get Oracle Database Administration: The Essential Refe now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.