11 Oracle Database and Database-Related Collections

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

11.1 Automatic Storage Management

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

11.1.1 ASM Instance Properties

Host
Port
SID

11.2 Cluster Database

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

11.2.1 Database Configuration Version

Installed Version
Collection Version

11.2.2 Control Files

File Name
Status
Creation Date

11.2.3 CPU Usage

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

11.2.4 Data Files

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

11.2.5 Instance Information

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

11.2.6 Feature Usage

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

11.2.7 High-Water Mark

Name
Version
Highwater
Last Value
Database ID

11.2.8 Database License

Session Maximum
Sessions Warning
Sessions Highwater
Users Maximum

11.2.9 Database Options

Name
Selected

11.2.10 Redo Logs

Group Number
Members
File Name
Log Size
Thread Number

11.2.11 Rollback Segments

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

11.2.12 Tablespaces

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

11.2.13 Database Users

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

11.2.14 High Availability - Database Files

Name
Total Size

11.2.15 High Availability - General Information

Dbid
Log Mode
Force Logging
Database Role
Flashback On

11.2.16 High Availability - Initialization Parameters

Name
Value

11.2.17 High Availability - RMAN Configuration

Name
Value

11.2.18 STATS Pack Configuration

Is Installed
Snapshot Frequency

11.3 Database Instance

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

11.3.1 ASM Disk

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

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

11.3.2 Control Files

File Name
Status
Creation Date

11.3.3 CPU Usage

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

11.3.4 Database Components

Namespace
Component ID
Component Name
Version
Status
Schema

11.3.5 Database Configuration Version

Installed Version
Collection Version

11.3.6 Database License

Session MaximumSessions WarningSessions HighwaterUsers Maximum

11.3.7 Database Options

Name
Selected

11.3.8 Database Scheduler Jobs

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
Owner	Owner of the object	VARCHAR2	SYS

11.3.9 Database Users

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

11.3.10 Data Files

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

11.3.11 DB Invalid Objects

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

11.3.12 Feature Usage

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

11.3.13 High Availability - Database Files

Name
Total Size

11.3.14 High Availability - General Information

Dbid
Log Mode
Force Logging
Database Role
Flashback On

11.3.15 High Availability - Initialization Parameters

Name
Value

11.3.16 High Availability - RMAN Configuration

Name
Value

11.3.17 High-Water Mark

Name
Version
Highwater
Last Value
Database ID

11.3.18 Initialization Parameters

Name
Value
Is Default

11.3.19 Instance Information

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

11.3.20 MGMT_DB_CPU_USAGE_ECM

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

11.3.21 MGMT_DB_USERS_ECM

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

11.3.22 Redo Logs

Group Num
Status
Members
File Name
Archived
Log Size
Sequence Num
First Change SCN
OS Storage
Thread Num
Type - Type of Redo logs

11.3.23 Rollback Segments

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

11.3.24 STATS Pack Configuration

Is Installed
Snapshot Frequency

11.3.25 System Global Area

Name
Size

11.3.26 Tablespaces

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

11.4 Oracle Cluster

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

11.4.1 Cluster Manager Configuration

Property
Value
Config File

11.4.2 High Availability Cluster Interconnect

Interface Name
Node Name
Subnet
IP Address
Is Public

11.4.3 Server Configuration

Property
Value
Config File

11.5 Oracle Listener

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

11.5.1 Listener Status

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

11.6 RAC Database

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

11.6.1 ASM Disk

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

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

11.6.2 Database Components

Namespace
Component ID
Component Name
Version
Status
Schema

11.6.3 Database Scheduler Jobs

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

11.6.4 DB Invalid Objects

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

11.6.5 MGMT_DB_CPU_USAGE_ECM

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

11.6.6 MGMT_DB_USERS_ECM

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

11.6.7 Redologs

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

11.6.8 Voting Disk

This metric captures all the clusterware voting disk locations for RAC Database.

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