Use this report to view information about the Oracle tablespaces within your environment:
Field Name |
Description |
Name |
name of a tablespace |
Owner |
owner of a tablespace |
RDBMS Type |
RDBMS to which a tablespace belongs |
Status |
indicates whether a tablespace is online or offline |
Temporary Tablespace |
indicates whether a tablespace is temporary |
Logging Turned On |
indicates whether logging is turned on for a tablespace |
Total Size of All Storage |
total amount of storage space consumed by the tablespace |
Free Space of Data Files |
amount of free space available in the data file(s) associated with the tablespace |
Total Size of Empty Used Space |
total size of storage allocated to the tablespace but is not currently being used |
Number of Data Files |
number of data files associated with a tablespace |
Number of Tables |
number of tables associated with a tablespace |
Number of Indexes |
number of indexes associated with a tablespace |
Number of Other Objects |
number of user-created objects that are not tables or indexes, such as rollback segments |
Minimum Extent Size |
smallest size of an extent that can be allocated to a segment |
Default Initial Extent Size |
size of the initial extent allocated to an object |
Default Incremental Extent Size |
size of subsequent extents after existing extents fill up with data |
Default Minimum Number of Extents |
minimum number of extents that can be allocated to an object |
Default Maximum Number of Extents |
maximum number of extents that can be allocated to an object |
Default Percent Increase for Extent Size |
percent by which the size of extents increases as more extents are added |
Block Size |
amount of storage space allocated to each of the blocks in a tablespace |
Total Number of Free Extents |
number of extents in a tablespace that are not allocated to any object |
Total Number of Coalesced Free Extents |
total number of non-contiguous extents that are not allocated to any object |
Size of Smallest Free Extent |
size of the smallest free extent in a tablespace |
Size of Largest Free Extent |
size of the largest free extent in a tablespace |
Discovered Time |
date/time when a tablespace was discovered |
Scan Time |
date/time when a tablespace was last scanned |
Dropped Time |
date/time when a tablespace was dropped |
Use this tab to view information about the data files associated with a tablespace.
Field Name |
Description |
Computer |
name of the computer on which the data file resides |
RDBMS Instance |
name of the Instance on which a data file resides |
Database |
name of the database with which a data file is associated |
Tablespace |
name of a tablespace to which a data file is associated |
Data File Path |
fully-qualified path to the physical data file |
Used Space |
amount of storage space consumed by a data file |
Percent Used |
percentage of allocated space that a data file is consuming |
Free Space |
amount of free space available in a data file |
Total Size |
total size of a data file (Used Space + Freespace) |
Free Extents |
number of free extents associated with a tablespace's data file |
Coalesced Extents |
number of coalesced extents associated with a tablespace's data file |
Minimum Free Extent Size |
minimum size for an extent allocated to a data file |
Maximum Free Extent Size |
maximum size for an extent allocated to a data file |
Status |
indicates the status of a tablespace (e.g., offline, online, etc.) |
Auto Extend |
indicates whether Oracle should automatically increase the size of data files when they fill up with data |
Maximum Size |
maximum size to which Oracle will auto extend a data file |
Create Time |
date/time when a data file was created |
Discovered Time |
date/time when a data file was discovered |