System Wide - Databases-Tablespaces

 

Use these reports to view the following information about the databases and tablespaces within your environment:

Field Name

Description

Database Tablespace

name of a database or tablespace

Computer

name of the computer on which a database or tablespace resides

Instance

Instance under which a database or tablespace is running

RDBMS Type

RDBMS under which a database or tablespace is running (e.g., Sybase, Oracle, SQL Server, etc.)

Total Size

amount of storage allocated to a database or tablespace

Data Free Space

amount of free space in a database or tablespace

Log Free Space

amount of free space in the logs of a database or tablespace

Empty Used Space

amount space that is allocated to database or tablespace but is not currently being used

Number Files

number of data files or fragments associated with a database or  tablespace

Table Count

number of tables associated with a database or tablespace

Index Count

number of index associated with a database or tablespace

Other Count

number of other objects associated with a database or tablespace

Block/Page Size

amount of storage space allocated to each of the blocks or pages in a tablespace or database

Status

indicates the status of a database or tablespace (e.g., offline, online, etc.)

Discovered Time

date/time when database or  tablespace was discovered

Scan Time

date/time when the database or tablespace was last scanned

Dropped Time

date/time when the database or tablespace was dropped