Contents

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documents
• Conventions

How to Use This Manual

• Structure of the Oracle Database Plug-in Metric Reference Manual
• About Metrics, Thresholds, and Alerts

1 Cluster ASM Metrics

• 1.1 ASM Cardinality
  • 1.1.1 Open Instance Count
• 1.2 ASM Cluster File System
  • 1.2.1 ASM Cluster File System Corrupt
  • 1.2.2 ASM Cluster File System Used (%)
  • 1.2.3 Allocated Space (GB)
  • 1.2.4 Free (GB)
  • 1.2.5 Size (GB)
  • 1.2.6 Snapshot Space Used (MB)
  • 1.2.7 Used (GB)
  • 1.2.8 Used (MB)
  • 1.2.9 Volume Name
• 1.3 ASM Cluster File System State
  • 1.3.1 ASM Cluster File System Availability
  • 1.3.2 ASM Cluster File System Available Time
  • 1.3.3 Mount Point
  • 1.3.4 ASM Cluster File System Mount State
• 1.4 ASM Disk
  • 1.4.1 Disk
  • 1.4.2 Disk Creation Date
  • 1.4.3 Disk Group
  • 1.4.4 Disk Path
  • 1.4.5 Fail Group Type
  • 1.4.6 Failure Group
  • 1.4.7 Redundancy
  • 1.4.8 Size (MB)
• 1.5 ASM Disk Group
  • 1.5.1 Allocation Unit (MB)
  • 1.5.2 Contains Voting Files
  • 1.5.3 Disk Count
  • 1.5.4 Disk Group
  • 1.5.5 Redundancy
  • 1.5.6 Size (GB)
• 1.6 ASM Disk Group Attributes
  • 1.6.1 Attribute Name
  • 1.6.2 Disk Group Name
  • 1.6.3 Value
• 1.7 ASM INIT Params
  • 1.7.1 Default
  • 1.7.2 Name
  • 1.7.3 Value
• 1.8 ASM Volumes
  • 1.8.1 Allocated Space (GB)
  • 1.8.2 Mount Point
  • 1.8.3 Redundancy
  • 1.8.4 Size (GB)
  • 1.8.5 Status
  • 1.8.6 Usage
  • 1.8.7 Volume Name
• 1.9 Checker Failure
  • 1.9.1 Alert Log Name
  • 1.9.2 Checker Failure Detected
  • 1.9.3 Number of Failures
• 1.10 Cluster Volume Performance
  • 1.10.1 I/O Response Time
  • 1.10.2 I/O Per Second
  • 1.10.3 I/O Size (MB)
  • 1.10.4 I/O Throughput
  • 1.10.5 Read Errors
  • 1.10.6 Read Response Time (MS)
  • 1.10.7 Read Size (MB)
  • 1.10.8 Read Throughput
  • 1.10.9 Reads Per Second
  • 1.10.10 Write Errors
  • 1.10.11 Write Response Time (MS)
  • 1.10.12 Write Size (MB)
  • 1.10.13 Write Throughput
  • 1.10.14 Writes Per Second
• 1.11 Database Disk Group Usage
  • 1.11.1 Total Bytes
• 1.12 Disk Group Imbalance Status
  • 1.12.1 Actual Imbalance (%)
  • 1.12.2 Actual Minimum Percent Free
  • 1.12.3 Disk Count
  • 1.12.4 Disk Group Percent Imbalance
  • 1.12.5 Disk Maximum Used (%) with Rebalance
  • 1.12.6 Disk Minimum Free (%) without Rebalance
  • 1.12.7 Disk Size Variance (%)
  • 1.12.8 Rebalance In Progress
  • 1.12.9 Resync In Progress
• 1.13 Disk Group Target Component
  • 1.13.1 Disk Group Name
  • 1.13.2 Disk Count
• 1.14 Disk Group Usage
  • 1.14.1 Disk Group Free (MB)
  • 1.14.2 Disk Group Usable (Free MB)
  • 1.14.3 Disk Group Usable (MB)
  • 1.14.4 Disk Group Used %
  • 1.14.5 Redundancy
  • 1.14.6 Size (MB)
  • 1.14.7 Used % of Safely Usable
• 1.15 Disk Path
  • 1.15.1 Disk Name
  • 1.15.2 Disk Path
  • 1.15.3 Group Name
• 1.16 Disk Status
  • 1.16.1 Disk Mode Status
• 1.17 Failure Group Imbalance Status
  • 1.17.1 Disk Count Imbalance Variance
  • 1.17.2 Disk Size Imbalance (%)
  • 1.17.3 Failure Group Count
• 1.18 Failure Group Status
  • 1.18.1 Available Disks
  • 1.18.2 Disk Count for Alerts
  • 1.18.3 Disk Count
  • 1.18.4 Online Disk Count for Failure Group with More than 1 Disk
• 1.19 Instance Disk Performance
  • 1.19.1 Bytes Read
  • 1.19.2 Bytes Written
  • 1.19.3 Last Read Errors
  • 1.19.4 Read Errors
  • 1.19.5 Read Response Time (MS)
  • 1.19.6 Read Time (MS)
  • 1.19.7 Write Errors
  • 1.19.8 Reads
  • 1.19.9 I/O Response Time (MS)
  • 1.19.10 Total I/O Time (MS)
  • 1.19.11 Write Response Time (MS)
  • 1.19.12 Write Time (MS)
  • 1.19.13 Writes
• 1.20 Instance Disk Group Database Performance
  • 1.20.1 Bytes Read
  • 1.20.2 Bytes Written
  • 1.20.3 Read Time (MS)
  • 1.20.4 Reads
  • 1.20.5 Write Time (MS)
  • 1.20.6 Writes
• 1.21 Instance Disk Group Performance
  • 1.21.1 Bytes Read
  • 1.21.2 Bytes Written
  • 1.21.3 Read Time (MS)
  • 1.21.4 Reads
  • 1.21.5 Write Time (MS)
  • 1.21.6 Writes
• 1.22 Instance Volume Performance
  • 1.22.1 I/O Per Second
  • 1.22.2 I/O Response Time
  • 1.22.3 I/O Throughput
  • 1.22.4 I/O Size (MB)
  • 1.22.5 Read Errors
  • 1.22.6 Read Response Time (MS)
  • 1.22.7 Read Size (MB)
  • 1.22.8 Read Throughput
  • 1.22.9 Reads Per Second
  • 1.22.10 Write Errors
  • 1.22.11 Write Response Time (MS)
  • 1.22.12 Write Size (MB)
  • 1.22.13 Write Throughput
  • 1.22.14 Writes Per Second
• 1.23 Offline Disk Count
  • 1.23.1 Offline Disk Count
• 1.24 Response
  • 1.24.1 Status

2 Automatic Storage Management

• 2.1 Alert Log
  • 2.1.1 Alert Log Error Stack
  • 2.1.2 Alert Log Error Stack Trace File Name
  • 2.1.3 Alert Log Name
  • 2.1.4 Archive Hung Error Stack
  • 2.1.5 Data Block Corruption Error Stack
  • 2.1.6 Media Failure Error Stack
  • 2.1.7 Session Terminated Error Stack
• 2.2 Alert Log Error Status
  • 2.2.1 Archiver Hung Alert Log Error Status
  • 2.2.2 Data Block Corruption Alert Log Error Status
  • 2.2.3 Generic Alert Log Error Status
  • 2.2.4 Media Failure Alert Log Error Status
  • 2.2.5 Session Terminated Alert Log Error Status
• 2.3 ASM Alert Log
  • 2.3.1 Alert Log Error Stack
  • 2.3.2 Alert Log Error Stack Trace File Name
  • 2.3.3 Alert Log Name
  • 2.3.4 Archive Hung Error Stack
  • 2.3.5 Data Block Corruption Error Stack
  • 2.3.6 Media Failure Error Stack
  • 2.3.7 Session Terminated Error Stack
• 2.4 ASM Cluster File System
  • 2.4.1 ASM Cluster File System Corrupt
  • 2.4.2 ASM Cluster File System Used (%)
  • 2.4.3 Allocated Space (GB)
  • 2.4.4 Free (GB)
  • 2.4.5 Size (GB)
  • 2.4.6 Snapshot Space Used (MB)
  • 2.4.7 Used (GB)
  • 2.4.8 Used (MB)
  • 2.4.9 Volume Name
• 2.5 ASM Cluster File System State
  • 2.5.1 ASM Cluster File System Availability
  • 2.5.2 ASM Cluster File System Mount State
  • 2.5.3 Mount Point
  • 2.5.4 ASM Cluster File System Available Time
• 2.6 ASM Volumes
  • 2.6.1 Allocated Space (GB)
  • 2.6.2 Redundancy
  • 2.6.3 Size (GB)
  • 2.6.4 Usage
  • 2.6.5 Volume Name
• 2.7 Checker Failure
  • 2.7.1 Alert Log Name
  • 2.7.2 Checker Failure Detected
  • 2.7.3 Number of Failures
• 2.8 Cluster Volume Performance
  • 2.8.1 I/O Response Time
  • 2.8.2 I/O Per Second
  • 2.8.3 I/O Size (MB)
  • 2.8.4 I/O Throughput
  • 2.8.5 Read Errors
  • 2.8.6 Read Response Time (MS)
  • 2.8.7 Read Size (MB)
  • 2.8.8 Read Throughput
  • 2.8.9 Reads Per Second
  • 2.8.10 Write Errors
  • 2.8.11 Write Response Time (MS)
  • 2.8.12 Write Size (MB)
  • 2.8.13 Write Throughput
  • 2.8.14 Writes Per Second
• 2.9 Database Disk Group Usage
  • 2.9.1 Total Bytes
• 2.10 Database Sparse Disk Group Usage
  • 2.10.1 Database Name
  • 2.10.2 Disk Group Name
  • 2.10.3 Total Physical Bytes
• 2.11 Disk Group Imbalance Status
  • 2.11.1 Actual Imbalance (%)
  • 2.11.2 Actual Minimum Percent Free
  • 2.11.3 Disk Count
  • 2.11.4 Disk Group Percent Imbalance
  • 2.11.5 Disk Maximum Used (%) with Rebalance
  • 2.11.6 Disk Minimum Free (%) without Rebalance
  • 2.11.7 Rebalance In Progress
  • 2.11.8 Resync In Progress
• 2.12 Disk Group Status
  • 2.12.1 State
  • 2.12.2 Disk Group Name
• 2.13 Disk Group Usage
  • 2.13.1 Disk Group Name
  • 2.13.2 Disk Group Free (MB)
  • 2.13.3 Disk Group Usable (MB)
  • 2.13.4 Disk Group Usable Free (MB)
  • 2.13.5 Disk Group Used %
  • 2.13.6 Redundancy
  • 2.13.7 Size (MB)
  • 2.13.8 Used % of Safely Usable
• 2.14 Disk Path
  • 2.14.1 Disk Name
  • 2.14.2 Disk Path
  • 2.14.3 Group Name
• 2.15 Disk Status
  • 2.15.1 Disk Mode Status
• 2.16 Disks
  • 2.16.1 Disk
  • 2.16.2 Disk Creation Date
  • 2.16.3 Disk Group
  • 2.16.4 Disk Path
  • 2.16.5 Failure Group Name
  • 2.16.6 Failure Group Type
  • 2.16.7 Redundancy
  • 2.16.8 Size (MB)
• 2.17 Failure Group Imbalance Status
  • 2.17.1 Disk Count Imbalance Variance
  • 2.17.2 Disk Size Imbalance (%)
  • 2.17.3 Failure Group Count
• 2.18 Failure Group Status
  • 2.18.1 Available Disks
  • 2.18.2 Disk Count
  • 2.18.3 Online Disk Count for Failure Group with More than 1 Disk
• 2.19 Incident
  • 2.19.1 Access Violation
  • 2.19.2 Alert Log Error Trace File
  • 2.19.3 Alert Log Name
  • 2.19.4 ASM Block Corruption
  • 2.19.5 Cluster Error
  • 2.19.6 Deadlock
  • 2.19.7 ECID
  • 2.19.8 File Access Error
  • 2.19.9 Generic Incident
  • 2.19.10 Generic Internal Error
  • 2.19.11 Impact
  • 2.19.12 Incident ID
  • 2.19.13 Internal SQL Error
  • 2.19.14 Out of Memory
  • 2.19.15 Redo Log Corruption
  • 2.19.16 Session Terminated
• 2.20 Instance Disk Performance
  • 2.20.1 Bytes Read
  • 2.20.2 Bytes Written
  • 2.20.3 I/O Response Time (MS)
  • 2.20.4 Last Read Errors
  • 2.20.5 Read Errors
  • 2.20.6 Read Response Time (MS)
  • 2.20.7 Read Time (MS)
  • 2.20.8 Total I/O Time (MS)
  • 2.20.9 Write Errors
  • 2.20.10 Write Response Time (MS)
  • 2.20.11 Write Time (MS)
• 2.21 Instance Diskgroup Database Performance
  • 2.21.1 Bytes Read
  • 2.21.2 Bytes Written
  • 2.21.3 Read Time (MS)
  • 2.21.4 Reads
  • 2.21.5 Writes
  • 2.21.6 Write Time (MS)
• 2.22 Instance Diskgroup Performance
  • 2.22.1 Bytes Read
  • 2.22.2 Bytes Written
  • 2.22.3 Read Time (MS)
  • 2.22.4 Reads
  • 2.22.5 Write Time (MS)
  • 2.22.6 Writes
• 2.23 Instance Volume Performance
  • 2.23.1 I/O Per Second
  • 2.23.2 I/O Size (MB)
  • 2.23.3 I/O Throughput
  • 2.23.4 Read Response Time (MS)
  • 2.23.5 Read Size (MB)
  • 2.23.6 Read Throughput
  • 2.23.7 Read Write Errors
  • 2.23.8 Reads Per Second
  • 2.23.9 Response Time (MS)
  • 2.23.10 Write Response Time (MS)
  • 2.23.11 Write Size (MB)
  • 2.23.12 Write Throughput
  • 2.23.13 Writes Per Second
• 2.24 Offline Disk Count
  • 2.24.1 Offline Disk Count
• 2.25 Operational Error
  • 2.25.1 Setting Thresholds for Operational Error Metrics
  • 2.25.2 Alert Log Error Trace File
  • 2.25.3 Alert Log Name
  • 2.25.4 Data Block Corruption
  • 2.25.5 Generic Operational Error
  • 2.25.6 Media Failure
• 2.26 Response
  • 2.26.1 Status
• 2.27 Sparse Disk Group Usage
  • 2.27.1 Disk Group Physical Free (MB)
  • 2.27.2 Disk Group Physical Used (%)
  • 2.27.3 Physical Size (MB)

3 Oracle High Availability Service

• 3.1 CRS nodeapp Status
  • 3.1.1 nodeapp Status
• 3.2 CRS Virtual IP Relocation Status
  • 3.2.1 Virtual IP Relocated
• 3.3 Incident
  • 3.3.1 Alert Log Error Trace File
  • 3.3.2 Alert Log Name
  • 3.3.3 ECID
  • 3.3.4 Impact
  • 3.3.5 Incident ID
  • 3.3.6 Generic Incident
  • 3.3.7 Generic Internal Error
• 3.4 Operational Error
  • 3.4.1 Generic Operational Error
  • 3.4.2 User-Defined Error
  • 3.4.3 User-Defined Warning
• 3.5 Oracle High Availability Service Alert Log
  • 3.5.1 Alert Log Name
  • 3.5.2 CRS Resource Alert Log Error
  • 3.5.3 OCR Alert Log Error
  • 3.5.4 OLR Alert Log Error
  • 3.5.5 Oracle High Availability Service Alert Log Error
• 3.6 Oracle High Availability Service Alert Log Error
  • 3.6.1 Alert Log Name
  • 3.6.2 Alert Time
  • 3.6.3 OCR Alert Log Error
  • 3.6.4 OLR Alert Log Error
  • 3.6.5 CRS Resource Alert Log Error
  • 3.6.6 Oracle High Availability Service Alert Log Error
  • 3.6.7 Witnessed Error Codes
  • 3.6.8 Node Configuration Alert Log Error
  • 3.6.9 Time/Line Number
• 3.7 Resource State
  • 3.7.1 State Change
• 3.8 Response
  • 3.8.1 Status

4 Cluster

• 4.1 Clusterware
  • 4.1.1 Cluster Verification Output
  • 4.1.2 Clusterware Status
• 4.2 Clusterware Alert Log
  • 4.2.1 Clusterware Service Alert Log Error
  • 4.2.2 Node Configuration Alert Log Error
  • 4.2.3 OCR Alert Log Error
  • 4.2.4 Voting Disk Alert Log Error
• 4.3 QoS Events
  • 4.3.1 Compliance State
  • 4.3.2 Memory Pressure Analysis Risk State
  • 4.3.3 QoSM State Change
• 4.4 Resource State
  • 4.4.1 State Change

5 Database Instance

• 5.1 Alert Log
  • 5.1.1 Alert Log Error Trace File
  • 5.1.2 Alert Log Name
  • 5.1.3 Archiver Hung Alert Log Error
  • 5.1.4 Data Block Corruption Alert Log Error
  • 5.1.5 Generic Alert Log Error
  • 5.1.6 Media Failure Alert Log Error
  • 5.1.7 Session Terminated Alert Log Error
• 5.2 Alert Log Error Status
  • 5.2.1 Archiver Hung Alert Log Error Status
  • 5.2.2 Data Block Corruption Alert Log Error Status
  • 5.2.3 Generic Alert Log Error Status
  • 5.2.4 Media Failure Alert Log Error Status
  • 5.2.5 Session Terminated Alert Log Error Status
• 5.3 Archive Area
  • 5.3.1 Archive Area Used (%)
  • 5.3.2 Archive Area Used (KB)
  • 5.3.3 Free Archive Area (KB)
  • 5.3.4 Total Archive Area (KB)
• 5.4 Collect SQL Response Time
  • 5.4.1 SQL Response Time (%)
• 5.5 Data Failure
  • 5.5.1 Alert Log Name
  • 5.5.2 Data Failure Detected
• 5.6 Data Guard Status
  • 5.6.1 Data Guard Status
• 5.7 Data Guard - 9.2 Database
  • 5.7.1 Data Not Applied (logs)
  • 5.7.2 Data Not Received (logs)
  • 5.7.3 Data Guard Status - 9.2 Database
• 5.8 Data Guard - 10.1 Database
  • 5.8.1 Data Guard Status - 10.1 Database
  • 5.8.2 Data Not Applied (logs)
  • 5.8.3 Data Not Applied (MB)
  • 5.8.4 Data Not Received (logs)
  • 5.8.5 Data Not Received (MB)
• 5.9 Data Guard Fast-Start Failover
  • 5.9.1 Fast-Start Failover Occurred
• 5.10 Data Guard Fast-Start Failover Observer
  • 5.10.1 Observer Status
• 5.11 Data Guard Fast-Start Failover Observer - 10.2 Database
  • 5.11.1 Observer Status - 10.2 Database
• 5.12 Data Guard Performance
  • 5.12.1 Apply Lag (seconds)
  • 5.12.2 Estimated Failover Time (seconds)
  • 5.12.3 Redo Apply Rate (KB/second)
  • 5.12.4 Redo Generation Rate (KB/second)
  • 5.12.5 Transport Lag (seconds)
• 5.13 Data Guard Performance - 11.1 and Prior Database
  • 5.13.1 Estimated Failover Time (seconds) - 11.1 and Prior Database
  • 5.13.2 Apply Lag (seconds) - 11.1 and Prior Database
  • 5.13.3 Transport Lag (seconds) - 11.1 and Prior Database
  • 5.13.4 Redo Apply Rate (KB/second) - 11.1 and Prior Database
• 5.14 Database Files
  • 5.14.1 Average File Read Time (centi-seconds)
  • 5.14.2 Average File Write Time (centi-seconds)
• 5.15 Database Job Status
  • 5.15.1 Broken Job Count
  • 5.15.2 Failed Job Count
• 5.16 Database Limits
  • 5.16.1 Current Logons Count
  • 5.16.2 Current Open Cursors Count
  • 5.16.3 Lock Limit Usage (%)
  • 5.16.4 Process Limit Usage (%)
  • 5.16.5 Session Limit Usage (%)
  • 5.16.6 User Limit Usage (%)
• 5.17 Database Replay
  • 5.17.1 Workload Capture Status
  • 5.17.2 Workload Replay Status
• 5.18 Database Replay Client
  • 5.18.1 Average I/O Latency (milliseconds)
  • 5.18.2 Replay Threads (%) Performing I/O
  • 5.18.3 Replay Threads (%) Using CPU
• 5.19 Database Services
  • 5.19.1 Service CPU Time (per user call) (microseconds)
  • 5.19.2 Service Response Time (per user call) (microseconds)
• 5.20 Database Vault Attempted Violations - Command Rules
  • 5.20.1 Database Vault Attempted Violations Count - Command Rules
• 5.21 Database Vault Attempted Violations - Realms
  • 5.21.1 Database Vault Attempted Violations - Realms
• 5.22 Database Vault Configuration Issues - Command Rules
  • 5.22.1 DV (Command Rule) - Configuration Issue Count
• 5.23 Database Vault Configuration Issues - Realms
  • 5.23.1 Database Vault Configuration Issues Count - Realms
• 5.24 Database Vault Policy Changes
  • 5.24.1 Database Vault Policy Changes Count
• 5.25 DB Alert Log
  • 5.25.1 Archiver Hung Alert Log Error
  • 5.25.2 Data Block Corruption Alert Log Error
  • 5.25.3 Generic Alert Log Error
  • 5.25.4 Media Failure Alert Log Error
  • 5.25.5 Session Terminated Alert Log Error
• 5.26 DB Alert Log Error Status
  • 5.26.1 Archiver Hung Alert Log Error Status
  • 5.26.2 Data Block Corruption Alert Log Error Status
  • 5.26.3 Generic Alert Log Error Status
  • 5.26.4 Media Failure Alert Log Error Status
  • 5.26.5 Session Terminated Alert Log Error Status
• 5.27 DB Managed by Single Instance
  • 5.27.1 CRS Home Directory
  • 5.27.2 DB Managed by Single Instance HA
• 5.28 Deferred Transactions
  • 5.28.1 Deferred Transaction Count
  • 5.28.2 Deferred Transaction Error Count
• 5.29 Dump Area
  • 5.29.1 Dump Area Directory
  • 5.29.2 Dump Area Used (%)
  • 5.29.3 Dump Area Used (KB)
  • 5.29.4 Free Dump Area (KB)
  • 5.29.5 Total Dump Area (KB)
• 5.30 Efficiency
  • 5.30.1 Buffer Cache Hit (%)
  • 5.30.2 CPU Usage (per second)
  • 5.30.3 CPU Usage (per transaction)
  • 5.30.4 Cursor Cache Hit (%)
  • 5.30.5 Data Dictionary Hit (%)
  • 5.30.6 Database CPU Time (%)
  • 5.30.7 Library Cache Hit (%)
  • 5.30.8 Library Cache Miss (%)
  • 5.30.9 Parallel Execution Downgraded (per second)
  • 5.30.10 Parallel Execution Downgraded 25% or more (per second)
  • 5.30.11 Parallel Execution Downgraded 50% or more (per second)
  • 5.30.12 Parallel Execution Downgraded 75% or more (per second)
  • 5.30.13 Parallel Execution Downgraded to Serial (per second)
  • 5.30.14 Parallel Execution Downgraded to Serial (per transaction)
  • 5.30.15 PGA Cache Hit (%)
  • 5.30.16 Redo Log Allocation Hit (%)
  • 5.30.17 Response Time (per transaction)
  • 5.30.18 Row Cache Miss Ratio (%)
  • 5.30.19 Sorts in Memory (%)
• 5.31 Exadata Module Version Failure
  • 5.31.1 Error Count
• 5.32 Failed Logins
  • 5.32.1 Failed Login Count
• 5.33 Fast Recovery
  • 5.33.1 Fast Recovery Area
  • 5.33.2 Fast Recovery Area Size
  • 5.33.3 Flashback On
  • 5.33.4 Log Mode
  • 5.33.5 Non-Reclaimable Fast Recovery Area (%)
  • 5.33.6 Oldest Flashback Time
  • 5.33.7 Reclaimable Fast Recovery Area (%)
  • 5.33.8 Usable Fast Recovery Area (%)
• 5.34 Global Cache Statistics
  • 5.34.1 Global Cache Average Convert Time (centi-seconds)
  • 5.34.2 Global Cache Average CR Block Request Time (centi-seconds)
  • 5.34.3 Global Cache Average Current Block Request Time (centi-seconds)
  • 5.34.4 Global Cache Average Get Time (centi-seconds)
  • 5.34.5 Global Cache Blocks Corrupt
  • 5.34.6 Global Cache Blocks Lost
• 5.35 Incident
  • 5.35.1 Setting Thresholds for Incident Metrics
  • 5.35.2 Access Violation
  • 5.35.3 Alert Log Error Trace File
  • 5.35.4 Alert Log Name
  • 5.35.5 Cluster Error
  • 5.35.6 Deadlock
  • 5.35.7 File Access Error
  • 5.35.8 Generic Incident
  • 5.35.9 Generic Internal Error
  • 5.35.10 Impact
  • 5.35.11 Incident ID
  • 5.35.12 Inconsistent DB State
  • 5.35.13 Internal SQL Error
  • 5.35.14 Oracle Data Block Corruption
  • 5.35.15 Out of Memory
  • 5.35.16 Redo Log Corruption
  • 5.35.17 Session Terminated
• 5.36 Interconnect
  • 5.36.1 Interface Type
• 5.37 Interconnect Traffic
  • 5.37.1 Transfer Rate (MB/s)
• 5.38 Invalid Objects
  • 5.38.1 Total Invalid Object Count
• 5.39 Invalid Objects by Schema
  • 5.39.1 Owner's Invalid Object Count
• 5.40 Messages Per Buffered Queue
  • 5.40.1 Average Age of Messages Per Buffered Queue (Seconds)
  • 5.40.2 First Message Age in Buffered Queue Per Queue (Seconds)
  • 5.40.3 Messages processed per buffered queue (%)
  • 5.40.4 Messages Processed Per Buffered Queue (%) Per Minute
  • 5.40.5 Spilled Messages
  • 5.40.6 Total Messages Processed per Buffered Queue per Minute
  • 5.40.7 Total Messages Received per Buffered Queue per Minute
• 5.41 Message Per Buffered Queue Per Subscriber
  • 5.41.1 Average Age of Messages Per Buffered Queue Per Subscriber (Seconds)
  • 5.41.2 First Message Age in Buffered Queue per Subscriber (Seconds)
  • 5.41.3 Messages Processed Per Buffered Queue Per Subscriber (%)
  • 5.41.4 Messages Processed Per Buffered Queue (%) Per Subscriber Per Minute
  • 5.41.5 Total Messages Processed Per Buffered Queue Per Subscriber Per Minute
  • 5.41.6 Total Messages Received Per Buffered Queue Per Subscriber Per Minute
• 5.42 Messages Per Persistent Queue
  • 5.42.1 Age of the First Message in Persistent Queue Per Queue
  • 5.42.2 Average Age of Messages Per Persistent Queue (Seconds)
  • 5.42.3 Messages Processed Per Persistent Queue (%)
  • 5.42.4 Messages Processed Per Persistent Queue (%) Per Minute
  • 5.42.5 Total Messages Processed per Persistent Queue per Minute
  • 5.42.6 Total Messages Received per Persistent Queue per Minute
• 5.43 Messages Per Persistent Queue Per Subscriber
  • 5.43.1 Average Age of Messages Per Persistent Queue Per Subscriber (Seconds)
  • 5.43.2 Age of the First Message in Persistent Queue Per Subscriber
  • 5.43.3 Messages Processed Per Persistent Queue Per Subscriber (%)
  • 5.43.4 Messages Processed Per Persistent Queue (%) Per Subscriber Per Minute
  • 5.43.5 Total Messages Processed Per Persistent Queue Per Subscriber Per Minute
  • 5.43.6 Total Messages Received Per Persistent Queue Per Subscriber Per Minute
• 5.44 Memory Usage
  • 5.44.1 Total Memory Usage (MB)
• 5.45 OCM Instrumentation
  • 5.45.1 Instrumentation Present
  • 5.45.2 Need to Instrument with OCM
  • 5.45.3 OCM Configured
• 5.46 Operational Error
  • 5.46.1 Alert Log Error Trace File
  • 5.46.2 Alert Log Name
  • 5.46.3 Archiver Hung
  • 5.46.4 Data Block Corruption
  • 5.46.5 Generic Operational Error
  • 5.46.6 Media Failure
  • 5.46.7 User-Defined Error
  • 5.46.8 User-Defined Text
  • 5.46.9 User-Defined Warning
• 5.47 Operating System Audit Records
  • 5.47.1 Size of Audit Files (MB)
• 5.48 Recovery
  • 5.48.1 Corrupt Data Block Count
  • 5.48.2 Datafiles Need Media Recovery
  • 5.48.3 Missing Media File Count
• 5.49 Response
  • 5.49.1 State
  • 5.49.2 Status
• 5.50 SCN Growth Statistics
  • 5.50.1 Current SCN
  • 5.50.2 Current SCN Compatibility
  • 5.50.3 Max Rate
  • 5.50.4 Maximum SCN Compatibility
  • 5.50.5 SCN Health
  • 5.50.6 SCN Total Growth Rate (per sec)
• 5.51 SCN Instance Statistics
  • 5.51.1 SCN Intrinsic Growth Rate (per sec)
• 5.52 SCN Max Statistics
  • 5.52.1 Max SCN Jump in one second (last 24 hours)
• 5.53 Segment Advisor Recommendations
  • 5.53.1 Number of Recommendations
• 5.54 Session Suspended
  • 5.54.1 Session Suspended by Data Object Limitation
  • 5.54.2 Session Suspended by Quota Limitation
  • 5.54.3 Session Suspended by Rollback Segment Limitation
  • 5.54.4 Session Suspended by Tablespace Limitation
• 5.55 SGA Pool Wastage
  • 5.55.1 Java Pool Free (%)
  • 5.55.2 Large Pool Free (%)
  • 5.55.3 Shared Pool Free (%)
• 5.56 Snapshot Too Old
  • 5.56.1 Snapshot Too Old Due to Rollback Segment Limit
  • 5.56.2 Snapshot Too Old Due to Tablespace Limit
• 5.57 Space Usage by Buffered Queues
  • 5.57.1 Queue Size (MB)
  • 5.57.2 Space Usage of Buffered Queue With Respect to Streams Pool Size (%)
• 5.58 SQL Response Time
  • 5.58.1 Baseline SQL Response Time
  • 5.58.2 Current SQL Response Time
  • 5.58.3 SQL Response Time (%)
• 5.59 Streams Apply Aborted
  • 5.59.1 Streams Apply Process Aborted
  • 5.59.2 Streams Apply Process Error
• 5.60 Streams Apply Coordinator Statistics
  • 5.60.1 Total Number of Transactions Assigned
  • 5.60.2 Rate of Transactions Applied (per Sec)
  • 5.60.3 Rate of Transactions Assigned (per Sec)
  • 5.60.4 Rate of Transactions Received (per Sec)
  • 5.60.5 Total Number of Transactions Applied
  • 5.60.6 Total Number of Transactions Received
• 5.61 Streams Apply Errors
  • 5.61.1 Error Message
  • 5.61.2 Error Number
  • 5.61.3 Local Transaction ID
  • 5.61.4 Message Count
  • 5.61.5 Source Transaction ID
• 5.62 Streams Apply Queue - Buffered
  • 5.62.1 Streams Apply - (%) Spilled Messages
• 5.63 Streams Apply Queue - Persistent
  • 5.63.1 Streams Apply - (%) Messages in Waiting State
• 5.64 Streams Apply Reader Statistics
  • 5.64.1 Rate at Which Messages Are Getting Spilled (per Sec)
  • 5.64.2 Total Number of Messages Dequeued
  • 5.64.3 Total Number of Spilled Messages
• 5.65 Streams Capture Message Statistics
  • 5.65.1 Message Capture Rate (per Sec)
  • 5.65.2 Messages Enqueue Rate (per Sec)
  • 5.65.3 Total Messages Captured
  • 5.65.4 Total Messages Enqueued
• 5.66 Streams Capture Queue Statistics
  • 5.66.1 Capture Queue - Cumulative Number of Messages
  • 5.66.2 Capture Queue - Cumulative Number of Spilled Messages
  • 5.66.3 Capture Queue - Number of Messages
  • 5.66.4 Capture Queue - Number of Spilled Messages
  • 5.66.5 Streams Capture - (%) Cumulative Spilled Messages
  • 5.66.6 Streams Capture - (%) Spilled Messages
• 5.67 Streams Latency and Throughput
  • 5.67.1 Latency
  • 5.67.2 Throughput (per sec)
  • 5.67.3 Total Messages
• 5.68 Streams Pool Usage
  • 5.68.1 Streams Pool Full
• 5.69 Streams Processes Count
  • 5.69.1 Number of Apply Processes Having Errors
  • 5.69.2 Number of Capture Processes Having Errors
  • 5.69.3 Number of Apply Processes
  • 5.69.4 Number of Capture Processes
  • 5.69.5 Number of Propagation Jobs
  • 5.69.6 Number of Propagations Having Errors
  • 5.69.7 Total Number of Propagation Errors
• 5.70 Streams Processes Status
  • 5.70.1 Streams Process Errors
  • 5.70.2 Streams Process Status
• 5.71 Streams Propagation - Messages State Stats
  • 5.71.1 Number of Ready Messages
  • 5.71.2 Number of Waiting Messages
  • 5.71.3 Streams Prop - (%) Messages in Waiting State
• 5.72 Streams Propagation - Queue Propagation
  • 5.72.1 Message Propagation Rate (per Sec)
  • 5.72.2 Rate of KBytes Propagated (per Sec)
  • 5.72.3 Total Number of KBytes Propagated
  • 5.72.4 Total Number of Messages Propagated
• 5.73 Streams Propagation Aborted
  • 5.73.1 Streams Propagation Process Aborted
• 5.74 Suspended Session
  • 5.74.1 Suspended Session Count
• 5.75 System Response Time Per Call
  • 5.75.1 Response Time (centi-seconds per call)
• 5.76 System Sessions Waiting
  • 5.76.1 Waiting Session Count
• 5.77 Tablespace Allocation
  • 5.77.1 Tablespace Allocated Space (MB)
  • 5.77.2 Tablespace Used Space (MB)
• 5.78 Tablespaces Full
  • 5.78.1 Tablespace Free Space (MB)
  • 5.78.2 Tablespace Space Used (%)
• 5.79 Tablespaces Full (Dictionary Managed)
  • 5.79.1 Tablespace Free Space (MB) (Dictionary Managed)
  • 5.79.2 Tablespace Space Used (%) (Dictionary Managed)
• 5.80 Tablespaces Full (Temp)
  • 5.80.1 Tablespace Free Space (MB) (Temp)
  • 5.80.2 Tablespace Space Used (%) (Temp)
• 5.81 Tablespaces Full (Undo)
  • 5.81.1 Tablespace Free Space (MB) (Undo)
  • 5.81.2 Tablespace Space Used (%) (Undo)
• 5.82 Tablespaces With Problem Segments
  • 5.82.1 Segments Approaching Maximum Extents
  • 5.82.2 Segments Approaching Maximum Extents Count
  • 5.82.3 Segments Not Able to Extend
  • 5.82.4 Segments Not Able to Extend Count
• 5.83 Temporary File Status
  • 5.83.1 Status
• 5.84 Throughput
  • 5.84.1 Average Active Sessions
  • 5.84.2 Average Synchronous Single-Block Read Latency (ms)
  • 5.84.3 BG Checkpoints (per second)
  • 5.84.4 Branch Node Splits (per second)
  • 5.84.5 Branch Node Splits (per transaction)
  • 5.84.6 Consistent Read Blocks Created (per second)
  • 5.84.7 Consistent Read Blocks Created (per transaction)
  • 5.84.8 Consistent Read Changes (per second)
  • 5.84.9 Consistent Read Changes (per transaction)
  • 5.84.10 Consistent Read Gets (per second)
  • 5.84.11 Consistent Read Gets (per transaction)
  • 5.84.12 Consistent Read Undo Records Applied (per second)
  • 5.84.13 Consistent Read Undo Records Applied (per transaction)
  • 5.84.14 Cumulative Logons (per second)
  • 5.84.15 Cumulative Logons (per transaction)
  • 5.84.16 Database Block Changes (per second)
  • 5.84.17 Database Block Changes (per transaction)
  • 5.84.18 Database Block Gets (per second)
  • 5.84.19 Database Block Gets (per transaction)
  • 5.84.20 Database Time (centiseconds per second)
  • 5.84.21 DBWR Checkpoints (per second)
  • 5.84.22 Enqueue Deadlocks (per second)
  • 5.84.23 Enqueue Deadlocks (per transaction)
  • 5.84.24 Enqueue Requests (per second)
  • 5.84.25 Enqueue Requests (per transaction)
  • 5.84.26 Enqueue Timeout (per second)
  • 5.84.27 Enqueue Timeout (per transaction)
  • 5.84.28 Enqueue Waits (per second)
  • 5.84.29 Enqueue Waits (per transaction)
  • 5.84.30 Executes (per second)
  • 5.84.31 Executes Performed without Parses (%)
  • 5.84.32 Full Index Scans (per second)
  • 5.84.33 Full Index Scans (per transaction)
  • 5.84.34 Hard Parses (per second)
  • 5.84.35 Hard Parses (per transaction)
  • 5.84.36 I/O Megabytes (per second)
  • 5.84.37 I/O Requests (per second)
  • 5.84.38 Leaf Node Splits (per second)
  • 5.84.39 Leaf Node Splits (per transaction)
  • 5.84.40 Network Bytes (per second)
  • 5.84.41 Number of Transactions (per second)
  • 5.84.42 Open Cursors (per second)
  • 5.84.43 Open Cursors (per transaction)
  • 5.84.44 Parse Failure Count (per second)
  • 5.84.45 Parse Failure Count (per transaction)
  • 5.84.46 Physical Reads (per second)
  • 5.84.47 Physical Reads (per transaction)
  • 5.84.48 Physical Reads Direct (per second)
  • 5.84.49 Physical Reads Direct (per transaction)
  • 5.84.50 Physical Reads Direct Lobs (per second)
  • 5.84.51 Physical Reads Direct Lobs (per transaction)
  • 5.84.52 Physical Writes (per second)
  • 5.84.53 Physical Writes (per transaction)
  • 5.84.54 Physical Writes Direct (per second)
  • 5.84.55 Physical Writes Direct (per transaction)
  • 5.84.56 Physical Writes Direct Lobs (per second)
  • 5.84.57 Physical Writes Direct Lobs (per transaction)
  • 5.84.58 Recursive Calls (per second)
  • 5.84.59 Recursive Calls (per transaction)
  • 5.84.60 Redo Generated (per second)
  • 5.84.61 Redo Generated (per transaction)
  • 5.84.62 Redo Writes (per second)
  • 5.84.63 Redo Writes (per transaction)
  • 5.84.64 Rows Processed (per sort)
  • 5.84.65 Scans on Long Tables (per second)
  • 5.84.66 Scans on Long Tables (per transaction)
  • 5.84.67 Session Logical Reads (per second)
  • 5.84.68 Session Logical Reads (per transaction)
  • 5.84.69 Soft Parse (%)
  • 5.84.70 Sorts to Disk (per second)
  • 5.84.71 Sorts to Disk (per transaction)
  • 5.84.72 Total Index Scans (per second)
  • 5.84.73 Total Index Scans (per transaction)
  • 5.84.74 Total Parses (per second)
  • 5.84.75 Total Parses (per transaction)
  • 5.84.76 Total Table Scans (per second)
  • 5.84.77 Total Table Scans (per transaction)
  • 5.84.78 User Calls (%)
  • 5.84.79 User Calls (per second)
  • 5.84.80 User Calls (per transaction)
  • 5.84.81 User Commits (per second)
  • 5.84.82 User Commits (per transaction)
  • 5.84.83 User Rollback Undo Records Applied (per second)
  • 5.84.84 User Rollback Undo Records Applied (per transaction)
  • 5.84.85 User Rollbacks (per second)
  • 5.84.86 User Rollbacks (per transaction)
• 5.85 Total Objects by Schema
  • 5.85.1 Total Object Count
• 5.86 Total Tables by Schema
  • 5.86.1 Total Table Count
• 5.87 User Audit
  • 5.87.1 Audited User
  • 5.87.2 Audited User - Host
  • 5.87.3 Audited User Session Count
• 5.88 User Block
  • 5.88.1 Blocking Session Count
• 5.89 User Block Chain
  • 5.89.1 Blocking Session Count
  • 5.89.2 Blocking Session DB Time
• 5.90 User Locks
  • 5.90.1 Maximum Blocked DB Time (seconds)
  • 5.90.2 Maximum Blocked Session Count
• 5.91 User-Defined SQL
  • 5.91.1 User-Defined Numeric Metric
  • 5.91.2 User-Defined String Metric
• 5.92 Wait Bottlenecks
  • 5.92.1 Active Sessions Waiting: I/O
  • 5.92.2 Active Sessions Waiting: Other
  • 5.92.3 Buffer busy waits (%)
  • 5.92.4 CPU Time Delta (sec)
  • 5.92.5 DB file scattered read (%)
  • 5.92.6 DB file sequential read (%)
  • 5.92.7 DB file single write (%)
  • 5.92.8 Direct path read (%)
  • 5.92.9 Direct path read (lob) (%)
  • 5.92.10 Direct path write (%)
  • 5.92.11 Direct path write (lob) (%)
  • 5.92.12 Enqueue - other (%)
  • 5.92.13 Enqueue: DML - contention (%)
  • 5.92.14 Enqueue: HW, Segment High Water Mark - contention (%)
  • 5.92.15 Enqueue: ST, Space Transaction - contention (%)
  • 5.92.16 Enqueue: TM, TX, Transaction - row lock contention (%)
  • 5.92.17 Enqueue: TX mode 4, Transaction - allocate ITL entry (%)
  • 5.92.18 Enqueue: UL: User-defined - contention (%)
  • 5.92.19 Free buffer waits (%)
  • 5.92.20 Latch free - other (%)
  • 5.92.21 Latch: cache buffer chains (%)
  • 5.92.22 Latch: library cache (%)
  • 5.92.23 Latch: redo copy (%)
  • 5.92.24 Latch: shared pool (%)
  • 5.92.25 Library cache load lock (%)
  • 5.92.26 Library cache lock (%)
  • 5.92.27 Library cache pin (%)
  • 5.92.28 Local write wait (%)
  • 5.92.29 Log buffer space (%)
  • 5.92.30 Log file switch (archiving needed) (%)
  • 5.92.31 Log file switch (checkpoint complete) (%)
  • 5.92.32 Log file switch completion (%)
  • 5.92.33 Log file sync (%)
  • 5.92.34 Log switch/archive (%)
  • 5.92.35 Pipe put (%)
  • 5.92.36 Row cache lock (%)
  • 5.92.37 SQL*Net break/reset to client (%)
  • 5.92.38 SQL*Net break/reset to dblink (%)
  • 5.92.39 SQL*Net message to client (%)
  • 5.92.40 SQL*Net message to dblink (%)
  • 5.92.41 SQL*Net more data from client (%)
  • 5.92.42 SQL*Net more data from dblink (%)
  • 5.92.43 SQL*Net more data to client (%)
  • 5.92.44 SQL*Net more data to dblink (%)
  • 5.92.45 Wait Time (%)
  • 5.92.46 Write complete waits (%)
• 5.93 Wait by Session Count
  • 5.93.1 Session Waiting for Event Count
• 5.94 Waits by Wait Class
  • 5.94.1 Average Users Waiting Count
  • 5.94.2 Database Time Spent Waiting (%)

6 Cluster Database

• 6.1 Archive Area
  • 6.1.1 Archive Area Used (%)
  • 6.1.2 Archive Area Used (KB)
  • 6.1.3 Free Archive Area (KB)
  • 6.1.4 Total Archive Area (KB)
• 6.2 Cluster Managed Database Services
  • 6.2.1 % CPU Time Load (in last 5 min)
• 6.3 Data Guard - 10.1 Database
  • 6.3.1 Data Guard Status - 10.1 Database
  • 6.3.2 Data Not Applied (logs)
  • 6.3.3 Data Not Applied (MB)
  • 6.3.4 Data Not Received (logs)
  • 6.3.5 Data Not Received (MB)
• 6.4 Data Guard - 9.2 Database
  • 6.4.1 Data Guard Status - 9.2 Database
  • 6.4.2 Data Not Applied (logs)
  • 6.4.3 Data Not Received (logs)
• 6.5 Data Guard Fast-Start Failover
  • 6.5.1 Fast-Start Failover Occurred
• 6.6 Data Guard Fast-Start Failover Observer Status
  • 6.6.1 Observer Status
• 6.7 Data Guard Fast-Start Failover Observer Status - 10.2 Database
  • 6.7.1 Observer Status - 10.2 Database
• 6.8 Data Guard Performance
  • 6.8.1 Apply Lag (seconds)
  • 6.8.2 Estimated Failover Time (seconds)
  • 6.8.3 Redo Apply Rate (KB/second)
  • 6.8.4 Redo Generation Rate (KB/second)
  • 6.8.5 Transport Lag (seconds)
• 6.9 Data Guard Performance - 11.1 and Prior Database
  • 6.9.1 Apply Lag (seconds) - 11.1 and Prior Database
  • 6.9.2 Estimated Failover Time (seconds) - 11.1 and Prior Database
  • 6.9.3 Transport Lag (seconds) - 11.1 and Prior Database
  • 6.9.4 Redo Apply Rate (KB/second) - 11.1 and Prior Database
• 6.10 Data Guard Status
  • 6.10.1 Data Guard Status
• 6.11 Database Cardinality
  • 6.11.1 Open Instance Count
• 6.12 Database Job Status
  • 6.12.1 Broken Job Count
  • 6.12.2 Failed Job Count
• 6.13 Database Wait Bottlenecks
  • 6.13.1 Active Sessions Using CPU
  • 6.13.2 Active Sessions Waiting: I/O
  • 6.13.3 Active Sessions Waiting: Other
  • 6.13.4 Average Database CPU (%)
  • 6.13.5 Host CPU Utilization (%)
  • 6.13.6 Load Average
  • 6.13.7 Maximum CPU
  • 6.13.8 Wait Time (%)
• 6.14 Database Vault Attempted Violations - Command Rules
  • 6.14.1 Database Vault Attempted Violations Count - Command Rules
• 6.15 Database Vault Attempted Violations - Realms
  • 6.15.1 Database Vault Attempted Violations Count - Realms
• 6.16 Database Vault Configuration Issues - Realms
  • 6.16.1 Database Vault Configuration Issues Count - Realms
• 6.17 Database Vault Configuration Issues - Command Rules
  • 6.17.1 DV (Command Rule) - Configuration Issue Count
• 6.18 Database Vault Policy Changes
  • 6.18.1 Database Vault Policy Changes Count
• 6.19 Deferred Transactions
  • 6.19.1 Deferred Transaction Count
  • 6.19.2 Deferred Transaction Error Count
• 6.20 Exadata Module Version Failure
  • 6.20.1 Error Count
• 6.21 Failed Logins
  • 6.21.1 Failed Login Count
• 6.22 Fast Recovery
  • 6.22.1 Fast Recovery Area
  • 6.22.2 Fast Recovery Area Size
  • 6.22.3 Flashback On
  • 6.22.4 Log Mode
  • 6.22.5 Non-Reclaimable Fast Recovery Area (%)
  • 6.22.6 Oldest Flashback Time
  • 6.22.7 Reclaimable Fast Recovery Area (%)
  • 6.22.8 Usable Fast Recovery Area (%)
• 6.23 Invalid Objects
  • 6.23.1 Total Invalid Object Count
• 6.24 Invalid Objects by Schema
  • 6.24.1 Owner's Invalid Object Count
• 6.25 Messages Per Buffered Queue
  • 6.25.1 Average age of messages per buffered queue (seconds)
  • 6.25.2 First Message Age in Buffered Queue Per Queue (Seconds)
  • 6.25.3 Messages processed per buffered queue (%)
  • 6.25.4 Messages processed per buffered queue (%) per minute
  • 6.25.5 Spilled Messages
  • 6.25.6 Total Messages Processed per Buffered Queue per Minute
  • 6.25.7 Total Messages Received per Buffered Queue per Minute
• 6.26 Messages Per Buffered Queue Per Subscriber
  • 6.26.1 Average Age of Messages Per Buffered Queue Per Subscriber (Seconds)
  • 6.26.2 First Message Age in Buffered Queue per Subscriber (Seconds)
  • 6.26.3 Messages Processed Per Buffered Queue (%) Per Subscriber Per Minute
  • 6.26.4 Messages Processed Per Buffered Queue Per Subscriber (%)
  • 6.26.5 Total Messages Processed Per Buffered Queue Per Subscriber Per Minute
  • 6.26.6 Total Messages Received Per Buffered Queue Per Subscriber Per Minute
• 6.27 Messages Per Persistent Queue
  • 6.27.1 Average Age of Messages Per Persistent Queue (Seconds)
  • 6.27.2 Age of The First Message in Persistent Queue Per Queue (Seconds)
  • 6.27.3 Messages Processed Per Persistent Queue (%)
  • 6.27.4 Messages Processed Per Persistent Queue (%) Per Minute
  • 6.27.5 Total Messages Processed per Persistent Queue per Minute
  • 6.27.6 Total Messages Received per Persistent Queue per Minute
• 6.28 Messages Per Persistent Queue Per Subscriber
  • 6.28.1 Average Age of Messages Per Persistent Queue Per Subscriber (Seconds)
  • 6.28.2 First Message Age in Persistent Queue per Subscriber (Seconds)
  • 6.28.3 Messages Processed Per Persistent Queue (%) Per Subscriber Per Minute
  • 6.28.4 Messages Processed Per Persistent Queue Per Subscriber (%)
  • 6.28.5 Total Messages Processed Per Persistent Queue Per Subscriber Per Minute
  • 6.28.6 Total Messages Received Per Persistent Queue Per Subscriber Per Minute
• 6.29 QoS Management - Performance Satisfaction
  • 6.29.1 Negative PSM Duration (seconds)
• 6.30 Recovery
  • 6.30.1 Corrupt Data Block Count
  • 6.30.2 Missing Media File Count
• 6.31 Recovery Area
  • 6.31.1 Recovery Area Free Space (%)
• 6.32 SCN Growth Statistics
  • 6.32.1 SCN Health
• 6.33 SCN Max Statistics
  • 6.33.1 Max SCN Jump in one second (last 24 hours)
• 6.34 Segment Advisor Recommendations
  • 6.34.1 Number of recommendations
• 6.35 Session Suspended
  • 6.35.1 Session Suspended by Data Object Limitation
  • 6.35.2 Session Suspended by Quota Limitation
  • 6.35.3 Session Suspended by Rollback Segment Limitation
  • 6.35.4 Session Suspended by Tablespace Limitation
• 6.36 Snapshot Too Old
  • 6.36.1 Snapshot Too Old due to Rollback Segment Limit
  • 6.36.2 Snapshot Too Old due to Tablespace Limit
• 6.37 Space Usage by Buffered Queues
  • 6.37.1 Queue Size (MB)
  • 6.37.2 Space Usage of Buffered Queue With Respect to Streams Pool Size (%)
• 6.38 Streams Apply Queue - Buffered
  • 6.38.1 Streams Apply - (%)Spilled Messages
• 6.39 Streams Apply Queue - Persistent
  • 6.39.1 Streams Apply - (%)Messages in Waiting State
• 6.40 Streams Apply Reader Statistics
  • 6.40.1 Rate at Which Messages Are Getting Spilled (Per Sec)
• 6.41 Streams Capture Queue Statistics
  • 6.41.1 Streams Capture - (%)Spilled Messages
• 6.42 Streams Latency and Throughput
  • 6.42.1 Latency
  • 6.42.2 Throughput (per sec)
• 6.43 Streams Processes Count
  • 6.43.1 Apply Processes Having Errors
  • 6.43.2 Capture Processes Having Errors
  • 6.43.3 Number of Apply Processes
  • 6.43.4 Number of Capture Processes
  • 6.43.5 Number of Propagation Jobs
  • 6.43.6 Propagation Errors
• 6.44 Streams Propagation - Message State Stats
  • 6.44.1 Streams Prop - (%)Messages in Waiting State
• 6.45 Suspended Session
  • 6.45.1 Suspended Session Count
• 6.46 Tablespace Allocation
  • 6.46.1 Tablespace Allocated Space (MB)
  • 6.46.2 Tablespace Used Space (MB)
• 6.47 Tablespaces Full
  • 6.47.1 Tablespace Free Space (MB)
  • 6.47.2 Tablespace Space Used (%)
• 6.48 Tablespaces Full (dictionary managed)
  • 6.48.1 Tablespace Free Space (MB) (dictionary managed)
  • 6.48.2 Tablespace Space Used (%) (dictionary managed)
• 6.49 Tablespaces With Problem Segments
  • 6.49.1 Segments Approaching Maximum Extents Count
  • 6.49.2 Segments Not Able to Extend Count
• 6.50 Temporary File Status
  • 6.50.1 Temporary File Id
• 6.51 Total Objects by Schema
  • 6.51.1 Total Object Count
• 6.52 Total Tables by Schema
  • 6.52.1 Total Table Count
• 6.53 User Block
  • 6.53.1 Blocking Session Count
• 6.54 User Locks
  • 6.54.1 Maximum Blocked DB Time (seconds)
  • 6.54.2 Maximum Blocked Session Count

7 Listener

• 7.1 General Status
  • 7.1.1 Alias
  • 7.1.2 Security
  • 7.1.3 SID List
  • 7.1.4 SNMP Status
  • 7.1.5 Start Date
  • 7.1.6 TNS Address
  • 7.1.7 Trace Level
  • 7.1.8 Version
• 7.2 Listener Ports
• 7.3 Listener Services
• 7.4 Load
  • 7.4.1 Connections Established
  • 7.4.2 Connections Established (per min)
  • 7.4.3 Connections Refused
  • 7.4.4 Connections Refused (per min)
• 7.5 Response
  • 7.5.1 Response Time (msec)
  • 7.5.2 Status
• 7.6 TNS Errors
  • 7.6.1 TNSMsg

8 Oracle Exadata

• 8.1 Oracle Exadata Storage Server
  • 8.1.1 Aggregated Exadata Capacity
  • 8.1.2 Aggregated Exadata CellDisk
  • 8.1.3 Aggregated Exadata Diskgroup Capacity
  • 8.1.4 Aggregated Exadata FlashDisk and HardDisk
  • 8.1.5 Cell Generated Alert
  • 8.1.6 CellSrv Status
  • 8.1.7 Exadata Cell Metric
  • 8.1.8 Exadata CellDisk Metric
  • 8.1.9 Exadata CellDisk Load Imbalance
  • 8.1.10 Exadata Disk Status Metric
  • 8.1.11 Exadata Flash Cache Metric
  • 8.1.12 Exadata Flash Log Metric
  • 8.1.13 Exadata IORM Consumer Group Metric
  • 8.1.14 Exadata IORM DB
  • 8.1.15 Exadata IORM Pluggable Database Metric
  • 8.1.16 Exadata Smart IO Metric
  • 8.1.17 Filesystem Utilization
  • 8.1.18 HCA Port Configuration Monitor
  • 8.1.19 HCA Port Errors
  • 8.1.20 HCA Port State
  • 8.1.21 HCA Port State (For Alerts)
  • 8.1.22 Host Interconnect Statistics
  • 8.1.23 Response
  • 8.1.24 Top CPU
• 8.2 Oracle Database Exadata Storage Server System
  • 8.2.1 Agg_Exadata_System_Celldisk_Metric
  • 8.2.2 Response
• 8.3 Oracle Exadata Storage Server Grid
  • 8.3.1 Response

9 Pluggable Databases

• 9.1 Database Feature Usage
  • 9.1.1 Count
  • 9.1.2 Currently Used
  • 9.1.3 DBID
  • 9.1.4 Detected Usages
  • 9.1.5 Feature Info
  • 9.1.6 Feature Name
  • 9.1.7 First Usage Date
  • 9.1.8 Last Sample Date
  • 9.1.9 Last Sample Period
  • 9.1.10 Last Usage Date
  • 9.1.11 Total Samples
  • 9.1.12 Version
• 9.2 Datafiles
  • 9.2.1 Autoextensible
  • 9.2.2 Datafile Name
  • 9.2.3 File Size
  • 9.2.4 Initial File Size
  • 9.2.5 Increment By
  • 9.2.6 Max File Size
  • 9.2.7 Status
  • 9.2.8 Storage Entity
  • 9.2.9 Tablespace
• 9.3 Database Job Status
  • 9.3.1 Broken Job Count
  • 9.3.2 Failed Job Count
• 9.4 Database Services
  • 9.4.1 Service CPU Time (per user call) (microseconds)
  • 9.4.2 Service Response Time (per user call) (microseconds)
• 9.5 Failed Logins
  • 9.5.1 Failed Login Count
• 9.6 Invalid Objects
  • 9.6.1 Total Invalid Object Count
• 9.7 Invalid Objects by Schema
  • 9.7.1 Owner's Invalid Object Count
• 9.8 Messages per buffered queue
  • 9.8.1 Average age of messages per buffered queue (seconds)
  • 9.8.2 Spilled Messages
  • 9.8.3 First message age in the buffered queue per queue (seconds)
  • 9.8.4 Messages processed per buffered queue (%)
  • 9.8.5 Total Messages Processed per Buffered Queue per Minute
  • 9.8.6 Total messages received per buffered queue per minute
  • 9.8.7 Total number of messages processed
  • 9.8.8 Total number of messages received
• 9.9 Messages per buffered queue per subscriber
  • 9.9.1 Average age of messages/buffered queue/subscriber (seconds)
  • 9.9.2 First message age in buffered queue per subscriber (seconds)
  • 9.9.3 Messages processed/buffered queue/subscriber (%)
  • 9.9.4 Messages processed/buffered queue/subscriber per minute (%)
  • 9.9.5 Total messages processed/buffered queue/subscriber per minute
  • 9.9.6 Total messages received/buffered queue/subscriber per minute
  • 9.9.7 Total number of messages processed
  • 9.9.8 Total number of messages received
• 9.10 Messages per persistent queue
  • 9.10.1 Average age of messages per persistent queue (seconds)
  • 9.10.2 First message age in persistent queue/queue (seconds)
  • 9.10.3 Global Database Name
  • 9.10.4 Messages processed per persistent queue (%)
  • 9.10.5 Messages processed per persistent queue per minute (%)
  • 9.10.6 Total messages processed per persistent queue per minute
  • 9.10.7 Total messages received per persistent queue per minute
  • 9.10.8 Total number of messages processed
  • 9.10.9 Total number of messages received
• 9.11 Messages per persistent queue per subscriber
  • 9.11.1 Average age of messages/persistent queue/subscriber (seconds)
  • 9.11.2 First message age in persistent queue/subscriber (seconds)
  • 9.11.3 Global Database Name
  • 9.11.4 Messages processed/persistent queue/subscriber per minute (%)
  • 9.11.5 Messages processed/persistent queue/subscriber (%)
  • 9.11.6 Total messages processed/persistent queue/subscriber per minute (%)
  • 9.11.7 Total messages received/persistent queue/subscriber per minute
  • 9.11.8 Total number of messages processed
  • 9.11.9 Total number of messages received
• 9.12 Response
  • 9.12.1 State
  • 9.12.2 Status
  • 9.12.3 ORA- Error
• 9.13 Rollback Segments
  • 9.13.1 Name
  • 9.13.2 Aveactive
  • 9.13.3 Aveshrink
  • 9.13.4 Extents
  • 9.13.5 Hwmsize
  • 9.13.6 Initial Size
  • 9.13.7 Maximum Size
  • 9.13.8 Minimum Extents
  • 9.13.9 Next Size
  • 9.13.10 Optsize
  • 9.13.11 Pct Increase
  • 9.13.12 Size
  • 9.13.13 Shrinks
  • 9.13.14 Status
  • 9.13.15 Tablespace Name
  • 9.13.16 Wraps
• 9.14 Segment Advisor Recommendations
  • 9.14.1 Number of recommendations
• 9.15 Tablespaces
  • 9.15.1 Allocation Type
  • 9.15.2 Big File
  • 9.15.3 Block Size
  • 9.15.4 Extent Management
  • 9.15.5 Increment By
  • 9.15.6 Initial Ext Size
  • 9.15.7 Logging
  • 9.15.8 Max Extents
  • 9.15.9 Minimum Extent Size
  • 9.15.10 Minimum Extents
  • 9.15.11 Next Extent
  • 9.15.12 Segment Space Management
  • 9.15.13 Size
  • 9.15.14 Status
  • 9.15.15 Tablespace Name
  • 9.15.16 Type
  • 9.15.17 Used Size(B)
  • 9.15.18 Tablespace Used Space (MB)
• 9.16 Tablespace Allocation
  • 9.16.1 Tablespace Allocated Space (MB)
  • 9.16.2 Tablespace Used Space (MB)
• 9.17 Tablespaces Full
  • 9.17.1 Tablespace Free Space (MB)
  • 9.17.2 Tablespace Space Used (%)
• 9.18 Tablespaces Full (Temp)
  • 9.18.1 Tablespace Free Space (MB) (Temp)
  • 9.18.2 Tablespace Space Used (%) (Temp)
• 9.19 Tablespaces Full (dictionary managed)
  • 9.19.1 Tablespace Free Space (MB) (dictionary managed)
  • 9.19.2 Tablespace Space Used (%) (dictionary managed)
• 9.20 Tablespaces With Problem Segments
  • 9.20.1 Segments Approaching Maximum Extents Count
  • 9.20.2 Segments Approaching Maximum Extents
  • 9.20.3 Segments Not Able to Extend
  • 9.20.4 Segments Not Able to Extend Count
• 9.21 Temporary File Status
  • 9.21.1 File Name
  • 9.21.2 Status
  • 9.21.3 Temporary File Id
• 9.22 Total Objects by Schema
  • 9.22.1 Total Object Count
• 9.23 Total Tables by Schema
  • 9.23.1 Total Table Count

10 CISCO Switch Metrics

• 10.1 CPU
  • 10.1.1 CPU Usage in the Last 5 Minutes (%)
  • 10.1.2 CPU Usage in the Last 1 Minute (%)
  • 10.1.3 CPU Usage in the Last 5 Seconds (%)
• 10.2 Fan
  • 10.2.1 Fan State
• 10.3 Memory
  • 10.3.1 Memory Pool Usage (%)
• 10.4 Network Interfaces
  • 10.4.1 Admin Status
  • 10.4.2 Incoming Discards(%)
  • 10.4.3 Incoming Errors(%)
  • 10.4.4 Incoming Traffic(%)
  • 10.4.5 Incoming Traffic (Kb/s)
  • 10.4.6 Interface Status
  • 10.4.7 OperStatus
  • 10.4.8 Outgoing Discards(%)
  • 10.4.9 Outgoing Errors(%)
  • 10.4.10 Outgoing Traffic(%)
  • 10.4.11 Outgoing Traffic(Kb/s)
• 10.5 Power Supply
  • 10.5.1 Power Supply State
  • 10.5.2 TCP Ping, Milliseconds
• 10.6 System Information
  • 10.6.1 Contact
  • 10.6.2 Host Name
  • 10.6.3 Location
  • 10.6.4 Up Since (Days)
• 10.7 Temperature
  • 10.7.1 Temperature, State
  • 10.7.2 Temperature, Value (Celsius)

11 KVM Target Metrics

• 11.1 Aggregated Target Device Status Changed
  • 11.1.1 Aggregated Target Device Status
  • 11.1.2 Aggregated Target Device Status Changed Object
• 11.2 Factory Defaults Set
  • 11.2.1 Factory Defaults Set Status
• 11.3 Fan Failure
  • 11.3.1 Fan Failure Status
• 11.4 Ping Status
  • 11.4.1 Status
  • 11.4.2 TCP Ping, Milliseconds
• 11.5 Power Supply
  • 11.5.1 Power Supply Status
• 11.6 Reboot Started
  • 11.6.1 Reboot Started Status
  • 11.6.2 User Name
• 11.7 Response
  • 11.7.1 Status
  • 11.7.2 TCP Ping, Milliseconds
• 11.8 Temperature Range
  • 11.8.1 Temperature Out Of Range Status

12 Integrated Lights Out Manager Metrics

• 12.1 Component Fault
  • 12.1.1 Fault Status
• 12.2 Fan Fault
  • 12.2.1 Fault Status
• 12.3 Fan Sensors
  • 12.3.1 Sensor Speed (RPM)
  • 12.3.2 Sensor State
• 12.4 Hard Disk Status
  • 12.4.1 Fault Status (0 - cleared, 1 - critical)
• 12.5 HCA Port State (For Alerts)
  • 12.5.1 Is Port Disabled?
  • 12.5.2 Is Port in 'polling' state?
• 12.6 ILOM Temperatures
  • 12.6.1 Inlet Ambient Temperature
  • 12.6.2 Outlet Ambient Temperature
  • 12.6.3 System Ambient Temperature
• 12.7 Memory Fault
  • 12.7.1 Fault Status
• 12.8 Processor Fault
  • 12.8.1 Fault Status
• 12.9 Sensor Alerts
  • 12.9.1 Current Sensor Description
  • 12.9.2 Current Sensor Status
  • 12.9.3 Fan Sensor Status
  • 12.9.4 Fan Sensor Status Description
  • 12.9.5 Power Supply Sensor Description
  • 12.9.6 Power Supply Sensor Status
  • 12.9.7 Temperature Sensor Description
  • 12.9.8 Temperature Sensor Status
  • 12.9.9 Voltage Sensor Description
  • 12.9.10 Voltage Sensor Status
• 12.10 Service Processor Information
  • 12.10.1 Check Physical Presence
  • 12.10.2 Host Name
  • 12.10.3 Reset to Defaults
  • 12.10.4 System Contact
  • 12.10.5 System Description
  • 12.10.6 System Identifier
  • 12.10.7 System Location
• 12.11 Temperature Sensors
  • 12.11.1 Sensor Reading (degree C)
  • 12.11.2 Sensor State
• 12.12 Voltage Sensors
  • 12.12.1 Sensor Reading (Volts)
  • 12.12.2 Sensor State

13 Infiniband Network

• 13.1 Link Type Performance
  • 13.1.1 Average Throughput
  • 13.1.2 Highest Throughput
  • 13.1.3 Link Type
  • 13.1.4 Lowest Throughput
• 13.2 Network Performance
  • 13.2.1 Total Throughput (KBPS)

14 Infiniband Switch

• 14.1 Aggregate Sensors
  • 14.1.1 Alarm Status
  • 14.1.2 Sensor Value
• 14.2 Fan Speed Sensors
  • 14.2.1 Alarm Status
  • 14.2.2 Fan Speed (revolutions per minute)
• 14.3 Fan Speed Sensor Alerts
  • 14.3.1 Alarm Status
  • 14.3.2 Fan Speed (revolutions per minute)
• 14.4 FRU Removal Alerts
  • 14.4.1 FRU Status
• 14.5 Response
  • 14.5.1 Response Status
• 14.6 Switch Gateway Port State
  • 14.6.1 10 Gb/s Ethernet Port
  • 14.6.2 State
  • 14.6.3 Received Bytes
  • 14.6.4 Received Packets
  • 14.6.5 Received Jumbo Packets
  • 14.6.6 Received Unicast Packets
  • 14.6.7 Received Broadcast Packets
  • 14.6.8 Received Buffers
  • 14.6.9 Received CRC Errors
  • 14.6.10 Received Runtime Errors
  • 14.6.11 Received Total Errors
  • 14.6.12 Transmitted Bytes
  • 14.6.13 Transmitted Packets
  • 14.6.14 Transmitted Jumbo Packets
  • 14.6.15 Transmitted Unicast Packets
  • 14.6.16 Transmitted Multicast Packets
  • 14.6.17 Transmitted Broadcast Packets
  • 14.6.18 Transmitted Total Errors
• 14.7 Switch Performance Summary
  • 14.7.1 Average link throughput (KBPS)
  • 14.7.2 Highest link throughput (KBPS)
  • 14.7.3 Lowest link throughput (KBPS)
• 14.8 Switch Port Configuration Monitor
  • 14.8.1 GUID on the other end of the link
  • 14.8.2 Name of the entity to which this port is connected
  • 14.8.3 Node GUID if the peer is a Switch port, Port GUID otherwise
  • 14.8.4 Port number of the peer port
  • 14.8.5 Type of entity to which this disconnected port was connected
  • 14.8.6 Type of the entity to which this port is connected.
• 14.9 Switch Port Errors
  • 14.9.1 Excessive buffer overruns
  • 14.9.2 Incoming VL15 packets dropped due to resource limitation
  • 14.9.3 Link integrity errors
  • 14.9.4 Link recovers
  • 14.9.5 Packets not transmitted due to constraints
  • 14.9.6 Received packets discarded due to constraints
  • 14.9.7 Received packets marked with the EBP delimiter
  • 14.9.8 Received packets with error
  • 14.9.9 Symbol errors
  • 14.9.10 Total errors
• 14.10 Switch Port Performance
  • 14.10.1 Link Throughput: bytes transmitted and received per sec (KBPS)
  • 14.10.2 Number of bytes received per sec (KBPS)
  • 14.10.3 Number of bytes transmitted per sec (KBPS)
  • 14.10.4 Number of packets received per sec
  • 14.10.5 Number of packets transmitted per sec
• 14.11 Switch Port State
  • 14.11.1 Active link width of port based on cable connectivity
  • 14.11.2 Is the link degraded?
  • 14.11.3 Link state
  • 14.11.4 Physical link state
  • 14.11.5 The active link speed (Gbps)
• 14.12 Switch Port State (For Alerts)
  • 14.12.1 Indicates that cable is present but port is disabled
  • 14.12.2 Indicates that cable is present but port is polling for peer port
• 14.13 Switch State Summary
  • 14.13.1 Number of active ports
  • 14.13.2 Number of degraded ports
  • 14.13.3 Number of ports with errors
• 14.14 Switch Temperatures
  • 14.14.1 Back of switch temperature
  • 14.14.2 Front of switch temperature
  • 14.14.3 Switch I4 chip temperature
  • 14.14.4 Switch Service Processor temperature
• 14.15 Temperature Sensors
  • 14.15.1 Alarm Status
  • 14.15.2 Temperature (degrees Celsius)
• 14.16 Voltage Sensors
  • 14.16.1 Alarm Status
  • 14.16.2 Voltage (mV)