December 2002
Intermediate to advanced
928 pages
85h 29m
English
The following views provide information about internal storage in the database, including datafiles, tablespaces, free extents, used extents, and segments:
Lists all datafiles in use by the database.
Lists every allocated extent for every segment.
Lists every free extent. This view, combined with *_EXTENTS, should account for all storage in *_ DATA_FILES.
Lists every extent that is at the start of a block of free extents.
Lists all rollback segments.
Lists all segments.
Lists all tablespaces.
Shows the granted quota and used storage in tablespaces by user.