Skip Headers

Oracle® Configuration Manager Collection Overview Release 10.3.5 Part Number E22052-01 |
Home | Book List | Contents | Contact Us

Previous | Next
| PDF · Mobi · ePub

# 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