13 Oracle Database and Database-Related Collections

The Oracle Database and Database-Related collections include the following:

13.1 Automatic Storage Management

The configuration categories and their associated configuration items for the Automatic Storage Management target type follow.

13.1.1 ASM Instance Properties

Host
Port
SID

13.2 Database Instance

The configuration categories and their associated configuration items for the Database Instance target type follow.

13.2.1 ASM Disk

This metric captures ASM Disks details which has status other than MEMBER.

This metric is applicable to the following versions of the database: 10.1.*, 10.2.*, 11.1.*, 11.2.*, and higher.

Name	Description	Data Type	Sample Value
Disk Number	Disk Number	NUMBER	1
Group Number	Group Number	NUMBER	1
Header Status	Header Status	VARCHAR2	UNKNOWN
Instance ID	Instance ID	NUMBER	1
Path	Path	VARCHAR2	ORCL:VOL3

13.2.2 Control Files

This metric is applicable to all supported versions of the database.

Change Number
Creation Date
File Name
Modification Date
OS Storage
Sequence Number
Status

13.2.3 CPU Usage Statistics

This metric is applicable to the following supported versions of the database: 10.2.*, 11.1.*, 11.2.*, and higher.

CPU core count of the database
CPU count of the database
CPU socket count of the database
Database ID
Time at which the CPU usage changed
Version

13.2.4 Data Files

This metric is applicable to all supported versions of the database.

Autoextensible
File Name
Increment
Initial Size
Maximum File Size
OS Storage
Size
Status

13.2.5 Database Autotask Client

This metric is applicable to the following versions of the database: 11.1.*, 11.2.*, and higher.

Client Name
Status

13.2.6 Database Components

This metric is applicable to all supported versions of the database except for version 8.1.7.

Component ID
Component Name
Namespace
Schema
Status
Version

13.2.7 Database Configuration Version

This metric is applicable to all supported versions of the database.

Installed Version
Collection Version

13.2.8 Database License

This metric is applicable to all supported versions of the database.

Session Current
Session Maximum
Sessions Highwater
Sessions Warning
Users Maximum

13.2.9 Database Options

This metric is applicable to all supported versions of the database.

Name
Selected

13.2.10 Database Scheduler Jobs

This metric is applicable to the following versions of the database: 10.1.* and 10.2.*.

This metric captures GATHER_STATS_JOB details from DBA_SCHEDULER_JOBS.

Name	Description	Data Type	Sample Value
Job Name	Job Name	VARCHAR2	GATHER_STATS_JOB
Owner	Owner of the object	VARCHAR2	SYS
Schedule Name	Scheduler Name	VARCHAR2	MAINTENANCE_WINDOW_GROUP
State	State	VARCHAR2	SCHEDULED

13.2.11 Database Users

This metric is applicable to all supported versions of the database.

Created
Default Tablespace
Default Temporary Tablespace
Expiry Date
Profile
User ID
User Name

13.2.12 DB Invalid Objects

This metric is applicable to all supported versions of the database.

This metric captures owner-wise count of the invalid objects for the database.

Name	Description	Data Type	Sample Value
Invalid Objects Count	Count of invalid objects	NUMBER	2
Owner	Owner of the object	VARCHAR2	SYSMAN

13.2.13 Feature Usage

This metric is applicable to all supported versions of the database.

Aux Count
Currently Used
Database ID
Detected Usages
Ever Used
Feature Information
First Usage Date
Last Sample Date
Last Sample Period
Last Usage Date
Name
Total Samples
Version

13.2.14 High Availability - General Information

This metric is applicable to all supported versions of the database.

Database Role
Dbid
Flashback On
Force Logging
Log Mode
Supplemental Logging

13.2.15 High Availability - RMAN Configuration

This metric is applicable to all supported versions of the database except for version 8.1.7.

Name
Value

13.2.16 High Water Mark Statistics

This metric is applicable to the following versions of the database: 10.1.*, 10.2.*, 11.1.*, 11.2.*, and higher.

Database ID
Highwater
Last Value
Name
Version

13.2.17 Initialization Parameters

This metric is applicable to all supported versions of the database.

Default
Name
Value

13.2.18 Instance Information

This metric is applicable to all supported versions of the database.

Archive Log Mode
Creation Date
Database Version
Database Character Set
Database Name
Database Vault Status Code
Default Temporary Tablespace
Edition
Global Name
Host
Instance Name
Instance Startup Time
Is 64bit
National Character Set
Read Only Mode
Release
Release Status
Restricted Mode
Supplemental Logging for LogMiner
Version

13.2.19 Redo Logs

This metric is applicable to all supported versions of the database.

Archived
File Name
First Change SCN
Group Number
Log Size
Members
OS Storage
Sequence Number
Status
Thread Number
Type

13.2.20 Rollback Segments

This metric is applicable to all supported versions of the database.

Average Active
Average Shrink
Extents
High Water Mark Size
Initial Size
Maximum Extents
Minimum Extents
Name
Next Size
Optimal Size
Percent Increase
Shrinks
Size
Status
Tablespace Name
Wraps

13.2.21 STATS Pack Configuration

This metric is applicable to all supported versions of the database.

Is Installed
Snapshot Frequency

13.2.22 System Global Area

This metric is applicable to all supported versions of the database.

Name
Size

13.2.23 Tablespaces

This metric is applicable to all supported versions of the database.

Allocation Type
Big File
Block Size
Contents
Extent Management
Increment
Initial Extent
Logging
Maximum Extents
Minimum Extent Size
Minimum Extents
Next Extent
Segment Space Management
Size
Status
Tablespace Name
Used Size

13.3 Oracle Cluster

The configuration categories and their associated configuration items for the Oracle Cluster target type follow.

13.3.1 Cluster Manager Configuration

Property
Value
Config File

13.3.2 High Availability Cluster Interconnect

Interface Name
Node Name
Subnet
IP Address
Is Public

13.3.3 Server Configuration

Property
Value
Config File

13.4 Oracle Listener

The configuration categories and their associated configuration items for the Oracle Listener target type follow.

13.4.1 Listener Status

TNS Address
Alias
Version
Start Date
Trace Level
Security
SNMP Status
SID List

13.5 Real Application Cluster Database

The configuration categories and their associated configuration items for the Real Application Cluster Database target type follow.

13.5.1 ASM Disk

This metric captures ASM Disks details which has status other than MEMBER.

This metric is applicable to the following versions of the database: 10.1.*, 10.2.*, 11.1.*, 11.2.*, and higher.

Name	Description	Data Type	Sample Value
Instance ID	Instance ID	NUMBER	1
Group Number	Group Number	NUMBER	1
Disk Number	Disk Number	NUMBER	1
Header Status	Header Status	VARCHAR2	UNKNOWN
Path	Path	VARCHAR2	ORCL:VOL3

13.5.2 Control Files

This metric is applicable to all supported versions of the database.

Creation Date
File Name
Status

13.5.3 CPU Usage

This metric is applicable to the following supported versions of the database: 10.2.*, 11.1.*, 11.2.*, and higher.

CPU core count of the database
CPU count of the database
CPU socket count of the database
Database ID
Time at which the CPU usage changed
Version

13.5.4 Data Files

This metric is applicable to all supported versions of the database.

Autoextensible
Database Name
File Name
Increment
Maximum File Size
OS Storage
Status

13.5.5 Database Autotask Client

This metric is applicable to the following versions of the database: 11.1.*, 11.2.*, and higher.

Client Name
Status

13.5.6 Database Components

This metric is applicable to all supported versions of the database except for version 8.1.7.

Component ID
Component Name
Namespace
Schema
Status
Version

13.5.7 Database Configuration Version

This metric is applicable to all supported versions of the database.

Collection Version
Installed Version

13.5.8 Database License

This metric is applicable to all supported versions of the database.

Session Maximum
Sessions Highwater
Sessions Warning
Users Maximum

13.5.9 Database Options

This metric is applicable to all supported versions of the database.

Name
Selected

13.5.10 Database Scheduler Jobs

This metric is applicable to the following versions of the database: 10.1.* and 10.2.*.

This metric captures GATHER_STATS_JOB details from DBA_SCHEDULER_JOBS.

Name	Description	Data Type	Sample Value
Owner	Owner of the object	VARCHAR2	SYS
Job Name	Job Name	VARCHAR2	GATHER_STATS_JOB
State	State	VARCHAR2	SCHEDULED
Schedule Name	Scheduler Name	VARCHAR2	MAINTENANCE_WINDOW_GROUP

13.5.11 Database Users

This metric is applicable to all supported versions of the database.

Created
Default Tablespace
Expiry Date
Profile
Default Temporary Tablespace
User ID
User Name

13.5.12 DB Invalid Objects

This metric is applicable to all supported versions of the database.

This metric captures owner-wise count of the invalid objects for the database.

Name	Description	Data Type	Sample Value
Owner	Owner of the object	VARCHAR2	SYSMAN
Invalid Objects Count	Count of invalid objects	NUMBER	2

13.5.13 Feature Usage

This metric is applicable to all supported versions of the database.

Aux Count
Currently Used
Database ID
Detected Usages
Ever Used
Feature Information
First Usage Date
Last Sample Date
Last Sample Period
Last Usage Date
Name
Total Samples
Version

13.5.14 High Availability - General Information

This metric is applicable to all supported versions of the database.

Database Role
Dbid
Flashback On
Force Logging
Log Mode

13.5.15 High Availability - RMAN Configuration

This metric is applicable to all supported versions of the database except for version 8.1.7.

Name
Value

13.5.16 High-Water Mark Statistics

This metric is applicable to the following versions of the database: 10.1.*, 10.2.*, 11.1.*, 11.2.*, and higher.

Database ID
Highwater
Last Value
Name
Version

13.5.17 Instance Information

This metric is applicable to all supported versions of the database.

Archive Log Mode
Creation Date
Database Character Set
Database Name
Database Version
Default Temporary Tablespace
Edition
Host
Is 64bit
Global Name
Instance Name
Instance Startup Time
National Character Set
Read Only Mode
Release
Release Status
Restricted Mode
Supplemental Logging
Version

13.5.18 Redo Logs

This metric is applicable to all supported versions of the database.

Archived
File Name
First Change SCN
Group Num
Log Size
Members
OS Storage
Sequence Num
Status
Thread Number
Type

13.5.19 Rollback Segments

This metric is applicable to all supported versions of the database.

Average Active
Average Shrink
Extents
High Water Mark Size
Initial Size
Next Size
Maximum Extents
Minimum Extents
Name
Optimal Size
Percent Increase
Shrinks
Size
Status
Tablespace Name
Wraps

13.5.20 STATS Pack Configuration

This metric is applicable to all supported versions of the database.

Is Installed
Snapshot Frequency

13.5.21 Tablespaces

This metric is applicable to all supported versions of the database.

13.5.22 Voting Disk

This metric is applicable to the following supported versions of the database: 10.2.*, 11.1.*, 11.2.*, and higher.

This metric captures all the clusterware voting disk locations for Real Application Cluster Database.

Name	Description	Data Type	Sample Value
Voting Disk Location	Voting Disk Location on Real Application Cluster Database	VARCHAR2	/oradbshare/storage/vdisk