Contents

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documents
• Conventions

How to Use This Manual

• Structure of the Oracle Database and Database-Related Metric Reference Manual
• Background Information on Metrics, Thresholds, and Alerts

1 Automatic Storage Management

• 1.1 Alert Log
  • 1.1.1 Alert Log Error Stack
  • 1.1.2 Alert Log Error Stack Trace File Name
  • 1.1.3 Alert Log Name
  • 1.1.4 Archive Hung Error Stack
  • 1.1.5 Data Block Corruption Error Stack
  • 1.1.6 Media Failure Error Stack
  • 1.1.7 Session Terminated Error Stack
• 1.2 Alert Log Error Status
  • 1.2.1 Archiver Hung Alert Log Error Status
  • 1.2.2 Data Block Corruption Alert Log Error Status
  • 1.2.3 Generic Alert Log Error Status
  • 1.2.4 Media Failure Alert Log Error Status
  • 1.2.5 Session Terminated Alert Log Error Status
• 1.3 ASM Cluster File System Metrics
  • 1.3.1 Corrupt
  • 1.3.2 Disk Group Allocated Space (GB)
  • 1.3.3 Free (GB)
  • 1.3.4 Size (GB)
  • 1.3.5 Used (GB)
  • 1.3.6 Used (%)
  • 1.3.7 Volume Name
• 1.4 ASM Cluster File System State Metrics
  • 1.4.1 ASM Cluster File System Availability
  • 1.4.2 ASM Cluster File System Available Time
  • 1.4.3 ACM Cluster File System Mount Point
  • 1.4.4 ASM Cluster File System Mount State
• 1.5 ASM Volumes Metrics
  • 1.5.1 Disk Group Allocated Space (GB)
  • 1.5.2 Mount Point
  • 1.5.3 Redundancy
  • 1.5.4 Size (GB)
  • 1.5.5 Status
  • 1.5.6 Usage
  • 1.5.7 Volume Name
• 1.6 Checker Failure
  • 1.6.1 Alert Log Name
  • 1.6.2 Checker Failure Detected
• 1.7 Cluster Disk Group Performance Metrics
  • 1.7.1 I/O Per Second
  • 1.7.2 I/O Size (MB)
  • 1.7.3 I/O Throughput
  • 1.7.4 Read Response Time (MS)
  • 1.7.5 Read Size (MB)
  • 1.7.6 Read Throughput
  • 1.7.7 Reads Per Second
  • 1.7.8 Response Time (MS)
  • 1.7.9 Write Response Time (MS)
  • 1.7.10 Write Size (MB)
  • 1.7.11 Write Throughput
  • 1.7.12 Writes Per Second
• 1.8 Cluster Disk Performance Metrics
  • 1.8.1 I/O Per Second
  • 1.8.2 I/O Size (MB)
  • 1.8.3 I/O Throughput
  • 1.8.4 Read Response Time (MS)
  • 1.8.5 Read Size (MB)
  • 1.8.6 Read Throughput
  • 1.8.7 Reads Per Second
  • 1.8.8 Response Time (MS)
  • 1.8.9 Write Response Time (MS)
  • 1.8.10 Write Size (MB)
  • 1.8.11 Write Throughput
  • 1.8.12 Writes Per Second
• 1.9 Cluster Volume Performance Metrics
  • 1.9.1 I/O Per Second
  • 1.9.2 I/O Size (MB)
  • 1.9.3 I/O Throughput
  • 1.9.4 Read Response Time (MS)
  • 1.9.5 Read Size (MB)
  • 1.9.6 Read Throughput
  • 1.9.7 Read Write Errors
  • 1.9.8 Reads Per Second
  • 1.9.9 Response Time (MS)
  • 1.9.10 Write Response Time (MS)
  • 1.9.11 Write Size (MB)
  • 1.9.12 Write Throughput
  • 1.9.13 Writes Per Second
• 1.10 Database Disk Group Usage Metric
  • 1.10.1 Total Bytes
• 1.11 Disk Group Imbalance Status Metrics
  • 1.11.1 Actual Imbalance (%)
  • 1.11.2 Actual Minimum Percent Free
  • 1.11.3 Disk Count
  • 1.11.4 Disk Group Imbalance (%) without Rebalance
  • 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.12 Disk Group Usage Metrics
  • 1.12.1 Disk Group Free (MB)
  • 1.12.2 Disk Group Usable (Free MB)
  • 1.12.3 Disk Group Usable (MB)
  • 1.12.4 Disk Group Used %
  • 1.12.5 Redundancy
  • 1.12.6 Size (MB)
  • 1.12.7 Used % of Safely Usable
• 1.13 Disk Path Metrics
  • 1.13.1 Disk Name
  • 1.13.2 Disk Path
  • 1.13.3 Group Name
• 1.14 Disk Status Metric
  • 1.14.1 Disk Mode Status
• 1.15 Failure Group Imbalance Status Metrics
  • 1.15.1 Disk Count Imbalance Variance
  • 1.15.2 Disk Size Imbalance (%)
  • 1.15.3 Failure Group Count
• 1.16 Failure Group Status Metrics
  • 1.16.1 Available Disks
  • 1.16.2 Disk Count for Alerts
  • 1.16.3 Total Disks
• 1.17 Incident Metrics
  • 1.17.1 Access Violation
  • 1.17.2 Alert Log Error Trace File
  • 1.17.3 Alert Log Name
  • 1.17.4 ASM Block Corruption
  • 1.17.5 Cluster Error
  • 1.17.6 Deadlock
  • 1.17.7 File Access Error
  • 1.17.8 Generic Incident
  • 1.17.9 Generic Internal Error
  • 1.17.10 Impact
  • 1.17.11 Incident ID
  • 1.17.12 Internal SQL Error
  • 1.17.13 Out of Memory
  • 1.17.14 Redo Log Corruption
  • 1.17.15 Session Terminated
• 1.18 Incident Status Metrics
  • 1.18.1 Access Violation Status
  • 1.18.2 ASM Block Corruption Error Status
  • 1.18.3 Cluster Error Status
  • 1.18.4 Deadlock Error Status
  • 1.18.5 File Access Error Status
  • 1.18.6 Generic Incident Status
  • 1.18.7 Generic Internal Error Status
  • 1.18.8 Internal SQL Error Status
  • 1.18.9 Out of Memory Status
  • 1.18.10 Redo Log Corruption Error Status
  • 1.18.11 Session Terminated Status
• 1.19 Instance Disk Group Performance Metrics
  • 1.19.1 I/O per Second
  • 1.19.2 I/O Size (MB)
  • 1.19.3 I/O Throughput
  • 1.19.4 Read Response Time (MS)
  • 1.19.5 Read Size (MB)
  • 1.19.6 Read Throughput
  • 1.19.7 Reads per Second
  • 1.19.8 Response Time (MS)
  • 1.19.9 Write Response Time (MS)
  • 1.19.10 Write Size (MB)
  • 1.19.11 Write Throughput
  • 1.19.12 Writes per Second
• 1.20 Instance Disk Performance Metrics
  • 1.20.1 I/O Size (MB)
  • 1.20.2 I/O Throughput
  • 1.20.3 IOPS
  • 1.20.4 Read Response Time (MS)
  • 1.20.5 Read Size (MB)
  • 1.20.6 Read Throughput
  • 1.20.7 Read Write Errors
  • 1.20.8 Reads Per Second
  • 1.20.9 Response Time (MS)
  • 1.20.10 Write Response Time (MS)
  • 1.20.11 Write Size (MB)
  • 1.20.12 Write Throughput
  • 1.20.13 Writes Per Second
• 1.21 Instance Volume Performance Metrics
  • 1.21.1 I/O Per Second
  • 1.21.2 I/O Size (MB)
  • 1.21.3 I/O Throughput
  • 1.21.4 Read Response Time (MS)
  • 1.21.5 Read Size (MB)
  • 1.21.6 Read Throughput
  • 1.21.7 Read Write Errors
  • 1.21.8 Reads Per Second
  • 1.21.9 Response Time (MS)
  • 1.21.10 Write Response Time (MS)
  • 1.21.11 Write Size (MB)
  • 1.21.12 Write Throughput
  • 1.21.13 Writes Per Second
• 1.22 Offline Disk Count Metric
  • 1.22.1 Offline Disk Count
• 1.23 Operational Error Metrics
  • 1.23.1 Alert Log Error Trace File
  • 1.23.2 Alert Log Name
  • 1.23.3 Data Block Corruption
  • 1.23.4 Generic Operational Error
  • 1.23.5 Media Failure
• 1.24 Operational Error Status Metrics
  • 1.24.1 Data Block Corruption Error Status
  • 1.24.2 Generic Operational Error Status
  • 1.24.3 Media Failure Status
• 1.25 Response Metric
  • 1.25.1 Status
• 1.26 Single Instance Disk Group Performance Metrics
  • 1.26.1 I/O Per Second
  • 1.26.2 I/O Size (MB)
  • 1.26.3 I/O Throughput
  • 1.26.4 Read Response Time (MS)
  • 1.26.5 Read Size (MB)
  • 1.26.6 Read Throughput
  • 1.26.7 Reads Per Second
  • 1.26.8 Response Time (MS)
  • 1.26.9 Write Response Time (MS)
  • 1.26.10 Write Size (MB)
  • 1.26.11 Write Throughput
  • 1.26.12 Writes Per Second

2 Cluster

• 2.1 Clusterware
  • 2.1.1 Cluster Verification Output
  • 2.1.2 Clusterware Status
  • 2.1.3 Node(s) with Clusterware Problem
• 2.2 Clusterware Alert Log
  • 2.2.1 Alert Log Name
  • 2.2.2 Clusterware Service Alert Log Error
  • 2.2.3 Node Configuration Alert Log Error
  • 2.2.4 OCR Alert Log Error
  • 2.2.5 Voting Disk Alert Log Error
• 2.3 Response
  • 2.3.1 Status

3 Cluster Database

• 3.1 Data Guard
  • 3.1.1 Data Guard Status
  • 3.1.2 Data Not Applied (logs)
  • 3.1.3 Data Not Applied (MB)
  • 3.1.4 Data Not Received (logs)
  • 3.1.5 Data Not Received (MB)
• 3.2 Data Guard Fast-Start Failover
• 3.3 Data Guard Performance
  • 3.3.1 Apply Lag (seconds)
  • 3.3.2 Estimated Failover Time (seconds)
  • 3.3.3 Redo Apply Rate (KB/second)
  • 3.3.4 Redo Generation Rate (KB/second)
  • 3.3.5 Transport Lag (seconds)
• 3.4 Data Guard Status
  • 3.4.1 Data Guard Status
• 3.5 Database Cardinality
  • 3.5.1 Open Instance Count
  • 3.5.2 Total Instance Count
• 3.6 Database Job Status
  • 3.6.1 Broken Job Count
  • 3.6.2 Failed Job Count
• 3.7 Database Wait Bottlenecks
  • 3.7.1 Active Sessions Using CPU
  • 3.7.2 Active Sessions Waiting: I/O
  • 3.7.3 Active Sessions Waiting: Other
  • 3.7.4 Average Database CPU (%)
  • 3.7.5 Host CPU Utilization (%)
  • 3.7.6 Load Average
  • 3.7.7 Maximum CPU
  • 3.7.8 Wait Time (%)
• 3.8 Deferred Transactions
  • 3.8.1 Deferred Transaction Count
  • 3.8.2 Deferred Transaction Error Count
• 3.9 Failed Logins
  • 3.9.1 Failed Login Count
• 3.10 Flash Recovery
  • 3.10.1 Flash Recovery Area
  • 3.10.2 Flashback On
  • 3.10.3 Log Mode
  • 3.10.4 Oldest Flashback Time
  • 3.10.5 Usable Flash Recovery Area (%)
• 3.11 Invalid Objects
  • 3.11.1 Total Invalid Object Count
• 3.12 Invalid Objects by Schema
  • 3.12.1 Owner's Invalid Object Count
• 3.13 Recovery
  • 3.13.1 Corrupt Data Block Count
  • 3.13.2 Missing Media File Count
• 3.14 Recovery Area
  • 3.14.1 Recovery Area Free Space (%)
• 3.15 Response
  • 3.15.1 Status
• 3.16 Segment Advisor Recommendations
  • 3.16.1 Number of recommendations
• 3.17 Session Suspended
  • 3.17.1 Session Suspended by Data Object Limitation
  • 3.17.2 Session Suspended by Quota Limitation
  • 3.17.3 Session Suspended by Rollback Segment Limitation
  • 3.17.4 Session Suspended by Tablespace Limitation
• 3.18 Snapshot Too Old
  • 3.18.1 Snapshot Too Old due to Rollback Segment Limit
  • 3.18.2 Snapshot Too Old due to Tablespace Limit
• 3.19 Streams Processes Count
  • 3.19.1 Apply Processes Having Errors
  • 3.19.2 Capture Processes Having Errors
  • 3.19.3 Number of Apply Processes
  • 3.19.4 Number of Capture Processes
  • 3.19.5 Number of Propagation Jobs
  • 3.19.6 Propagation Errors
• 3.20 Suspended Session
  • 3.20.1 Suspended Session Count
• 3.21 Tablespace Allocation
  • 3.21.1 Tablespace Allocated Space (MB)
  • 3.21.2 Tablespace Used Space (MB)
• 3.22 Tablespaces Full
  • 3.22.1 Tablespace Free Space (MB)
  • 3.22.2 Tablespace Space Used (%)
• 3.23 Tablespaces Full (dictionary managed)
  • 3.23.1 Tablespace Free Space (MB) (dictionary managed)
  • 3.23.2 Tablespace Space Used (%) (dictionary managed)
• 3.24 Tablespaces With Problem Segments
  • 3.24.1 Segments Approaching Maximum Extents
  • 3.24.2 Segments Approaching Maximum Extents Count
  • 3.24.3 Segments Not Able to Extend
  • 3.24.4 Segments Not Able to Extend Count
• 3.25 User Block
  • 3.25.1 Blocking Session Count

4 Database Instance

• 4.1 Idle Events
• 4.2 Alert Log Metrics
  • 4.2.1 Alert Log Metrics
  • 4.2.2 Alert Log Error Status Metrics
• 4.3 Archive Area Metrics
  • 4.3.1 Archive Area Used (%)
  • 4.3.2 Archive Area Used (KB)
  • 4.3.3 Free Archive Area (KB)
  • 4.3.4 Total Archive Area (KB)
• 4.4 Cluster Resource
  • 4.4.1 Resource Name
• 4.5 Collect SQL Response Time Metrics
  • 4.5.1 SQL Response Time (%)
• 4.6 Data Failure Metrics
  • 4.6.1 Alert Log Name
  • 4.6.2 Data Failure Detected
• 4.7 Data Guard Metrics
  • 4.7.1 Data Guard (10i)
  • 4.7.2 Data Guard (for 9i)
  • 4.7.3 Data Guard Failover Metrics
  • 4.7.4 Data Guard Fast-Start Failover Metrics
  • 4.7.5 Data Guard Fast-Start Failover Observer - 11g Metrics
  • 4.7.6 Data Guard Fast-Start Failover Observer Metrics
  • 4.7.7 Data Guard Performance (sperf) Metrics
  • 4.7.8 Data Guard Performance (sperf 112) Metrics
  • 4.7.9 Data Guard Performance (pperf) Metrics
  • 4.7.10 Data Guard Status Metrics
• 4.8 Database Metrics
  • 4.8.1 Database Files Metrics
  • 4.8.2 Database Job Status Metrics
  • 4.8.3 Database Limits Metrics
  • 4.8.4 Database Replay Metrics
  • 4.8.5 Database Replay Client Metrics
  • 4.8.6 Database Services Metrics
  • 4.8.7 Database Vault Metrics
  • 4.8.8 DB Managed by Single Instance
• 4.9 Deferred Transactions Metrics
  • 4.9.1 Deferred Transaction Count
  • 4.9.2 Deferred Transaction Error Count
• 4.10 Dump Area Metrics
  • 4.10.1 Dump Area Directory
  • 4.10.2 Dump Area Used (%)
  • 4.10.3 Dump Area Used (KB)
  • 4.10.4 Free Dump Area (KB)
  • 4.10.5 Total Dump Area (KB)
• 4.11 Efficiency Metrics
  • 4.11.1 Buffer Cache Hit (%)
  • 4.11.2 CPU Usage (per second)
  • 4.11.3 CPU Usage (per transaction)
  • 4.11.4 Cursor Cache Hit (%)
  • 4.11.5 Data Dictionary Hit (%)
  • 4.11.6 Database CPU Time (%)
  • 4.11.7 Library Cache Hit (%)
  • 4.11.8 Library Cache Miss (%)
  • 4.11.9 Parallel Execution Downgraded (per second)
  • 4.11.10 Parallel Execution Downgraded 25% or more (per second)
  • 4.11.11 Parallel Execution Downgraded 50% or more (per second)
  • 4.11.12 Parallel Execution Downgraded 75% or more (per second)
  • 4.11.13 Parallel Execution Downgraded to Serial (per second)
  • 4.11.14 Parallel Execution Downgraded to Serial (per transaction)
  • 4.11.15 PGA Cache Hit (%)
  • 4.11.16 Redo Log Allocation Hit (%)
  • 4.11.17 Response Time (per transaction)
  • 4.11.18 Row Cache Miss Ratio (%)
  • 4.11.19 Sorts in Memory (%)
• 4.12 Failed Logins Metrics
  • 4.12.1 Failed Login Count
• 4.13 Flash Recovery Metrics
  • 4.13.1 Flash Recovery Area
  • 4.13.2 Flash Recovery Area Size
  • 4.13.3 Flashback On
  • 4.13.4 Log Mode
  • 4.13.5 Non-Reclaimable Flash Recovery Area (%)
  • 4.13.6 Oldest Flashback Time
  • 4.13.7 Reclaimable Flash Recovery Area (%)
  • 4.13.8 Usable Flash Recovery Area (%)
• 4.14 Global Cache Statistics Metrics
  • 4.14.1 Global Cache Average Convert Time (centi-seconds)
  • 4.14.2 Global Cache Average CR Block Request Time (centi-seconds)
  • 4.14.3 Global Cache Average Current Block Request Time (centi-seconds)
  • 4.14.4 Global Cache Average Get Time (centi-seconds)
  • 4.14.5 Global Cache Blocks Corrupt
  • 4.14.6 Global Cache Blocks Lost
• 4.15 Health Check Metrics
  • 4.15.1 Instance State
  • 4.15.2 Instance Status
  • 4.15.3 Maintenance
  • 4.15.4 Mounted
  • 4.15.5 State Description
  • 4.15.6 Unavailable
  • 4.15.7 Unmounted
• 4.16 Incident Metrics
  • 4.16.1 Incident
  • 4.16.2 Incident Status
• 4.17 Interconnect Metrics
  • 4.17.1 Interconnect Metrics
  • 4.17.2 Interconnect Traffic
• 4.18 Invalid Objects Metrics
  • 4.18.1 Invalid Objects
  • 4.18.2 Invalid Objects by Schema
• 4.19 Key Profiles Metrics
  • 4.19.1 key_profiles_count
  • 4.19.2 key_profiles_enable
• 4.20 Messages Metrics
  • 4.20.1 Messages in the Buffered Queue
  • 4.20.2 Messages in the Persistent Queue
  • 4.20.3 Messages in the Persistent Queue Per Subscriber
  • 4.20.4 Messages Per Queue
  • 4.20.5 Messages Per Queue Per Subscriber
• 4.21 OCM Instrumentation
  • 4.21.1 Instrumentation Present
  • 4.21.2 Need to Instrument with OCM
  • 4.21.3 OCM Configured
• 4.22 Operational Error Metrics
  • 4.22.1 Operational Error
  • 4.22.2 Operational Error Status
• 4.23 Recovery Metrics
  • 4.23.1 Recovery
  • 4.23.2 Recovery Area
• 4.24 Response Metrics
  • 4.24.1 State
  • 4.24.2 Status
  • 4.24.3 User Logon Time (msec)
• 4.25 Segment Advisor Recommendations Metrics
  • 4.25.1 Number of recommendations
• 4.26 Session Suspended Metrics
  • 4.26.1 Session Suspended by Data Object Limitation
  • 4.26.2 Session Suspended by Quota Limitation
  • 4.26.3 Session Suspended by Rollback Segment Limitation
  • 4.26.4 Session Suspended by Tablespace Limitation
• 4.27 SGA Pool Wastage Metrics
  • 4.27.1 Java Pool Free (%)
  • 4.27.2 Large Pool Free (%)
  • 4.27.3 Shared Pool Free (%)
• 4.28 Snapshot Too Old
  • 4.28.1 Snapshot Too Old Due to Rollback Segment Limit
  • 4.28.2 Snapshot Too Old Due to Tablespace Limit
• 4.29 SQL Response Time
  • 4.29.1 Baseline SQL Response Time
  • 4.29.2 Current SQL Response Time
  • 4.29.3 SQL Response Time (%)
• 4.30 Streams Metrics
  • 4.30.1 Streams Apply Aborted
  • 4.30.2 Streams Apply Coordinator Statistics
  • 4.30.3 Streams Apply Errors
  • 4.30.4 Streams Apply Queue - Buffered
  • 4.30.5 Streams Apply Queue - Persistent
  • 4.30.6 Streams Apply Reader Statistics Metrics
  • 4.30.7 Streams Capture Aborted
  • 4.30.8 Streams Capture Message Statistics Metrics
  • 4.30.9 Streams Capture Queue Statistics Metrics
  • 4.30.10 Streams Latency and Throughput
  • 4.30.11 Streams Pool Usage Metrics
  • 4.30.12 Streams Processes Count Metrics
  • 4.30.13 Streams Processes Status Metrics
  • 4.30.14 Streams Propagation Messages State Stats
  • 4.30.15 Streams Propagation - Queue Propagation Metrics
  • 4.30.16 Streams Propagation Aborted
• 4.31 Suspended Session Metrics
  • 4.31.1 Suspended Session Count
• 4.32 System Metrics
  • 4.32.1 System Response Time Per Call
  • 4.32.2 System Sessions Waiting
• 4.33 Tablespaces Metrics
  • 4.33.1 Tablespace Allocation Metrics
  • 4.33.2 Tablespaces Full Metrics
  • 4.33.3 Tablespaces Full (Dictionary Managed) Metrics
  • 4.33.4 Tablespaces With Problem Segments Metrics
• 4.34 Throughput Metrics
  • 4.34.1 All Sessions
  • 4.34.2 Average Active Sessions
  • 4.34.3 Average Synchronous Single-Block Read Latency (ms)
  • 4.34.4 BG Checkpoints (per second)
  • 4.34.5 Branch Node Splits (per second)
  • 4.34.6 Branch Node Splits (per transaction)
  • 4.34.7 Consistent Read Blocks Created (per second)
  • 4.34.8 Consistent Read Blocks Created (per transaction)
  • 4.34.9 Consistent Read Changes (per second)
  • 4.34.10 Consistent Read Changes (per transaction)
  • 4.34.11 Consistent Read Gets (per second)
  • 4.34.12 Consistent Read Gets (per transaction)
  • 4.34.13 Consistent Read Undo Records Applied (per second)
  • 4.34.14 Consistent Read Undo Records Applied (per transaction)
  • 4.34.15 Cumulative Logons (per second)
  • 4.34.16 Cumulative Logons (per transaction)
  • 4.34.17 Database Block Changes (per second)
  • 4.34.18 Database Block Changes (per transaction)
  • 4.34.19 Database Block Gets (per second)
  • 4.34.20 Database Block Gets (per transaction)
  • 4.34.21 Database Time (centiseconds per second)
  • 4.34.22 DBWR Checkpoints (per second)
  • 4.34.23 Enqueue Deadlocks (per second)
  • 4.34.24 Enqueue Deadlocks (per transaction)
  • 4.34.25 Enqueue Requests (per second)
  • 4.34.26 Enqueue Requests (per transaction)
  • 4.34.27 Enqueue Timeout (per second)
  • 4.34.28 Enqueue Timeout (per transaction)
  • 4.34.29 Enqueue Waits (per second)
  • 4.34.30 Enqueue Waits (per transaction)
  • 4.34.31 Executes (per second)
  • 4.34.32 Executes Performed without Parses (%)
  • 4.34.33 Full Index Scans (per second)
  • 4.34.34 Full Index Scans (per transaction)
  • 4.34.35 Hard Parses (per second)
  • 4.34.36 Hard Parses (per transaction)
  • 4.34.37 I/O Megabytes (per second)
  • 4.34.38 I/O Requests (per second)
  • 4.34.39 Leaf Node Splits (per second)
  • 4.34.40 Leaf Node Splits (per transaction)
  • 4.34.41 Network Bytes (per second)
  • 4.34.42 Number of Transactions (per second)
  • 4.34.43 Open Cursors (per second)
  • 4.34.44 Open Cursors (per transaction)
  • 4.34.45 Parse Failure Count (per second)
  • 4.34.46 Parse Failure Count (per transaction)
  • 4.34.47 Physical Reads (per second)
  • 4.34.48 Physical Reads (per transaction)
  • 4.34.49 Physical Reads Direct (per second)
  • 4.34.50 Physical Reads Direct (per transaction)
  • 4.34.51 Physical Reads Direct Lobs (per second)
  • 4.34.52 Physical Reads Direct Lobs (per transaction)
  • 4.34.53 Physical Writes (per second)
  • 4.34.54 Physical Writes (per transaction)
  • 4.34.55 Physical Writes Direct (per second)
  • 4.34.56 Physical Writes Direct (per transaction)
  • 4.34.57 Physical Writes Direct Lobs (per second)
  • 4.34.58 Physical Writes Direct Lobs (per transaction)
  • 4.34.59 Recursive Calls (per second)
  • 4.34.60 Recursive Calls (per transaction)
  • 4.34.61 Redo Generated (per second)
  • 4.34.62 Redo Generated (per transaction)
  • 4.34.63 Redo Writes (per second)
  • 4.34.64 Redo Writes (per transaction)
  • 4.34.65 Rows Processed (per sort)
  • 4.34.66 Scans on Long Tables (per second)
  • 4.34.67 Scans on Long Tables (per transaction)
  • 4.34.68 Session Logical Reads (per second)
  • 4.34.69 Session Logical Reads (per transaction)
  • 4.34.70 Soft Parse (%)
  • 4.34.71 Sorts to Disk (per second)
  • 4.34.72 Sorts to Disk (per transaction)
  • 4.34.73 Total Index Scans (per second)
  • 4.34.74 Total Index Scans (per transaction)
  • 4.34.75 Total Parses (per second)
  • 4.34.76 Total Parses (per transaction)
  • 4.34.77 Total Table Scans (per second)
  • 4.34.78 Total Table Scans (per transaction)
  • 4.34.79 User Calls (%)
  • 4.34.80 User Calls (per second)
  • 4.34.81 User Calls (per transaction)
  • 4.34.82 User Commits (per second)
  • 4.34.83 User Commits (per transaction)
  • 4.34.84 User Rollback Undo Records Applied (per second)
  • 4.34.85 User Rollback Undo Records Applied (per transaction)
  • 4.34.86 User Rollbacks (per second)
  • 4.34.87 User Rollbacks (per transaction)
• 4.35 User Audit
  • 4.35.1 Audited User
  • 4.35.2 Audited User Host
  • 4.35.3 Audited User Session Count
• 4.36 User Block
  • 4.36.1 Blocking Session Count
• 4.37 User Block Chain
  • 4.37.1 Blocking Session Count
  • 4.37.2 Blocking Session DB Time
• 4.38 User Locks
  • 4.38.1 Maximum Blocked DB Time (seconds)
  • 4.38.2 Maximum Blocked Session Count
• 4.39 User-Defined SQL Metrics
  • 4.39.1 User-Defined Numeric Metric
  • 4.39.2 User-Defined String Metric
• 4.40 Wait Bottlenecks
  • 4.40.1 Active Sessions Using CPU
  • 4.40.2 Active Sessions Waiting: I/O
  • 4.40.3 Active Sessions Waiting: Other
  • 4.40.4 Average Instance CPU (%)
  • 4.40.5 Buffer busy waits (%)
  • 4.40.6 CPU Time Delta (sec)
  • 4.40.7 DB file scattered read (%)
  • 4.40.8 DB file sequential read (%)
  • 4.40.9 DB file single write (%)
  • 4.40.10 Direct path read (%)
  • 4.40.11 Direct path read (lob) (%)
  • 4.40.12 Direct path write (%)
  • 4.40.13 Direct path write (lob) (%)
  • 4.40.14 Enqueue - other (%)
  • 4.40.15 Enqueue: DML - contention (%)
  • 4.40.16 Enqueue: HW, Segment High Water Mark - contention (%)
  • 4.40.17 Enqueue: ST, Space Transaction - contention (%)
  • 4.40.18 Enqueue: TM, TX, Transaction - row lock contention (%)
  • 4.40.19 Enqueue: TX mode 4, Transaction - allocate ITL entry (%)
  • 4.40.20 Enqueue: UL: User-defined - contention (%)
  • 4.40.21 Free buffer waits (%)
  • 4.40.22 Host CPU Utilization (%)
  • 4.40.23 Latch free - other (%)
  • 4.40.24 Latch: cache buffer chains (%)
  • 4.40.25 Latch: library cache (%)
  • 4.40.26 Latch: redo copy (%)
  • 4.40.27 Latch: shared pool (%)
  • 4.40.28 Library cache load lock (%)
  • 4.40.29 Library cache lock (%)
  • 4.40.30 Library cache pin (%)
  • 4.40.31 Local write wait (%)
  • 4.40.32 Log buffer space (%)
  • 4.40.33 Log file switch (archiving needed) (%)
  • 4.40.34 Log file switch (checkpoint complete) (%)
  • 4.40.35 Log file switch completion (%)
  • 4.40.36 Log file sync (%)
  • 4.40.37 Log switch/archive (%)
  • 4.40.38 Pipe put (%)
  • 4.40.39 Row cache lock (%)
  • 4.40.40 SQL*Net break/reset to client (%)
  • 4.40.41 SQL*Net break/reset to dblink (%)
  • 4.40.42 SQL*Net message to client (%)
  • 4.40.43 SQL*Net message to dblink (%)
  • 4.40.44 SQL*Net more data from client (%)
  • 4.40.45 SQL*Net more data from dblink (%)
  • 4.40.46 SQL*Net more data to client (%)
  • 4.40.47 SQL*Net more data to dblink (%)
  • 4.40.48 Wait Time (%)
  • 4.40.49 Write complete waits (%)
• 4.41 Wait by Session Count
  • 4.41.1 Session Waiting for Event Count
• 4.42 Waits by Wait Class
  • 4.42.1 Average Users Waiting Count
  • 4.42.2 Database Time Spent Waiting (%)

5 Listener

• 5.1 General Status
• 5.2 Load
• 5.3 Response
  • 5.3.1 Response Time (msec)
  • 5.3.2 Status

6 Ultra Search

• 6.1 Response
  • 6.1.1 Status
• 6.2 Ultra Search Crawler Status
  • 6.2.1 Schedule State