O'Reilly logo

Oracle Database Administration: The Essential Refe by Brian Laskey, David C. Kreines

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required