Asset Reporting - Tablespaces

 

Use this report to view information about the Oracle tablespaces within your environment:

Tablespace Information tab

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

 

 

Data File Information tab

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