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.
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.
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.
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.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.
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.
14.6.4 DB Invalid Objects
This metric captures owner-wise count of the invalid objects for the database.
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.