Tablespace information can be found in the data dictionary in the views that you can find in Table 10.1. Table 10.1 is a list of data dictionary views along with a brief description of the information that can be found through those views.
Table 10.1. Data Dictionary Views of Tablespace Information
View | Description |
|---|
V$TABLESPACE | Provides the name and number of tablespaces. |
DBA_TABLESPACES | Provides descriptions of all tablespaces. |
USER_TABLESPACES | Provides descriptions of all the given user's accessible tablespaces. |
DBA_SEGMENTS | Provides information about segments associated with all tablespaces. |
USER_SEGMENTS | Provides information about segments owned by the given user's accessible tablespaces. |
DBA_EXTENTS | Provides information about data extents associated with all tablespaces. |
USER_EXTENTS | Provides information about data extents associated with all tablespaces owned by a given user. |
DBA_FREE_SPACE | Provides information about free extents associated with all tablespaces. |
USER_FREE_SPACE | Provides information about free extents associated with all the given user's accessible tablespaces. |
V$DATAFILE | Provides information about all data files, including the tablespace number of owning tablespace. This can be connected to V$TABLESPACE to get the tablespace data file correlation. |
V$TEMPFILE | Provides information about all tempfiles, including tablespace number of owning tablespace. |
DBA_DATA_FILES | Provides information on data files belonging to tablespaces. |
DBA_TEMP_FILES | Provides information on tempfiles associated with temporary tablespaces. |
DBA_USERS | Provides information about the default tablespace and temporary tablespaces for all users. |
DBA_TS_QUOTAS | Provides information concerning tablespace quotas for all users. |