Storage Structure Information in the Data Dictionary
The interrelation between the tablespaces, their data files, segments, and free and used extents can be examined by querying the data dictionary. The views that you can use to find information on tablespace are in the following sections.
DBA_TABLESPACES
When a tablespace with one or more files is created, a single row is created in DBA_TABLESPACES. This view provides information that allows you to determine the status, type, and space usage of the tablespace.
DBA_DATA_FILES
For every single file associated with a tablespace in the database, online or offline, a row is added to DBA_DATA_FILES. The following query can be used to find information on the data files associated with the tablespaces ...
Get Oracle 9i Fundamentals I Exam Cram™ 2 (Exam 1Z0-031) 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.
