14 Oracle Database and Database-Related Collections

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

14.1 Automatic Storage Management

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

14.1.1 ASM Instance Properties

Host
Port
SID

14.2 Cluster Database

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

14.2.1 Database Configuration Version

Installed Version
Collection Version

14.2.2 Control Files

File Name
Status
Creation Date

14.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

14.2.4 Data Files

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

14.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

14.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

14.2.7 High-Water Mark

Name
Version
Highwater
Last Value
Database ID

14.2.8 Database License

Session Maximum
Sessions Warning
Sessions Highwater
Users Maximum

14.2.9 Database Options

Name
Selected

14.2.10 Redo Logs

Group Number
Members
File Name
Log Size
Thread Number

14.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

14.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

14.2.13 Database Users

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

14.2.14 High Availability - Database Files

Name
Total Size

14.2.15 High Availability - General Information

Dbid
Log Mode
Force Logging
Database Role
Flashback On

14.2.16 High Availability - Initialization Parameters

Name
Value

14.2.17 High Availability - RMAN Configuration

Name
Value

14.2.18 STATS Pack Configuration

Is Installed
Snapshot Frequency

14.3 Database Instance

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

14.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

14.3.2 Control Files

File Name
Status
Creation Date

14.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

14.3.4 Database Components

Namespace
Component ID
Component Name
Version
Status
Schema

14.3.5 Database Configuration Version

Installed Version
Collection Version

14.3.6 Database License

Session MaximumSessions WarningSessions HighwaterUsers Maximum

14.3.7 Database Options

Name
Selected

14.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

14.3.9 Database Users

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

14.3.10 Data Files

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

14.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

14.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

14.3.13 High Availability - Database Files

Name
Total Size

14.3.14 High Availability - General Information

Dbid
Log Mode
Force Logging
Database Role
Flashback On

14.3.15 High Availability - Initialization Parameters

Name
Value

14.3.16 High Availability - RMAN Configuration

Name
Value

14.3.17 High-Water Mark

Name
Version
Highwater
Last Value
Database ID

14.3.18 Initialization Parameters

Name
Value
Is Default

14.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

14.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

14.3.21 MGMT_DB_USERS_ECM

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

14.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

14.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

14.3.24 STATS Pack Configuration

Is Installed
Snapshot Frequency

14.3.25 System Global Area

Name
Size

14.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

14.4 Oracle Cluster

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

14.4.1 Cluster Manager Configuration

Property
Value
Config File

14.4.2 High Availability Cluster Interconnect

Interface Name
Node Name
Subnet
IP Address
Is Public

14.4.3 Server Configuration

Property
Value
Config File

14.5 Oracle Listener

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

14.5.1 Listener Status

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

14.6 RAC Database

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

14.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

14.6.2 Database Components

Namespace
Component ID
Component Name
Version
Status
Schema

14.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

14.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

14.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

14.6.6 MGMT_DB_USERS_ECM

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

14.6.7 Redologs

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

14.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