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
  • Metric Information
  • Examples of Metric Summary Tables
  • Definitions of Columns in Metric Summary Tables
  • Abbreviations and Acronyms
• About Metrics, Thresholds, and Alerts
  • Accessing Metrics
  • Editing Metrics
  • Specifying Multiple Thresholds

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 Disks
  • 1.4.1 Cell IP
  • 1.4.2 Disk
  • 1.4.3 Disk Creation Date
  • 1.4.4 Disk Group
  • 1.4.5 Disk Path
  • 1.4.6 Fail Group Type
  • 1.4.7 Failure Group Name
  • 1.4.8 Redundancy
  • 1.4.9 Size (MB)
• 1.5 ASM File Group
  • 1.5.1 File Group
  • 1.5.2 Disk Group
  • 1.5.3 Quota Group
  • 1.5.4 Client Type
  • 1.5.5 Client Name
• 1.6 ASM Volumes
  • 1.6.1 Allocated Space (GB)
  • 1.6.2 Mount Point
  • 1.6.3 Redundancy
  • 1.6.4 Size (GB)
  • 1.6.5 Usage
  • 1.6.6 Volume Name
• 1.7 Database Disk Group Usage
  • 1.7.1 Total Bytes
• 1.8 Database Sparse Disk Group Usage
  • 1.8.1 Database Name
  • 1.8.2 Disk Group Name
  • 1.8.3 Total Physical Bytes
• 1.9 Disk Groups
  • 1.9.1 Allocation Unit (MB)
  • 1.9.2 Contains Voting Files
  • 1.9.3 Disk Count
  • 1.9.4 Disk Group
  • 1.9.5 Redundancy
  • 1.9.6 Size (GB)
• 1.10 Disk Group Attributes
  • 1.10.1 Disk Group
  • 1.10.2 Attribute Name
  • 1.10.3 Value
• 1.11 Disk Group Imbalance Status
  • 1.11.1 Actual Imbalance (%)
  • 1.11.2 Actual Minimum Percent Free
  • 1.11.3 Disk Count
  • 1.11.4 Disk Group Percent Imbalance
  • 1.11.5 Disk Maximum Used (%) with Rebalance
  • 1.11.6 Disk Minimum Free (%) without Rebalance
  • 1.11.7 Disk Size Variance (%)
  • 1.11.8 Rebalance In Progress
  • 1.11.9 Resync In Progress
• 1.12 Disk Group Target Component
  • 1.12.1 Disk Group Name
  • 1.12.2 Disk Count
• 1.13 Disk Group Usage
  • 1.13.1 Disk Group Free (MB)
  • 1.13.2 Disk Group Usable (Free MB)
  • 1.13.3 Disk Group Usable (MB)
  • 1.13.4 Disk Group Used %
  • 1.13.5 Redundancy
  • 1.13.6 Size (MB)
  • 1.13.7 Disk Group Used % of Safely Usable
• 1.14 Disk Path
  • 1.14.1 Disk Name
  • 1.14.2 Disk Path
  • 1.14.3 Group Name
• 1.15 Disk Status
  • 1.15.1 Disk Mode Status
• 1.16 Failure Group Imbalance Status
  • 1.16.1 Disk Count Imbalance Variance
  • 1.16.2 Disk Size Imbalance (%)
  • 1.16.3 Failure Group Count
  • 1.16.4 Inactive Partnership Count
• 1.17 Failure Group Status
  • 1.17.1 Available Disks
  • 1.17.2 Online Disk Count for Failure Group with More than 1 Disk
  • 1.17.3 Disk Count
  • 1.17.4 Online Disk Count for Failure Group with More than 1 Disk
• 1.18 File Group Usage
  • 1.18.1 Quota Limit Used (MB)
• 1.19 Initialization Parameters
  • 1.19.1 Name
  • 1.19.2 Value
  • 1.19.3 Default
• 1.20 Instance Disk Performance
  • 1.20.1 Bytes Read
  • 1.20.2 Bytes Written
  • 1.20.3 Last Read Errors
  • 1.20.4 Read Errors
  • 1.20.5 Read Response Time (MS)
  • 1.20.6 Read Time (MS)
  • 1.20.7 Write Errors
  • 1.20.8 Reads
  • 1.20.9 I/O Response Time (MS)
  • 1.20.10 Total I/O Time (MS)
  • 1.20.11 Write Response Time (MS)
  • 1.20.12 Write Time (MS)
  • 1.20.13 Writes
• 1.21 Instance Disk Group Database 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 Disk Group Performance
  • 1.22.1 Bytes Read
  • 1.22.2 Bytes Written
  • 1.22.3 Read Time (MS)
  • 1.22.4 Reads
  • 1.22.5 Write Time (MS)
  • 1.22.6 Writes
• 1.23 Offline Disk Count
  • 1.23.1 Offline Disk Count
• 1.24 Response
  • 1.24.1 Status
• 1.25 Sparse Disk Group Usage
  • 1.25.1 Disk Group Physical Free (MB)
  • 1.25.2 Disk Group Physical Used (%)
  • 1.25.3 Physical Size (MB)
• 1.26 Sparse Disks
  • 1.26.1 Disks
  • 1.26.2 Disk Group
  • 1.26.3 Physical Size (MB)
• 1.27 Quota Group Usage
  • 1.27.1 Quota Limit (MB)
  • 1.27.2 Quota Limit Used (MB)
  • 1.27.3 Quota Limit Used (%)

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 Available Time
  • 2.5.3 Mount Point
  • 2.5.4 ASM Cluster File System Mount State
• 2.6 ASM File Group
  • 2.6.1 File Group
  • 2.6.2 Disk Group
  • 2.6.3 Quota Group
  • 2.6.4 Client Type
  • 2.6.5 Client Name
• 2.7 ASM Volumes
  • 2.7.1 Allocated Space (GB)
  • 2.7.2 Redundancy
  • 2.7.3 Size (GB)
  • 2.7.4 Usage
  • 2.7.5 Volume Name
• 2.8 Database Disk Group Usage
  • 2.8.1 Total Bytes
• 2.9 Database Sparse Disk Group Usage
  • 2.9.1 Database Name
  • 2.9.2 Disk Group Name
  • 2.9.3 Total Physical Bytes
• 2.10 Disk Group Imbalance Status
  • 2.10.1 Actual Imbalance (%)
  • 2.10.2 Actual Minimum Percent Free
  • 2.10.3 Disk Count
  • 2.10.4 Disk Group Percent Imbalance
  • 2.10.5 Disk Maximum Used (%) with Rebalance
  • 2.10.6 Disk Minimum Free (%) without Rebalance
  • 2.10.7 Rebalance In Progress
  • 2.10.8 Resync In Progress
• 2.11 Disk Group Status
  • 2.11.1 State
  • 2.11.2 Disk Group Name
• 2.12 Disk Group Usage
  • 2.12.1 Disk Group Name
  • 2.12.2 Disk Group Free (MB)
  • 2.12.3 Disk Group Usable (MB)
  • 2.12.4 Disk Group Usable Free (MB)
  • 2.12.5 Disk Group Used %
  • 2.12.6 Redundancy
  • 2.12.7 Size (MB)
  • 2.12.8 Disk Group Used % of Safely Usable
• 2.13 Disk Path
  • 2.13.1 Disk Name
  • 2.13.2 Disk Path
  • 2.13.3 Group Name
• 2.14 Disk Status
  • 2.14.1 Disk Mode Status
• 2.15 Disks
  • 2.15.1 Cell IP
  • 2.15.2 Disk
  • 2.15.3 Disk Creation Date
  • 2.15.4 Disk Group
  • 2.15.5 Disk Path
  • 2.15.6 Failure Group Name
  • 2.15.7 Failure Group Type
  • 2.15.8 Redundancy
  • 2.15.9 Size (MB)
• 2.16 Failure Group Imbalance Status
  • 2.16.1 Disk Count Imbalance Variance
  • 2.16.2 Disk Size Imbalance (%)
  • 2.16.3 Failure Group Count
• 2.17 Failure Group Status
  • 2.17.1 Available Disks
  • 2.17.2 Disk Count
  • 2.17.3 Online Disk Count for Failure Group with More than 1 Disk
• 2.18 File Group Usage
  • 2.18.1 Quota Limit Used (MB)
• 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 Offline Disk Count
  • 2.23.1 Offline Disk Count
• 2.24 Operational Error
  • 2.24.1 Setting Thresholds for Operational Error Metrics
  • 2.24.2 Alert Log Error Trace File
  • 2.24.3 Alert Log Name
  • 2.24.4 Data Block Corruption
  • 2.24.5 Generic Operational Error
  • 2.24.6 Media Failure
• 2.25 Response
  • 2.25.1 Status
• 2.26 Sparse Disk Group Usage
  • 2.26.1 Disk Group Physical Free (MB)
  • 2.26.2 Disk Group Physical Used (%)
  • 2.26.3 Physical Size (MB)
• 2.27 Sparse Disks
  • 2.27.1 Disks
  • 2.27.2 Disk Group
  • 2.27.3 Physical Size (MB)
• 2.28 Quota Group Usage
  • 2.28.1 Quota Limit (MB)
  • 2.28.2 Quota Limit Used (MB)
  • 2.28.3 Quota Limit Used (%)

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 25% or more (per second)
  • 5.30.10 Parallel Execution Downgraded 50% or more (per second)
  • 5.30.11 Parallel Execution Downgraded 75% or more (per second)
  • 5.30.12 Parallel Execution Downgraded to Serial (per second)
  • 5.30.13 Parallel Execution Downgraded to Serial (per transaction)
  • 5.30.14 PGA Cache Hit (%)
  • 5.30.15 Redo Log Allocation Hit (%)
  • 5.30.16 Response Time (per transaction)
  • 5.30.17 Row Cache Miss Ratio (%)
  • 5.30.18 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 Fragmented Text Indexes
  • 5.34.1 Fragmented Text Index count
  • 5.34.2 Fragmented Text Index count crossing critical threshold
  • 5.34.3 Fragmented Text Index count crossing warning threshold
• 5.35 Global Cache Statistics
  • 5.35.1 Global Cache Average Convert Time (centi-seconds)
  • 5.35.2 Global Cache Average CR Block Request Time (centi-seconds)
  • 5.35.3 Global Cache Average Current Block Request Time (centi-seconds)
  • 5.35.4 Global Cache Average Get Time (centi-seconds)
  • 5.35.5 Global Cache Blocks Corrupt
  • 5.35.6 Global Cache Blocks Lost
• 5.36 Incident
  • 5.36.1 Setting Thresholds for Incident Metrics
  • 5.36.2 Access Violation
  • 5.36.3 Alert Log Error Trace File
  • 5.36.4 Alert Log Name
  • 5.36.5 Cluster Error
  • 5.36.6 Deadlock
  • 5.36.7 File Access Error
  • 5.36.8 Generic Incident
  • 5.36.9 Generic Internal Error
  • 5.36.10 Impact
  • 5.36.11 Incident ID
  • 5.36.12 Inconsistent DB State
  • 5.36.13 Internal SQL Error
  • 5.36.14 Oracle Data Block Corruption
  • 5.36.15 Out of Memory
  • 5.36.16 Redo Log Corruption
  • 5.36.17 Session Terminated
• 5.37 Interconnect
  • 5.37.1 Interface Type
• 5.38 Interconnect Traffic
  • 5.38.1 Transfer Rate (MB/s)
• 5.39 Invalid Objects
  • 5.39.1 Invalid Object Count
• 5.40 Invalid Objects by Schema
  • 5.40.1 Invalid Object Count by Schema
• 5.41 Messages Per Buffered Queue
  • 5.41.1 Average Age of Messages Per Buffered Queue (Seconds)
  • 5.41.2 First Message Age in Buffered Queue Per Queue (Seconds)
  • 5.41.3 Messages processed per buffered queue (%)
  • 5.41.4 Messages Processed Per Buffered Queue (%) Per Minute
  • 5.41.5 Spilled Messages
  • 5.41.6 Total Messages Processed per Buffered Queue per Minute
  • 5.41.7 Total Messages Received per Buffered Queue per Minute
• 5.42 Message Per Buffered Queue Per Subscriber
  • 5.42.1 Average Age of Messages Per Buffered Queue Per Subscriber (Seconds)
  • 5.42.2 First Message Age in Buffered Queue per Subscriber (Seconds)
  • 5.42.3 Messages Processed Per Buffered Queue Per Subscriber (%)
  • 5.42.4 Messages Processed Per Buffered Queue (%) Per Subscriber Per Minute
  • 5.42.5 Total Messages Processed Per Buffered Queue Per Subscriber Per Minute
  • 5.42.6 Total Messages Received Per Buffered Queue Per Subscriber Per Minute
• 5.43 Messages Per Persistent Queue
  • 5.43.1 Age of the First Message in Persistent Queue Per Queue
  • 5.43.2 Average Age of Messages Per Persistent Queue (Seconds)
  • 5.43.3 Messages Processed Per Persistent Queue (%)
  • 5.43.4 Messages Processed Per Persistent Queue (%) Per Minute
  • 5.43.5 Total Messages Processed per Persistent Queue per Minute
  • 5.43.6 Total Messages Received per Persistent Queue per Minute
• 5.44 Messages Per Persistent Queue Per Subscriber
  • 5.44.1 Average Age of Messages Per Persistent Queue Per Subscriber (Seconds)
  • 5.44.2 Age of the First Message in Persistent Queue Per Subscriber
  • 5.44.3 Messages Processed Per Persistent Queue Per Subscriber (%)
  • 5.44.4 Messages Processed Per Persistent Queue (%) Per Subscriber Per Minute
  • 5.44.5 Total Messages Processed Per Persistent Queue Per Subscriber Per Minute
  • 5.44.6 Total Messages Received Per Persistent Queue Per Subscriber Per Minute
• 5.45 Memory Usage
  • 5.45.1 Total Memory Usage (MB)
• 5.46 OCM Instrumentation
  • 5.46.1 Instrumentation Present
  • 5.46.2 Need to Instrument with OCM
  • 5.46.3 OCM Configured
• 5.47 Operational Error
  • 5.47.1 Alert Log Error Trace File
  • 5.47.2 Alert Log Name
  • 5.47.3 Archiver Hung
  • 5.47.4 Data Block Corruption
  • 5.47.5 Generic Operational Error
  • 5.47.6 Media Failure
  • 5.47.7 User-Defined Error
  • 5.47.8 User-Defined Text
  • 5.47.9 User-Defined Warning
• 5.48 Operating System Audit Records
  • 5.48.1 Size of Audit Files (MB)
• 5.49 Recovery
  • 5.49.1 Corrupt Data Block Count
  • 5.49.2 Datafiles Need Media Recovery
  • 5.49.3 Missing Media File Count
• 5.50 Response
  • 5.50.1 State
  • 5.50.2 Status
• 5.51 SCN Growth Statistics
  • 5.51.1 Current SCN
  • 5.51.2 Current SCN Compatibility
  • 5.51.3 Max Rate
  • 5.51.4 Maximum SCN Compatibility
  • 5.51.5 SCN Health
  • 5.51.6 SCN Total Growth Rate (per sec)
• 5.52 SCN Instance Statistics
  • 5.52.1 SCN Intrinsic Growth Rate (per sec)
• 5.53 SCN Max Statistics
  • 5.53.1 Max SCN Jump in one second (last 24 hours)
• 5.54 Segment Advisor Recommendations
  • 5.54.1 Number of Recommendations
• 5.55 Session Suspended
  • 5.55.1 Session Suspended by Data Object Limitation
  • 5.55.2 Session Suspended by Quota Limitation
  • 5.55.3 Session Suspended by Rollback Segment Limitation
  • 5.55.4 Session Suspended by Tablespace Limitation
• 5.56 SGA Pool Wastage
  • 5.56.1 Java Pool Free (%)
  • 5.56.2 Large Pool Free (%)
  • 5.56.3 Shared Pool Free (%)
• 5.57 Snapshot Too Old
  • 5.57.1 Snapshot Too Old Due to Rollback Segment Limit
  • 5.57.2 Snapshot Too Old Due to Tablespace Limit
• 5.58 Space Usage by Buffered Queues
  • 5.58.1 Queue Size (MB)
  • 5.58.2 Space Usage of Buffered Queue With Respect to Streams Pool Size (%)
• 5.59 SQL Response Time
  • 5.59.1 Baseline SQL Response Time
  • 5.59.2 Current SQL Response Time
  • 5.59.3 SQL Response Time (%)
• 5.60 Streams Apply Aborted
  • 5.60.1 Streams Apply Process Aborted
  • 5.60.2 Streams Apply Process Error
• 5.61 Streams Apply Coordinator Statistics
  • 5.61.1 Total Number of Transactions Assigned
  • 5.61.2 Rate of Transactions Applied (per Sec)
  • 5.61.3 Rate of Transactions Assigned (per Sec)
  • 5.61.4 Rate of Transactions Received (per Sec)
  • 5.61.5 Total Number of Transactions Applied
  • 5.61.6 Total Number of Transactions Received
• 5.62 Streams Apply Errors
  • 5.62.1 Error Message
  • 5.62.2 Error Number
  • 5.62.3 Local Transaction ID
  • 5.62.4 Message Count
  • 5.62.5 Source Transaction ID
• 5.63 Streams Apply Queue - Buffered
  • 5.63.1 Streams Apply - (%) Spilled Messages
• 5.64 Streams Apply Queue - Persistent
  • 5.64.1 Streams Apply - (%) Messages in Waiting State
• 5.65 Streams Apply Reader Statistics
  • 5.65.1 Rate at Which Messages Are Getting Spilled (per Sec)
  • 5.65.2 Total Number of Messages Dequeued
  • 5.65.3 Total Number of Spilled Messages
• 5.66 Streams Capture Message Statistics
  • 5.66.1 Message Capture Rate (per Sec)
  • 5.66.2 Messages Enqueue Rate (per Sec)
  • 5.66.3 Total Messages Captured
  • 5.66.4 Total Messages Enqueued
• 5.67 Streams Capture Queue Statistics
  • 5.67.1 Capture Queue - Cumulative Number of Messages
  • 5.67.2 Capture Queue - Cumulative Number of Spilled Messages
  • 5.67.3 Capture Queue - Number of Messages
  • 5.67.4 Capture Queue - Number of Spilled Messages
  • 5.67.5 Streams Capture - (%) Cumulative Spilled Messages
  • 5.67.6 Streams Capture - (%) Spilled Messages
• 5.68 Streams Latency and Throughput
  • 5.68.1 Latency
  • 5.68.2 Throughput (per sec)
  • 5.68.3 Total Messages
• 5.69 Streams Pool Usage
  • 5.69.1 Streams Pool Full
• 5.70 Streams Processes Count
  • 5.70.1 Number of Apply Processes Having Errors
  • 5.70.2 Number of Capture Processes Having Errors
  • 5.70.3 Number of Apply Processes
  • 5.70.4 Number of Capture Processes
  • 5.70.5 Number of Propagation Jobs
  • 5.70.6 Number of Propagations Having Errors
  • 5.70.7 Total Number of Propagation Errors
• 5.71 Streams Processes Status
  • 5.71.1 Streams Process Errors
  • 5.71.2 Streams Process Status
• 5.72 Streams Propagation - Messages State Stats
  • 5.72.1 Number of Ready Messages
  • 5.72.2 Number of Waiting Messages
  • 5.72.3 Streams Prop - (%) Messages in Waiting State
• 5.73 Streams Propagation - Queue Propagation
  • 5.73.1 Message Propagation Rate (per Sec)
  • 5.73.2 Rate of KBytes Propagated (per Sec)
  • 5.73.3 Total Number of KBytes Propagated
  • 5.73.4 Total Number of Messages Propagated
• 5.74 Streams Propagation Aborted
  • 5.74.1 Streams Propagation Process Aborted
• 5.75 Suspended Session
  • 5.75.1 Suspended Session Count
• 5.76 System Response Time Per Call
  • 5.76.1 Response Time (centi-seconds per call)
• 5.77 System Sessions Waiting
  • 5.77.1 Waiting Session Count
• 5.78 Tablespace Allocation
  • 5.78.1 Tablespace Allocated Space (MB)
  • 5.78.2 Tablespace Used Space (MB)
• 5.79 Tablespaces Full
  • 5.79.1 Tablespace Free Space (MB)
  • 5.79.2 Tablespace Space Used (%)
• 5.80 Tablespaces Full (Dictionary Managed)
  • 5.80.1 Tablespace Free Space (MB) (Dictionary Managed)
  • 5.80.2 Tablespace Space Used (%) (Dictionary Managed)
• 5.81 Tablespaces Full (Temp)
  • 5.81.1 Tablespace Free Space (MB) (Temp)
  • 5.81.2 Tablespace Space Used (%) (Temp)
• 5.82 Tablespaces Full (Undo)
  • 5.82.1 Tablespace Free Space (MB) (Undo)
  • 5.82.2 Tablespace Space Used (%) (Undo)
• 5.83 Tablespaces With Problem Segments
  • 5.83.1 Segments Approaching Maximum Extents
  • 5.83.2 Segments Approaching Maximum Extents Count
  • 5.83.3 Segments Not Able to Extend
  • 5.83.4 Segments Not Able to Extend Count
• 5.84 Temporary File Status
  • 5.84.1 Status
• 5.85 Throughput
  • 5.85.1 Average Active Sessions
  • 5.85.2 Average Synchronous Single-Block Read Latency (ms)
  • 5.85.3 BG Checkpoints (per second)
  • 5.85.4 Branch Node Splits (per second)
  • 5.85.5 Branch Node Splits (per transaction)
  • 5.85.6 Consistent Read Blocks Created (per second)
  • 5.85.7 Consistent Read Blocks Created (per transaction)
  • 5.85.8 Consistent Read Changes (per second)
  • 5.85.9 Consistent Read Changes (per transaction)
  • 5.85.10 Consistent Read Gets (per second)
  • 5.85.11 Consistent Read Gets (per transaction)
  • 5.85.12 Consistent Read Undo Records Applied (per second)
  • 5.85.13 Consistent Read Undo Records Applied (per transaction)
  • 5.85.14 Cumulative Logons (per second)
  • 5.85.15 Cumulative Logons (per transaction)
  • 5.85.16 Database Block Changes (per second)
  • 5.85.17 Database Block Changes (per transaction)
  • 5.85.18 Database Block Gets (per second)
  • 5.85.19 Database Block Gets (per transaction)
  • 5.85.20 Database Time (centiseconds per second)
  • 5.85.21 DBWR Checkpoints (per second)
  • 5.85.22 Enqueue Deadlocks (per second)
  • 5.85.23 Enqueue Deadlocks (per transaction)
  • 5.85.24 Enqueue Requests (per second)
  • 5.85.25 Enqueue Requests (per transaction)
  • 5.85.26 Enqueue Timeout (per second)
  • 5.85.27 Enqueue Timeout (per transaction)
  • 5.85.28 Enqueue Waits (per second)
  • 5.85.29 Enqueue Waits (per transaction)
  • 5.85.30 Executes (per second)
  • 5.85.31 Executes Performed without Parses (%)
  • 5.85.32 Full Index Scans (per second)
  • 5.85.33 Full Index Scans (per transaction)
  • 5.85.34 Hard Parses (per second)
  • 5.85.35 Hard Parses (per transaction)
  • 5.85.36 I/O Megabytes (per second)
  • 5.85.37 I/O Requests (per second)
  • 5.85.38 Leaf Node Splits (per second)
  • 5.85.39 Leaf Node Splits (per transaction)
  • 5.85.40 Network Bytes (per second)
  • 5.85.41 Number of Transactions (per second)
  • 5.85.42 Open Cursors (per second)
  • 5.85.43 Open Cursors (per transaction)
  • 5.85.44 Parse Failure Count (per second)
  • 5.85.45 Parse Failure Count (per transaction)
  • 5.85.46 Physical Reads (per second)
  • 5.85.47 Physical Reads (per transaction)
  • 5.85.48 Physical Reads Direct (per second)
  • 5.85.49 Physical Reads Direct (per transaction)
  • 5.85.50 Physical Reads Direct Lobs (per second)
  • 5.85.51 Physical Reads Direct Lobs (per transaction)
  • 5.85.52 Physical Writes (per second)
  • 5.85.53 Physical Writes (per transaction)
  • 5.85.54 Physical Writes Direct (per second)
  • 5.85.55 Physical Writes Direct (per transaction)
  • 5.85.56 Physical Writes Direct Lobs (per second)
  • 5.85.57 Physical Writes Direct Lobs (per transaction)
  • 5.85.58 Recursive Calls (per second)
  • 5.85.59 Recursive Calls (per transaction)
  • 5.85.60 Redo Generated (per second)
  • 5.85.61 Redo Generated (per transaction)
  • 5.85.62 Redo Writes (per second)
  • 5.85.63 Redo Writes (per transaction)
  • 5.85.64 Rows Processed (per sort)
  • 5.85.65 Scans on Long Tables (per second)
  • 5.85.66 Scans on Long Tables (per transaction)
  • 5.85.67 Session Logical Reads (per second)
  • 5.85.68 Session Logical Reads (per transaction)
  • 5.85.69 Soft Parse (%)
  • 5.85.70 Sorts to Disk (per second)
  • 5.85.71 Sorts to Disk (per transaction)
  • 5.85.72 Total Index Scans (per second)
  • 5.85.73 Total Index Scans (per transaction)
  • 5.85.74 Total Parses (per second)
  • 5.85.75 Total Parses (per transaction)
  • 5.85.76 Total Table Scans (per second)
  • 5.85.77 Total Table Scans (per transaction)
  • 5.85.78 User Calls (%)
  • 5.85.79 User Calls (per second)
  • 5.85.80 User Calls (per transaction)
  • 5.85.81 User Commits (per second)
  • 5.85.82 User Commits (per transaction)
  • 5.85.83 User Rollback Undo Records Applied (per second)
  • 5.85.84 User Rollback Undo Records Applied (per transaction)
  • 5.85.85 User Rollbacks (per second)
  • 5.85.86 User Rollbacks (per transaction)
• 5.86 Total Objects by Schema
  • 5.86.1 Total Object Count
• 5.87 Total Tables by Schema
  • 5.87.1 Total Table Count
• 5.88 Unusable Indexes
  • 5.88.1 Unusable Index Count
• 5.89 Unusable Indexes by Schema
  • 5.89.1 Unusable Index Count by Schema
• 5.90 User Audit
  • 5.90.1 Audited User
  • 5.90.2 Audited User - Host
  • 5.90.3 Audited User Session Count
• 5.91 User Block
  • 5.91.1 Blocking Session Count
• 5.92 User Block Chain
  • 5.92.1 Blocking Session Count
  • 5.92.2 Blocking Session DB Time
• 5.93 User Locks
  • 5.93.1 Maximum Blocked DB Time (seconds)
  • 5.93.2 Maximum Blocked Session Count
• 5.94 User-Defined SQL
  • 5.94.1 User-Defined Numeric Metric
  • 5.94.2 User-Defined String Metric
• 5.95 Wait Bottlenecks
  • 5.95.1 Active Sessions Waiting: I/O
  • 5.95.2 Active Sessions Waiting: Other
  • 5.95.3 Buffer busy waits (%)
  • 5.95.4 CPU Time Delta (sec)
  • 5.95.5 DB file scattered read (%)
  • 5.95.6 DB file sequential read (%)
  • 5.95.7 DB file single write (%)
  • 5.95.8 Direct path read (%)
  • 5.95.9 Direct path read (lob) (%)
  • 5.95.10 Direct path write (%)
  • 5.95.11 Direct path write (lob) (%)
  • 5.95.12 Enqueue - other (%)
  • 5.95.13 Enqueue: DML - contention (%)
  • 5.95.14 Enqueue: HW, Segment High Water Mark - contention (%)
  • 5.95.15 Enqueue: ST, Space Transaction - contention (%)
  • 5.95.16 Enqueue: TM, TX, Transaction - row lock contention (%)
  • 5.95.17 Enqueue: TX mode 4, Transaction - allocate ITL entry (%)
  • 5.95.18 Enqueue: UL: User-defined - contention (%)
  • 5.95.19 Free buffer waits (%)
  • 5.95.20 Latch free - other (%)
  • 5.95.21 Latch: cache buffer chains (%)
  • 5.95.22 Latch: library cache (%)
  • 5.95.23 Latch: redo copy (%)
  • 5.95.24 Latch: shared pool (%)
  • 5.95.25 Library cache load lock (%)
  • 5.95.26 Library cache lock (%)
  • 5.95.27 Library cache pin (%)
  • 5.95.28 Local write wait (%)
  • 5.95.29 Log buffer space (%)
  • 5.95.30 Log file switch (archiving needed) (%)
  • 5.95.31 Log file switch (checkpoint complete) (%)
  • 5.95.32 Log file switch completion (%)
  • 5.95.33 Log file sync (%)
  • 5.95.34 Log switch/archive (%)
  • 5.95.35 Pipe put (%)
  • 5.95.36 Row cache lock (%)
  • 5.95.37 SQL*Net break/reset to client (%)
  • 5.95.38 SQL*Net break/reset to dblink (%)
  • 5.95.39 SQL*Net message to client (%)
  • 5.95.40 SQL*Net message to dblink (%)
  • 5.95.41 SQL*Net more data from client (%)
  • 5.95.42 SQL*Net more data from dblink (%)
  • 5.95.43 SQL*Net more data to client (%)
  • 5.95.44 SQL*Net more data to dblink (%)
  • 5.95.45 Wait Time (%)
  • 5.95.46 Write complete waits (%)
• 5.96 Wait by Session Count
  • 5.96.1 Session Waiting for Event Count
• 5.97 Waits by Wait Class
  • 5.97.1 Average Users Waiting Count
  • 5.97.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 Fragmented Text Indexes
  • 6.23.1 Fragmented Text Index count
  • 6.23.2 Fragmented Text Index count crossing critical threshold
  • 6.23.3 Fragmented Text Index count crossing warning threshold
• 6.24 Invalid Objects
  • 6.24.1 Invalid Object Count
• 6.25 Invalid Objects by Schema
  • 6.25.1 Invalid Object Count by Schema
• 6.26 Messages Per Buffered Queue
  • 6.26.1 Average age of messages per buffered queue (seconds)
  • 6.26.2 First Message Age in Buffered Queue Per Queue (Seconds)
  • 6.26.3 Messages processed per buffered queue (%)
  • 6.26.4 Messages processed per buffered queue (%) per minute
  • 6.26.5 Spilled Messages
  • 6.26.6 Total Messages Processed per Buffered Queue per Minute
  • 6.26.7 Total Messages Received per Buffered Queue per Minute
• 6.27 Messages Per Buffered Queue Per Subscriber
  • 6.27.1 Average Age of Messages Per Buffered Queue Per Subscriber (Seconds)
  • 6.27.2 First Message Age in Buffered Queue per Subscriber (Seconds)
  • 6.27.3 Messages Processed Per Buffered Queue (%) Per Subscriber Per Minute
  • 6.27.4 Messages Processed Per Buffered Queue Per Subscriber (%)
  • 6.27.5 Total Messages Processed Per Buffered Queue Per Subscriber Per Minute
  • 6.27.6 Total Messages Received Per Buffered Queue Per Subscriber Per Minute
• 6.28 Messages Per Persistent Queue
  • 6.28.1 Average Age of Messages Per Persistent Queue (Seconds)
  • 6.28.2 Age of The First Message in Persistent Queue Per Queue (Seconds)
  • 6.28.3 Messages Processed Per Persistent Queue (%)
  • 6.28.4 Messages Processed Per Persistent Queue (%) Per Minute
  • 6.28.5 Total Messages Processed per Persistent Queue per Minute
  • 6.28.6 Total Messages Received per Persistent Queue per Minute
• 6.29 Messages Per Persistent Queue Per Subscriber
  • 6.29.1 Average Age of Messages Per Persistent Queue Per Subscriber (Seconds)
  • 6.29.2 First Message Age in Persistent Queue per Subscriber (Seconds)
  • 6.29.3 Messages Processed Per Persistent Queue (%) Per Subscriber Per Minute
  • 6.29.4 Messages Processed Per Persistent Queue Per Subscriber (%)
  • 6.29.5 Total Messages Processed Per Persistent Queue Per Subscriber Per Minute
  • 6.29.6 Total Messages Received Per Persistent Queue Per Subscriber Per Minute
• 6.30 QoS Management - Performance Satisfaction
  • 6.30.1 Negative PSM Duration (seconds)
• 6.31 Recovery
  • 6.31.1 Corrupt Data Block Count
  • 6.31.2 Missing Media File Count
• 6.32 Recovery Area
  • 6.32.1 Recovery Area Free Space (%)
• 6.33 SCN Growth Statistics
  • 6.33.1 SCN Health
• 6.34 SCN Max Statistics
  • 6.34.1 Max SCN Jump in one second (last 24 hours)
• 6.35 Segment Advisor Recommendations
  • 6.35.1 Number of recommendations
• 6.36 Session Suspended
  • 6.36.1 Session Suspended by Data Object Limitation
  • 6.36.2 Session Suspended by Quota Limitation
  • 6.36.3 Session Suspended by Rollback Segment Limitation
  • 6.36.4 Session Suspended by Tablespace Limitation
• 6.37 Snapshot Too Old
  • 6.37.1 Snapshot Too Old due to Rollback Segment Limit
  • 6.37.2 Snapshot Too Old due to Tablespace Limit
• 6.38 Space Usage by Buffered Queues
  • 6.38.1 Queue Size (MB)
  • 6.38.2 Space Usage of Buffered Queue With Respect to Streams Pool Size (%)
• 6.39 Streams Apply Queue - Buffered
  • 6.39.1 Streams Apply - (%)Spilled Messages
• 6.40 Streams Apply Queue - Persistent
  • 6.40.1 Streams Apply - (%)Messages in Waiting State
• 6.41 Streams Apply Reader Statistics
  • 6.41.1 Rate at Which Messages Are Getting Spilled (Per Sec)
• 6.42 Streams Capture Queue Statistics
  • 6.42.1 Streams Capture - (%)Spilled Messages
• 6.43 Streams Latency and Throughput
  • 6.43.1 Latency
  • 6.43.2 Throughput (per sec)
• 6.44 Streams Processes Count
  • 6.44.1 Apply Processes Having Errors
  • 6.44.2 Capture Processes Having Errors
  • 6.44.3 Number of Apply Processes
  • 6.44.4 Number of Capture Processes
  • 6.44.5 Number of Propagation Jobs
  • 6.44.6 Propagation Errors
• 6.45 Streams Propagation - Message State Stats
  • 6.45.1 Streams Prop - (%)Messages in Waiting State
• 6.46 Suspended Session
  • 6.46.1 Suspended Session Count
• 6.47 Tablespace Allocation
  • 6.47.1 Tablespace Allocated Space (MB)
  • 6.47.2 Tablespace Used Space (MB)
• 6.48 Tablespaces Full
  • 6.48.1 Tablespace Free Space (MB)
  • 6.48.2 Tablespace Space Used (%)
• 6.49 Tablespaces Full (dictionary managed)
  • 6.49.1 Tablespace Free Space (MB) (dictionary managed)
  • 6.49.2 Tablespace Space Used (%) (dictionary managed)
• 6.50 Tablespaces With Problem Segments
  • 6.50.1 Segments Approaching Maximum Extents Count
  • 6.50.2 Segments Not Able to Extend Count
• 6.51 Temporary File Status
  • 6.51.1 Temporary File Id
• 6.52 Total Objects by Schema
  • 6.52.1 Total Object Count
• 6.53 Total Tables by Schema
  • 6.53.1 Total Table Count
• 6.54 Unusable Indexes
  • 6.54.1 Unusable Index Count
• 6.55 Unusable Indexes by Schema
  • 6.55.1 Unusable Index Count by Schema
• 6.56 User Block
  • 6.56.1 Blocking Session Count
• 6.57 User Locks
  • 6.57.1 Maximum Blocked DB Time (seconds)
  • 6.57.2 Maximum Blocked Session Count

7 Recovery Appliance

• 7.1 Data Sent/Received
  • 7.1.1 Backup Data Rate (GB/s)
  • 7.1.2 Cumulative Backup Data Delta (GB)
  • 7.1.3 Cumulative Backup Data Received (GB)
  • 7.1.4 Cumulative Copy-to-Tape Data Delta (GB)
  • 7.1.5 Cumulative Copy-to-Tape Data Sent (GB)
  • 7.1.6 Cumulative Replication Data Delta (GB)
  • 7.1.7 Cumulative Replication Data Sent (GB)
  • 7.1.8 Replication Data Rate (GB/s)
• 7.2 Health
  • 7.2.1 Database Key
  • 7.2.2 Database Unique Name
  • 7.2.3 Incident ID
  • 7.2.4 Component
  • 7.2.5 Error Code
  • 7.2.6 Error Text
  • 7.2.7 Parameter
  • 7.2.8 Severity
  • 7.2.9 Storage Location Key
  • 7.2.10 Storage Location Name
• 7.3 Protected Databases
  • 7.3.1 Backup Data Rate (GB/s)
  • 7.3.2 Copy-to-Tape Data Rate (GB/s)
  • 7.3.3 Copy-to-Tape Queued Data (GB)
  • 7.3.4 Copy-to-Tape Queued Data Age (hours)
  • 7.3.5 Copy-to-Tape Total Data on Tape (GB)
  • 7.3.6 Cumulative Backup Data (GB)
  • 7.3.7 Cumulative Backup Data Delta (GB)
  • 7.3.8 Cumulative Copy-to-Tape Data (GB)
  • 7.3.9 Cumulative Copy-to-Tape Data Delta (GB)
  • 7.3.10 Cumulative Replication Data Delta (GB)
  • 7.3.11 Cumulative Replication Data (GB)
  • 7.3.12 Current Recovery Window (interval)
  • 7.3.13 Current Recovery Window (sec)
  • 7.3.14 Database Key
  • 7.3.15 Database Unique Name
  • 7.3.16 Date Added as Protected Database
  • 7.3.17 Deduplication Ratio
  • 7.3.18 Keep Backup Space (GB)
  • 7.3.19 Last Complete Backup
  • 7.3.20 Last Copy to Tape
  • 7.3.21 Last Replication
  • 7.3.22 Most Recent Recovery Point
  • 7.3.23 Near-Zero Data Loss Enabled
  • 7.3.24 Number of Protected Databases
  • 7.3.25 Oldest Recovery Point
  • 7.3.26 Protection Policy
  • 7.3.27 Recovery Window Goal (interval)
  • 7.3.28 Recovery Window Goal (sec)
  • 7.3.29 Recovery Window Ratio (%)
  • 7.3.30 Recovery Window Space (GB)
  • 7.3.31 Recovery Window Space as a Percentage of Reserved Space
  • 7.3.32 Replication Data Rate (GB/s)
  • 7.3.33 Replication Queued Data (GB)
  • 7.3.34 Reserved Space (GB)
  • 7.3.35 Storage Location
  • 7.3.36 Unprotected Data Window (sec)
  • 7.3.37 Unprotected Data Window Threshold (sec)
  • 7.3.38 Used Space (GB)
• 7.4 Queued Data
  • 7.4.1 Backup Tasks Queued Since Last Collection
  • 7.4.2 Copy-to-Tape Tasks Queued Since Last Collection
  • 7.4.3 Replication Tasks Queued Since Last Collection
  • 7.4.4 Total Backup Tasks Queued
  • 7.4.5 Total Copy-to-Tape Data Queued (bytes)
  • 7.4.6 Total Copy-to-Tape Tasks Queued
  • 7.4.7 Total Replication Data Queued (bytes)
  • 7.4.8 Total Replication Tasks Queued
• 7.5 Replication Status
  • 7.5.1 Replication Server Name
  • 7.5.2 Replication Status
  • 7.5.3 SBT Library Name
• 7.6 Response
  • 7.6.1 Status
• 7.7 Storage Locations
  • 7.7.1 Incoming Backup Data Rate (GB/s)
  • 7.7.2 Key
  • 7.7.3 Name
  • 7.7.4 Number of Storage Locations
  • 7.7.5 Recovery Window Space (GB)
  • 7.7.6 Recovery Window Space as a Percentage of Reserved Space
  • 7.7.7 Recovery Window Space as a Percentage of Storage Location Size
  • 7.7.8 Reserved Space (GB)
  • 7.7.9 Size (GB)
  • 7.7.10 Unreserved Space (GB)
  • 7.7.11 Unused Space (GB)
  • 7.7.12 Used Space (GB)

8 Listener

• 8.1 General Status
  • 8.1.1 Alias
  • 8.1.2 Security
  • 8.1.3 SID List
  • 8.1.4 SNMP Status
  • 8.1.5 Start Date
  • 8.1.6 TNS Address
  • 8.1.7 Trace Level
  • 8.1.8 Version
• 8.2 Listener Ports
• 8.3 Listener Services
• 8.4 Load
  • 8.4.1 Connections Established
  • 8.4.2 Connections Established (per min)
  • 8.4.3 Connections Refused
  • 8.4.4 Connections Refused (per min)
• 8.5 Response
  • 8.5.1 Response Time (msec)
  • 8.5.2 Status
• 8.6 TNS Errors
  • 8.6.1 TNSMsg

9 Oracle Exadata

• 9.1 Oracle Exadata Storage Server
  • 9.1.1 Aggregated Exadata Capacity
    • 9.1.1.1 Disk Size (GB)
    • 9.1.1.2 Disk Type
    • 9.1.1.3 Usage (%)
  • 9.1.2 Aggregated Exadata CellDisk
    • 9.1.2.1 Average CellDisk IO Load
    • 9.1.2.2 Average CellDisk Read IOPS
    • 9.1.2.3 Average CellDisk Read Response Time
    • 9.1.2.4 Average CellDisk Read Throughput
    • 9.1.2.5 Average CellDisk Write IOPS
    • 9.1.2.6 Average CellDisk Write Response Time
    • 9.1.2.7 Average CellDisk Write Throughput
    • 9.1.2.8 Maximum CellDisk IO Load
    • 9.1.2.9 Total CellDisk Read Throughput
    • 9.1.2.10 Total CellDisk Write IOPS
    • 9.1.2.11 Total CellDisk Write Throughput
    • 9.1.2.12 Total CellDisk IO Load
    • 9.1.2.13 Total CellDisk Read IOPS
  • 9.1.3 Aggregated Exadata Diskgroup Capacity
    • 9.1.3.1 ASM Instance
    • 9.1.3.2 Count
    • 9.1.3.3 Diskgroup Name
    • 9.1.3.4 Size (GB)
  • 9.1.4 Aggregated Exadata FlashDisk and HardDisk
    • 9.1.4.1 Average CellDisk IO Load
    • 9.1.4.2 Average CellDisk Large Read IOPS
    • 9.1.4.3 Average CellDisk IO Utilization
    • 9.1.4.4 Average CellDisk Large Read Response Time
    • 9.1.4.5 Average CellDisk Large Read Throughput
    • 9.1.4.6 Average CellDisk Large Write IOPS
    • 9.1.4.7 Average CellDisk Large Write Response Time
    • 9.1.4.8 Average CellDisk Large Write Throughput
    • 9.1.4.9 Average CellDisk Read IOPS
    • 9.1.4.10 Average CellDisk Read Response Time
    • 9.1.4.11 Average CellDisk Read Throughput
    • 9.1.4.12 Average CellDisk Small Read IOPS
    • 9.1.4.13 Average CellDisk Small Read Response Time
    • 9.1.4.14 Average CellDisk Small Read Throughput
    • 9.1.4.15 Average CellDisk Small Write IOPS
    • 9.1.4.16 Average CellDisk Small Write Response Time
    • 9.1.4.17 Average CellDisk Small Write Throughput
    • 9.1.4.18 Average CellDisk Write IOPS
    • 9.1.4.19 Average CellDisk Write Response Time
    • 9.1.4.20 Average CellDisk Write Throughput
    • 9.1.4.21 CellDisk Type
    • 9.1.4.22 Maximum CellDisk Small Read Response Time
    • 9.1.4.23 Maximum CellDisk Small Write Response Time
    • 9.1.4.24 Total CellDisk IO Load
    • 9.1.4.25 Total CellDisk IO Utilization
    • 9.1.4.26 Total CellDisk Read IOPS
    • 9.1.4.27 Total CellDisk Read Throughput
    • 9.1.4.28 Total CellDisk Write IOPS
    • 9.1.4.29 Total CellDisk Write Throughput
  • 9.1.5 Cell Generated Alert
    • 9.1.5.1 Action
    • 9.1.5.2 ADR Incident ID
    • 9.1.5.3 ADR Problem Key
    • 9.1.5.4 ADR Trace File Name
    • 9.1.5.5 Alert Begin Time
    • 9.1.5.6 Alert Object
    • 9.1.5.7 Alert Name
    • 9.1.5.8 Alert Sequence
    • 9.1.5.9 Alert Type
    • 9.1.5.10 ECID
    • 9.1.5.11 Examined By
    • 9.1.5.12 Msg
    • 9.1.5.13 Notification
    • 9.1.5.14 Sequence Begin Time
    • 9.1.5.15 Severity
  • 9.1.6 CellSrv Status
    • 9.1.6.1 CellSrv Status
  • 9.1.7 Exadata Cell Metric
    • 9.1.7.1 Cell Name
    • 9.1.7.2 CPU Utilization
    • 9.1.7.3 Disk I/O Objective
    • 9.1.7.4 Exadata Run Queue Length
    • 9.1.7.5 Exadata Temperature Lower Threshold
    • 9.1.7.6 Exadata Temperature Reading
    • 9.1.7.7 Exadata Temperature Upper Threshold
    • 9.1.7.8 IORM Boost
    • 9.1.7.9 LED Status
    • 9.1.7.10 Memory Utilization
    • 9.1.7.11 Network Received
    • 9.1.7.12 Network Sent
    • 9.1.7.13 Offload Efficiency
  • 9.1.8 Exadata CellDisk Metric
    • 9.1.8.1 Average Large Read Response Time
    • 9.1.8.2 Average Large Write Response Time
    • 9.1.8.3 Average Read Response Time
    • 9.1.8.4 Average Small Read Response Time
    • 9.1.8.5 Average Small Write Response Time
    • 9.1.8.6 Average Write Response Time
    • 9.1.8.7 CellDisk Type
    • 9.1.8.8 IO Load
    • 9.1.8.9 IO Utilization
    • 9.1.8.10 Large Read Bytes
    • 9.1.8.11 Large Read Requests
    • 9.1.8.12 Large Write Bytes
    • 9.1.8.13 Large Write Requests
    • 9.1.8.14 Object Name
    • 9.1.8.15 Read IOPS
    • 9.1.8.16 Read Throughput (MBPS)
    • 9.1.8.17 Small Read Bytes
    • 9.1.8.18 Small Read Requests
    • 9.1.8.19 Small Write Bytes
    • 9.1.8.20 Small Write Requests
    • 9.1.8.21 Write IOPS
    • 9.1.8.22 Write Throughput (MBPS)
  • 9.1.9 Exadata CellDisk Load Imbalance
    • 9.1.9.1 IO Load Imbalance
    • 9.1.9.2 Object Name
  • 9.1.10 Exadata Disk Status Metric
    • 9.1.10.1 Disk Status
  • 9.1.11 Exadata Flash Cache Metric
    • 9.1.11.1 Cell Name
    • 9.1.11.2 Default Hits
    • 9.1.11.3 Default Hits (%)
    • 9.1.11.4 Default Misses
    • 9.1.11.5 Default Misses (%)
    • 9.1.11.6 Default Read IOPS
    • 9.1.11.7 Default Read Throughput (MBPS)
    • 9.1.11.8 Default Used (GB)
    • 9.1.11.9 Flash Cache All I/O Requests
    • 9.1.11.10 First Writes
    • 9.1.11.11 First Writes Per Second
    • 9.1.11.12 Flash Cache I/O Requests Keep Pool Misses
    • 9.1.11.13 Flash Cache I/O Requests Read Misses
    • 9.1.11.14 Flash Cache I/O Requests for keep
    • 9.1.11.15 Flash Cache Megabytes Read Misses
    • 9.1.11.16 Flash Cache Megabytes Reads
    • 9.1.11.17 Flash Cache Megabytes Reads for Keep
    • 9.1.11.18 Flash Cache Read IOPS
    • 9.1.11.19 Keep Hits
    • 9.1.11.20 Keep Hits (%)
    • 9.1.11.21 Keep Misses
    • 9.1.11.22 Keep Misses (%)
    • 9.1.11.23 Keep Pool Read IOPS
    • 9.1.11.24 Keep Pool Read Throughput (MBPS)
    • 9.1.11.25 Keep Pool Used (GB)
    • 9.1.11.26 Read Throughput (MBPS)
    • 9.1.11.27 Requests that are first writes into flash cache
    • 9.1.11.28 Requests that are overwrites into Flash Cache
    • 9.1.11.29 Used (GB)
    • 9.1.11.30 Write IO requests that bypass Flash Cache
  • 9.1.12 Exadata Flash Log Metric
    • 9.1.12.1 Cell Name
    • 9.1.12.2 Efficiency of Smart Flash Logging (%)
  • 9.1.13 Exadata IORM Consumer Group Metric
    • 9.1.13.1 Average I/O Throughput (MB/Sec)
    • 9.1.13.2 Average Wait Time for I/O (ms/req)
    • 9.1.13.3 Cell Name
    • 9.1.13.4 I/O Requests per Second (IO/sec)
    • 9.1.13.5 I/O Utilization (%)
  • 9.1.14 Exadata IORM DB
    • 9.1.14.1 Average I/O Load
    • 9.1.14.2 Average I/O Throughput (MB/Sec)
    • 9.1.14.3 Average Wait Time for I/O (ms/req)
    • 9.1.14.4 Average Wait Time for Large I/O (ms/req)
    • 9.1.14.5 Average Wait Time for Small I/O (ms/req)
    • 9.1.14.6 Average latency of reading or writing blocks/request from flash disks
    • 9.1.14.7 Average latency of reading blocks/request from hard disks
    • 9.1.14.8 Average latency of reading large blocks/request from hard disks
    • 9.1.14.9 Average latency of reading small blocks/request from hard disks
    • 9.1.14.10 Cell Name
    • 9.1.14.11 Cumulative latency of reading blocks from flash disks
    • 9.1.14.12 Cumulative latency of reading large blocks from hard disks
    • 9.1.14.13 Cumulative latency of reading small blocks from hard disks
    • 9.1.14.14 I/O Requests per Second (IO/Sec)
    • 9.1.14.15 I/O Requests per Second - Large (IO/Sec)
    • 9.1.14.16 I/O Requests per Second - Small (IO/Sec)
    • 9.1.14.17 IO Utilization (%)
    • 9.1.14.18 Large I/O Utilization (%)
    • 9.1.14.19 Small IO Utilization (%)
    • 9.1.14.20 Wait Time for Large I/O (ms)
    • 9.1.14.21 Wait Time for Small I/O (ms)
  • 9.1.15 Exadata IORM Pluggable Database Metric
    • 9.1.15.1 Average I/O Load
    • 9.1.15.2 Average I/O Throughput (MB/Sec)
    • 9.1.15.3 Average Wait Time for Large I/O (ms/req)
    • 9.1.15.4 Average Wait Time for Small I/O (ms/req)
    • 9.1.15.5 Average Wait Time for I/O (ms/req)
    • 9.1.15.6 Cell Name
    • 9.1.15.7 I/O Requests per Second (IO/Sec)
    • 9.1.15.8 I/O Requests per Second - Large (IO/Sec)
    • 9.1.15.9 I/O Requests per Second - Small (IO/Sec)
    • 9.1.15.10 I/O Utilization (%)
    • 9.1.15.11 Large I/O Utilization (%)
    • 9.1.15.12 Small I/O Utilization (%)
    • 9.1.15.13 Wait Time for Large I/O (ms)
    • 9.1.15.14 Wait Time for Small I/O (ms)
  • 9.1.16 Exadata Smart IO Metric
    • 9.1.16.1 Cell Name
    • 9.1.16.2 Megabytes per second of pass through IOs
    • 9.1.16.3 Megabytes per second read from flash cache
    • 9.1.16.4 Megabytes per second read from hard disk
    • 9.1.16.5 Megabytes per second saved by storage index
  • 9.1.17 Filesystem Utilization
    • 9.1.17.1 Cell Name
    • 9.1.17.2 Filesystem Utilization %
  • 9.1.18 HCA Port Configuration Monitor
    • 9.1.18.1 HCA Node GUID
    • 9.1.18.2 Is this port disconnected (yes/no)
    • 9.1.18.3 Port GUID
    • 9.1.18.4 Switch GUID on the other end of the link
    • 9.1.18.5 Switch Name to which this port is connected
    • 9.1.18.6 Switch Port number on the other end of the link
  • 9.1.19 HCA Port Errors
    • 9.1.19.1 Excessive buffer overruns
    • 9.1.19.2 Incoming VL15 packets dropped due to resource limitation
    • 9.1.19.3 Link integrity errors
    • 9.1.19.4 Link recovers
    • 9.1.19.5 Packets not transmitted due to constraints
    • 9.1.19.6 Received packets discarded due to constraints
    • 9.1.19.7 Received packets marked with the EBP delimiter
    • 9.1.19.8 Received packets with error
    • 9.1.19.9 Symbol errors
    • 9.1.19.10 Total errors
  • 9.1.20 HCA Port State
    • 9.1.20.1 Active link width of port based on cable connectivity (e.g., 1X)
    • 9.1.20.2 Is the link degraded? (active speed or width less than enabled)
    • 9.1.20.3 Link state (0 = Down, 1 = Active)
    • 9.1.20.4 Physical link state (0 = Disabled/Polling, 1 = LinkUp)
    • 9.1.20.5 The active link speed (Gbps)
  • 9.1.21 HCA Port State (For Alerts)
    • 9.1.21.1 Is port disabled?
    • 9.1.21.2 Is port in 'polling' state?
  • 9.1.22 Host Interconnect Statistics
    • 9.1.22.1 Cell Name
    • 9.1.22.2 Host MB Dropped Per Sec
    • 9.1.22.3 Host MB Received Per Sec
    • 9.1.22.4 Host MB Resent Per Sec
    • 9.1.22.5 Host MB sent Per Sec
    • 9.1.22.6 Host RDMA MB Dropped Per Sec
    • 9.1.22.7 Host RDMA Retry Latency (msec)
  • 9.1.23 Response
    • 9.1.23.1 Response Status
  • 9.1.24 Top CPU
    • 9.1.24.1 Activity(%)
    • 9.1.24.2 Begin Sequence
    • 9.1.24.3 Database Name
    • 9.1.24.4 End Sequence
    • 9.1.24.5 Incarnation
    • 9.1.24.6 Samples
    • 9.1.24.7 SQLID
    • 9.1.24.8 Total Samples
• 9.2 Oracle Database Exadata Storage Server System
  • 9.2.1 Agg_Exadata_System_Celldisk_Metric
    • 9.2.1.1 Average Flash Disk IO Load
    • 9.2.1.2 Average Flash Disk Read IOPS
    • 9.2.1.3 Average Flash Disk Read Throughput
    • 9.2.1.4 Average Flash Disk Write IOPS
    • 9.2.1.5 Average Flash Disk Write Throughput
    • 9.2.1.6 Average Hard Disk IO Load
    • 9.2.1.7 Average Hard Disk Read IOPS
    • 9.2.1.8 Average Hard Disk Read Throughput
    • 9.2.1.9 Average Hard Disk Write IOPS
    • 9.2.1.10 Average Hard Disk Write Throughput
    • 9.2.1.11 Maximum Flash Disk IO Load
    • 9.2.1.12 Maximum Flash Disk Read IOPS
    • 9.2.1.13 Maximum Flash Disk Read Throughput
    • 9.2.1.14 Maximum Flash Disk Write IOPS
    • 9.2.1.15 Maximum Flash Disk Write Throughput
    • 9.2.1.16 Maximum Hard Disk IO Load
    • 9.2.1.17 Maximum Hard Disk Read IOPS
    • 9.2.1.18 Maximum Hard Disk Read Throughput
    • 9.2.1.19 Maximum Hard Disk Write IOPS
    • 9.2.1.20 Maximum Hard Disk Write Throughput
    • 9.2.1.21 Minimum Flash Disk IO Load
    • 9.2.1.22 Minimum Flash Disk Read IOPS
    • 9.2.1.23 Minimum Flash Disk Read Throughput
    • 9.2.1.24 Minimum Flash Disk Write IOPS
    • 9.2.1.25 Minimum Flash Disk Write Throughput
    • 9.2.1.26 Minimum Hard Disk IO Load
    • 9.2.1.27 Minimum Hard Disk Read IOPS
    • 9.2.1.28 Minimum Hard Disk Read Throughput
    • 9.2.1.29 Minimum Hard Disk Write IOPS
    • 9.2.1.30 Minimum Hard Disk Write Throughput
  • 9.2.2 Response
    • 9.2.2.1 Status
• 9.3 Oracle Exadata Storage Server Grid
  • 9.3.1 Response
    • 9.3.1.1 Status

10 Pluggable Databases

• 10.1 Database Feature Usage
  • 10.1.1 Count
  • 10.1.2 Currently Used
  • 10.1.3 DBID
  • 10.1.4 Detected Usages
  • 10.1.5 Feature Info
  • 10.1.6 Feature Name
  • 10.1.7 First Usage Date
  • 10.1.8 Last Sample Date
  • 10.1.9 Last Sample Period
  • 10.1.10 Last Usage Date
  • 10.1.11 Total Samples
  • 10.1.12 Version
• 10.2 Datafiles
  • 10.2.1 Autoextensible
  • 10.2.2 Datafile Name
  • 10.2.3 File Size
  • 10.2.4 Initial File Size
  • 10.2.5 Increment By
  • 10.2.6 Max File Size
  • 10.2.7 Status
  • 10.2.8 Storage Entity
  • 10.2.9 Tablespace
• 10.3 Database Job Status
  • 10.3.1 Broken Job Count
  • 10.3.2 Failed Job Count
• 10.4 Database Services
  • 10.4.1 Service CPU Time (per user call) (microseconds)
  • 10.4.2 Service Response Time (per user call) (microseconds)
• 10.5 Failed Logins
  • 10.5.1 Failed Login Count
• 10.6 Invalid Objects
  • 10.6.1 Total Invalid Object Count
• 10.7 Invalid Objects by Schema
  • 10.7.1 Owner's Invalid Object Count
• 10.8 Messages per buffered queue
  • 10.8.1 Average age of messages per buffered queue (seconds)
  • 10.8.2 Spilled Messages
  • 10.8.3 First message age in the buffered queue per queue (seconds)
  • 10.8.4 Messages processed per buffered queue (%)
  • 10.8.5 Total Messages Processed per Buffered Queue per Minute
  • 10.8.6 Total messages received per buffered queue per minute
  • 10.8.7 Total number of messages processed
  • 10.8.8 Total number of messages received
• 10.9 Messages per buffered queue per subscriber
  • 10.9.1 Average age of messages/buffered queue/subscriber (seconds)
  • 10.9.2 First message age in buffered queue per subscriber (seconds)
  • 10.9.3 Messages processed/buffered queue/subscriber (%)
  • 10.9.4 Messages processed/buffered queue/subscriber per minute (%)
  • 10.9.5 Total messages processed/buffered queue/subscriber per minute
  • 10.9.6 Total messages received/buffered queue/subscriber per minute
  • 10.9.7 Total number of messages processed
  • 10.9.8 Total number of messages received
• 10.10 Messages per persistent queue
  • 10.10.1 Average age of messages per persistent queue (seconds)
  • 10.10.2 First message age in persistent queue/queue (seconds)
  • 10.10.3 Global Database Name
  • 10.10.4 Messages processed per persistent queue (%)
  • 10.10.5 Messages processed per persistent queue per minute (%)
  • 10.10.6 Total messages processed per persistent queue per minute
  • 10.10.7 Total messages received per persistent queue per minute
  • 10.10.8 Total number of messages processed
  • 10.10.9 Total number of messages received
• 10.11 Messages per persistent queue per subscriber
  • 10.11.1 Average age of messages/persistent queue/subscriber (seconds)
  • 10.11.2 First message age in persistent queue/subscriber (seconds)
  • 10.11.3 Global Database Name
  • 10.11.4 Messages processed/persistent queue/subscriber per minute (%)
  • 10.11.5 Messages processed/persistent queue/subscriber (%)
  • 10.11.6 Total messages processed/persistent queue/subscriber per minute (%)
  • 10.11.7 Total messages received/persistent queue/subscriber per minute
  • 10.11.8 Total number of messages processed
  • 10.11.9 Total number of messages received
• 10.12 Response
  • 10.12.1 State
  • 10.12.2 Status
  • 10.12.3 ORA- Error
• 10.13 Rollback Segments
  • 10.13.1 Name
  • 10.13.2 Aveactive
  • 10.13.3 Aveshrink
  • 10.13.4 Extents
  • 10.13.5 Hwmsize
  • 10.13.6 Initial Size
  • 10.13.7 Maximum Size
  • 10.13.8 Minimum Extents
  • 10.13.9 Next Size
  • 10.13.10 Optsize
  • 10.13.11 Pct Increase
  • 10.13.12 Size
  • 10.13.13 Shrinks
  • 10.13.14 Status
  • 10.13.15 Tablespace Name
  • 10.13.16 Wraps
• 10.14 Segment Advisor Recommendations
  • 10.14.1 Number of recommendations
• 10.15 Tablespaces
  • 10.15.1 Allocation Type
  • 10.15.2 Big File
  • 10.15.3 Block Size
  • 10.15.4 Extent Management
  • 10.15.5 Increment By
  • 10.15.6 Initial Ext Size
  • 10.15.7 Logging
  • 10.15.8 Max Extents
  • 10.15.9 Minimum Extent Size
  • 10.15.10 Minimum Extents
  • 10.15.11 Next Extent
  • 10.15.12 Segment Space Management
  • 10.15.13 Size
  • 10.15.14 Status
  • 10.15.15 Tablespace Name
  • 10.15.16 Type
  • 10.15.17 Used Size(B)
  • 10.15.18 Tablespace Used Space (MB)
• 10.16 Tablespace Allocation
  • 10.16.1 Tablespace Allocated Space (MB)
  • 10.16.2 Tablespace Used Space (MB)
• 10.17 Tablespaces Full
  • 10.17.1 Tablespace Free Space (MB)
  • 10.17.2 Tablespace Space Used (%)
• 10.18 Tablespaces Full (Temp)
  • 10.18.1 Tablespace Free Space (MB) (Temp)
  • 10.18.2 Tablespace Space Used (%) (Temp)
• 10.19 Tablespaces Full (dictionary managed)
  • 10.19.1 Tablespace Free Space (MB) (dictionary managed)
  • 10.19.2 Tablespace Space Used (%) (dictionary managed)
• 10.20 Tablespaces With Problem Segments
  • 10.20.1 Segments Approaching Maximum Extents Count
  • 10.20.2 Segments Approaching Maximum Extents
  • 10.20.3 Segments Not Able to Extend
  • 10.20.4 Segments Not Able to Extend Count
• 10.21 Temporary File Status
  • 10.21.1 File Name
  • 10.21.2 Status
  • 10.21.3 Temporary File Id
• 10.22 Total Objects by Schema
  • 10.22.1 Total Object Count
• 10.23 Total Tables by Schema
  • 10.23.1 Total Table Count

11 CISCO Switch Metrics

• 11.1 CPU
  • 11.1.1 CPU Usage in the Last 5 Minutes (%)
  • 11.1.2 CPU Usage in the Last 1 Minute (%)
  • 11.1.3 CPU Usage in the Last 5 Seconds (%)
• 11.2 Fan
  • 11.2.1 Fan State
• 11.3 Memory
  • 11.3.1 Memory Pool Usage (%)
• 11.4 Network Interfaces
  • 11.4.1 Admin Status
  • 11.4.2 Incoming Discards(%)
  • 11.4.3 Incoming Errors(%)
  • 11.4.4 Incoming Traffic(%)
  • 11.4.5 Incoming Traffic (Kb/s)
  • 11.4.6 Interface Status
  • 11.4.7 OperStatus
  • 11.4.8 Outgoing Discards(%)
  • 11.4.9 Outgoing Errors(%)
  • 11.4.10 Outgoing Traffic(%)
  • 11.4.11 Outgoing Traffic(Kb/s)
• 11.5 Power Supply
  • 11.5.1 Power Supply State
  • 11.5.2 TCP Ping, Milliseconds
• 11.6 System Information
  • 11.6.1 Contact
  • 11.6.2 Host Name
  • 11.6.3 Location
  • 11.6.4 Up Since (Days)
• 11.7 Temperature
  • 11.7.1 Temperature, State
  • 11.7.2 Temperature, Value (Celsius)

12 KVM Target Metrics

• 12.1 Aggregated Target Device Status Changed
  • 12.1.1 Aggregated Target Device Status
  • 12.1.2 Aggregated Target Device Status Changed Object
• 12.2 Factory Defaults Set
  • 12.2.1 Factory Defaults Set Status
• 12.3 Fan Failure
  • 12.3.1 Fan Failure Status
• 12.4 Ping Status
  • 12.4.1 Status
  • 12.4.2 TCP Ping, Milliseconds
• 12.5 Power Supply
  • 12.5.1 Power Supply Status
• 12.6 Reboot Started
  • 12.6.1 Reboot Started Status
  • 12.6.2 User Name
• 12.7 Response
  • 12.7.1 Status
  • 12.7.2 TCP Ping, Milliseconds
• 12.8 Temperature Range
  • 12.8.1 Temperature Out Of Range Status

13 Integrated Lights Out Manager Metrics

• 13.1 Component Fault
  • 13.1.1 Fault Status
• 13.2 Fan Fault
  • 13.2.1 Fault Status
• 13.3 Fan Sensors
  • 13.3.1 Sensor Speed (RPM)
  • 13.3.2 Sensor State
• 13.4 Hard Disk Status
  • 13.4.1 Fault Status (0 - cleared, 1 - critical)
• 13.5 HCA Port State (For Alerts)
  • 13.5.1 Is Port Disabled?
  • 13.5.2 Is Port in 'polling' state?
• 13.6 ILOM Temperatures
  • 13.6.1 Inlet Ambient Temperature
  • 13.6.2 Outlet Ambient Temperature
  • 13.6.3 System Ambient Temperature
• 13.7 Memory Fault
  • 13.7.1 Fault Status
• 13.8 Processor Fault
  • 13.8.1 Fault Status
• 13.9 Sensor Alerts
  • 13.9.1 Current Sensor Description
  • 13.9.2 Current Sensor Status
  • 13.9.3 Fan Sensor Status
  • 13.9.4 Fan Sensor Status Description
  • 13.9.5 Power Supply Sensor Description
  • 13.9.6 Power Supply Sensor Status
  • 13.9.7 Temperature Sensor Description
  • 13.9.8 Temperature Sensor Status
  • 13.9.9 Voltage Sensor Description
  • 13.9.10 Voltage Sensor Status
• 13.10 Service Processor Information
  • 13.10.1 Check Physical Presence
  • 13.10.2 Host Name
  • 13.10.3 Reset to Defaults
  • 13.10.4 System Contact
  • 13.10.5 System Description
  • 13.10.6 System Identifier
  • 13.10.7 System Location
• 13.11 Temperature Sensors
  • 13.11.1 Sensor Reading (degree C)
  • 13.11.2 Sensor State
• 13.12 Voltage Sensors
  • 13.12.1 Sensor Reading (Volts)
  • 13.12.2 Sensor State

14 Infiniband Network

• 14.1 Link Type Performance
  • 14.1.1 Average Throughput
  • 14.1.2 Highest Throughput
  • 14.1.3 Link Type
  • 14.1.4 Lowest Throughput
• 14.2 Network Performance
  • 14.2.1 Total Throughput (KBPS)

15 Infiniband Switch

• 15.1 Aggregate Sensors
  • 15.1.1 Alarm Status
  • 15.1.2 Sensor Value
• 15.2 Fan Speed Sensors
  • 15.2.1 Alarm Status
  • 15.2.2 Fan Speed (revolutions per minute)
• 15.3 Fan Speed Sensor Alerts
  • 15.3.1 Alarm Status
  • 15.3.2 Fan Speed (revolutions per minute)
• 15.4 FRU Removal Alerts
  • 15.4.1 FRU Status
• 15.5 Response
  • 15.5.1 Response Status
• 15.6 Switch Gateway Port State
  • 15.6.1 10 Gb/s Ethernet Port
  • 15.6.2 State
  • 15.6.3 Received Bytes
  • 15.6.4 Received Packets
  • 15.6.5 Received Jumbo Packets
  • 15.6.6 Received Unicast Packets
  • 15.6.7 Received Broadcast Packets
  • 15.6.8 Received Buffers
  • 15.6.9 Received CRC Errors
  • 15.6.10 Received Runtime Errors
  • 15.6.11 Received Total Errors
  • 15.6.12 Transmitted Bytes
  • 15.6.13 Transmitted Packets
  • 15.6.14 Transmitted Jumbo Packets
  • 15.6.15 Transmitted Unicast Packets
  • 15.6.16 Transmitted Multicast Packets
  • 15.6.17 Transmitted Broadcast Packets
  • 15.6.18 Transmitted Total Errors
• 15.7 Switch Performance Summary
  • 15.7.1 Average link throughput (KBPS)
  • 15.7.2 Highest link throughput (KBPS)
  • 15.7.3 Lowest link throughput (KBPS)
• 15.8 Switch Port Configuration Monitor
  • 15.8.1 GUID on the other end of the link
  • 15.8.2 Name of the entity to which this port is connected
  • 15.8.3 Node GUID if the peer is a Switch port, Port GUID otherwise
  • 15.8.4 Port number of the peer port
  • 15.8.5 Type of entity to which this disconnected port was connected
  • 15.8.6 Type of the entity to which this port is connected.
• 15.9 Switch Port Errors
  • 15.9.1 Excessive buffer overruns
  • 15.9.2 Incoming VL15 packets dropped due to resource limitation
  • 15.9.3 Link integrity errors
  • 15.9.4 Link recovers
  • 15.9.5 Packets not transmitted due to constraints
  • 15.9.6 Received packets discarded due to constraints
  • 15.9.7 Received packets marked with the EBP delimiter
  • 15.9.8 Received packets with error
  • 15.9.9 Symbol errors
  • 15.9.10 Total errors
• 15.10 Switch Port Performance
  • 15.10.1 Link Throughput: bytes transmitted and received per sec (KBPS)
  • 15.10.2 Number of bytes received per sec (KBPS)
  • 15.10.3 Number of bytes transmitted per sec (KBPS)
  • 15.10.4 Number of packets received per sec
  • 15.10.5 Number of packets transmitted per sec
• 15.11 Switch Port State
  • 15.11.1 Active link width of port based on cable connectivity
  • 15.11.2 Is the link degraded?
  • 15.11.3 Link state
  • 15.11.4 Physical link state
  • 15.11.5 The active link speed (Gbps)
• 15.12 Switch Port State (For Alerts)
  • 15.12.1 Indicates that cable is present but port is disabled
  • 15.12.2 Indicates that cable is present but port is polling for peer port
• 15.13 Switch State Summary
  • 15.13.1 Number of active ports
  • 15.13.2 Number of degraded ports
  • 15.13.3 Number of ports with errors
• 15.14 Switch Temperatures
  • 15.14.1 Back of switch temperature
  • 15.14.2 Front of switch temperature
  • 15.14.3 Switch I4 chip temperature
  • 15.14.4 Switch Service Processor temperature
• 15.15 Temperature Sensors
  • 15.15.1 Alarm Status
  • 15.15.2 Temperature (degrees Celsius)
• 15.16 Voltage Sensors
  • 15.16.1 Alarm Status
  • 15.16.2 Voltage (mV)