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 Content
• • 1.2.1 Content
• 1.3 Alert Log Error Status
• • 1.3.1 Archiver Hung Alert Log Error Status
  • 1.3.2 Data Block Corruption Alert Log Error Status
  • 1.3.3 Generic Alert Log Error Status
  • 1.3.4 Media Failure Alert Log Error Status
  • 1.3.5 Session Terminated Alert Log Error Status
• 1.4 Cluster Disk Group Performance
• • 1.4.1 I/O per second
  • 1.4.2 IO Throughput
  • 1.4.3 Read Response Time
  • 1.4.4 Read Throughput
  • 1.4.5 Reads per second
  • 1.4.6 Response Time
  • 1.4.7 Write Response Time
  • 1.4.8 Write Throughput
  • 1.4.9 Writes per second
• 1.5 Cluster Disk Performance
• • 1.5.1 I/O per second
  • 1.5.2 IO Throughput
  • 1.5.3 Read Response Time
  • 1.5.4 Read Throughput
  • 1.5.5 Read Write Errors
  • 1.5.6 Reads per second
  • 1.5.7 Response Time
  • 1.5.8 Write Response Time
  • 1.5.9 Write Throughput
  • 1.5.10 Writes per second
• 1.6 Database Disk Group Usage
• • 1.6.1 Total Bytes
• 1.7 Disk Group Usage
• • 1.7.1 Free MB
  • 1.7.2 Total MB
  • 1.7.3 Total Safely Usable MB
  • 1.7.4 Type
  • 1.7.5 Usable Free MB
  • 1.7.6 Used %
  • 1.7.7 Used % of Safely Usable
• 1.8 Disk Path
• 1.9 Disk Status
• • 1.9.1 Disk Mode Status
• 1.10 Instance Disk Group Performance
• • 1.10.1 I/O per second
  • 1.10.2 IO Throughput
  • 1.10.3 Read Response Time
  • 1.10.4 Read Throughput
  • 1.10.5 Reads per second
  • 1.10.6 Response Time
  • 1.10.7 Write Response Time
  • 1.10.8 Write Throughput
  • 1.10.9 Writes per second
• 1.11 Instance Disk Performance
• • 1.11.1 IO Throughput
  • 1.11.2 IOPS
  • 1.11.3 Read Response Time
  • 1.11.4 Read Throughput
  • 1.11.5 Read Write Errors
  • 1.11.6 Reads
  • 1.11.7 Response Time
  • 1.11.8 Write Response Time
  • 1.11.9 Write Throughput
  • 1.11.10 Writes
• 1.12 Offline Disk Count
• • 1.12.1 Offline Disk Count
• 1.13 Response
• • 1.13.1 Status
• 1.14 Single Instance Disk Group Performance
• • 1.14.1 I/O per second
  • 1.14.2 IO Throughput
  • 1.14.3 Read Response Time
  • 1.14.4 Read Throughput
  • 1.14.5 Reads per second
  • 1.14.6 Response Time
  • 1.14.7 Write Response Time
  • 1.14.8 Write Throughput
  • 1.14.9 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 Alert Log
• • 4.1.1 Alert Log Error Trace File
  • 4.1.2 Alert Log Name
  • 4.1.3 Archiver Hung Alert Log Error
  • 4.1.4 Data Block Corruption Alert Log Error
  • 4.1.5 Generic Alert Log Error
  • 4.1.6 Media Failure Alert Log Error
  • 4.1.7 Session Terminated Alert Log Error
• 4.2 Alert Log Error Status
• • 4.2.1 Archiver Hung Alert Log Error Status
  • 4.2.2 Data Block Corruption Alert Log Error Status
  • 4.2.3 Generic Alert Log Error Status
  • 4.2.4 Media Failure Alert Log Error Status
  • 4.2.5 Session Terminated Alert Log Error Status
• 4.3 Archive Area
• • 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 Collect SQL Response Time
• • 4.4.1 SQL Response Time (%)
• 4.5 Data Guard (10g)
• • 4.5.1 Data Guard Status
  • 4.5.2 Data Not Applied (logs)
  • 4.5.3 Data Not Applied (MB)
  • 4.5.4 Data Not Received (logs)
  • 4.5.5 Data Not Received (MB)
• 4.6 Data Guard (for 9i)
• • 4.6.1 Data Guard Status
  • 4.6.2 Data Not Applied (logs)
  • 4.6.3 Data Not Received (logs)
• 4.7 Data Guard Fast-Start Failover
• • 4.7.1 Fast-Start Failover Occurred
  • 4.7.2 Fast-Start Failover SCN
  • 4.7.3 Fast-Start Failover Time
• 4.8 Data Guard Performance
• • 4.8.1 Apply Lag (seconds)
  • 4.8.2 Estimated Failover Time (seconds)
  • 4.8.3 Redo Apply Rate (KB/second)
  • 4.8.4 Transport Lag (seconds)
• 4.9 Data Guard Status
• • 4.9.1 Data Guard Status
• 4.10 Database Files
• • 4.10.1 Average File Read Time (centi-seconds)
  • 4.10.2 Average File Write Time (centi-seconds)
• 4.11 Database Job Status
• • 4.11.1 Broken Job Count
  • 4.11.2 Failed Job Count
• 4.12 Database Limits
• • 4.12.1 Current Logons Count
  • 4.12.2 Current Open Cursors Count
  • 4.12.3 Lock Limit Usage (%)
  • 4.12.4 Process Limit Usage (%)
  • 4.12.5 Session Limit Usage (%)
  • 4.12.6 User Limit Usage (%)
• 4.13 Database Services
• • 4.13.1 Service CPU Time (per user call) (microseconds)
  • 4.13.2 Service Response Time (per user call) (microseconds)
• 4.14 Deferred Transactions
• • 4.14.1 Deferred Transaction Count
  • 4.14.2 Deferred Transaction Error Count
• 4.15 Dump Area
• • 4.15.1 Dump Area Directory
  • 4.15.2 Dump Area Used (%)
  • 4.15.3 Dump Area Used (KB)
  • 4.15.4 Free Dump Area (KB)
  • 4.15.5 Total Dump Area (KB)
• 4.16 Efficiency
• • 4.16.1 Buffer Cache Hit (%)
  • 4.16.2 CPU Usage (per second)
  • 4.16.3 CPU Usage (per transaction)
  • 4.16.4 Cursor Cache Hit (%)
  • 4.16.5 Data Dictionary Hit (%)
  • 4.16.6 Database CPU Time (%)
  • 4.16.7 Library Cache Hit (%)
  • 4.16.8 Library Cache Miss (%)
  • 4.16.9 Parallel Execution Downgraded (per second)
  • 4.16.10 Parallel Execution Downgraded 25% or more (per second)
  • 4.16.11 Parallel Execution Downgraded 50% or more (per second)
  • 4.16.12 Parallel Execution Downgraded 75% or more (per second)
  • 4.16.13 Parallel Execution Downgraded to Serial (per second)
  • 4.16.14 Parallel Execution Downgraded to Serial (per transaction)
  • 4.16.15 PGA Cache Hit (%)
  • 4.16.16 Redo Log Allocation Hit (%)
  • 4.16.17 Response Time (per transaction)
  • 4.16.18 Row Cache Miss Ratio (%)
  • 4.16.19 Sorts in Memory (%)
• 4.17 Failed Logins
• • 4.17.1 Failed Login Count
• 4.18 Flash Recovery
• • 4.18.1 Flash Recovery Area
  • 4.18.2 Flashback On
  • 4.18.3 Log Mode
  • 4.18.4 Oldest Flashback Time
  • 4.18.5 Usable Flash Recovery Area (%)
• 4.19 Global Cache Statistics
• • 4.19.1 Global Cache Average Convert Time (centi-seconds)
  • 4.19.2 Global Cache Average CR Block Request Time (centi-seconds)
  • 4.19.3 Global Cache Average Current Block Request Time (centi-seconds)
  • 4.19.4 Global Cache Average Get Time (centi-seconds)
  • 4.19.5 Global Cache Blocks Corrupt
  • 4.19.6 Global Cache Blocks Lost
• 4.20 Health Check
• • 4.20.1 Maintenance
  • 4.20.2 Mounted
  • 4.20.3 State
  • 4.20.4 State Description
  • 4.20.5 Status
  • 4.20.6 Unavailable
  • 4.20.7 Unmounted
• 4.21 Idle Events
• 4.22 Interconnect
• • 4.22.1 Interface Type
• 4.23 Interconnect Traffic
• • 4.23.1 Transfer Rate (MB/s)
• 4.24 Invalid Objects
• • 4.24.1 Total Invalid Object Count
• 4.25 Invalid Objects by Schema
• • 4.25.1 Owner's Invalid Object Count
• 4.26 Recovery
• • 4.26.1 Corrupt Data Blocks
  • 4.26.2 Missing Media Files
• 4.27 Recovery Area
• • 4.27.1 Recovery Area Free Space (%)
• 4.28 Response
• • 4.28.1 State
  • 4.28.2 Status
  • 4.28.3 User Logon Time (msec)
• 4.29 Segment Advisor Recommendations
• • 4.29.1 Number of recommendations
• 4.30 Session Suspended
• • 4.30.1 Session Suspended by Data Object Limitation
  • 4.30.2 Session Suspended by Quota Limitation
  • 4.30.3 Session Suspended by Rollback Segment Limitation
  • 4.30.4 Session Suspended by Tablespace Limitation
• 4.31 SGA Pool Wastage
• • 4.31.1 Java Pool Free (%)
  • 4.31.2 Large Pool Free (%)
  • 4.31.3 Shared Pool Free (%)
• 4.32 Snapshot Too Old
• • 4.32.1 Snapshot Too Old due to Rollback Segment Limit
  • 4.32.2 Snapshot Too Old due to Tablespace Limit
• 4.33 SQL Response Time
• • 4.33.1 Baseline SQL Response Time
  • 4.33.2 Current SQL Response Time
  • 4.33.3 SQL Response Time (%)
• 4.34 Streams Apply Coordinator Statistics
• • 4.34.1 Number of Transactions Assigned
  • 4.34.2 Total number of Transactions applied
  • 4.34.3 Total Number of Transactions Received
• 4.35 Streams Apply Queue - Buffered
• • 4.35.1 Number of Outstanding Messages
  • 4.35.2 Number of Overflow Messages
• 4.36 Streams Apply Queue - Persistent
• • 4.36.1 Ready
  • 4.36.2 Waiting
• 4.37 Streams Apply Reader Statistics
• • 4.37.1 Total number of Messages Dequeued
• 4.38 Streams Capture Message Statistics
• • 4.38.1 Total Messages Captured
  • 4.38.2 Total Messages Enqueued
• 4.39 Streams Capture Queue Statistics
• • 4.39.1 Number of Messages
  • 4.39.2 Number of Spilled Messages
• 4.40 Streams Processes Count
• • 4.40.1 Apply Processes Having Errors
  • 4.40.2 Capture Processes Having Errors
  • 4.40.3 Number of Apply Processes
  • 4.40.4 Number of Capture Processes
  • 4.40.5 Number of Propagation Jobs
  • 4.40.6 Propagation Errors
• 4.41 Streams Propagation - Buffered Queue Propagation
• • 4.41.1 Total Number of KBytes Propagated
  • 4.41.2 Total Number of Messages Propagated
• 4.42 Streams Propagation - Buffered Queue State
• • 4.42.1 Messages in Ready State
• 4.43 Streams Propagation - Persistent Queue Propagation
• • 4.43.1 Total Number of KBytes Propagated
  • 4.43.2 Total Number of Messages Propagated
• 4.44 Streams Propagation - Persistent Queue State
• • 4.44.1 Messages in Ready State
  • 4.44.2 Messages in Waiting State
• 4.45 Suspended Session
• • 4.45.1 Suspended Session Count
• 4.46 System Response Time Per Call
• • 4.46.1 System Response Time (centi-seconds)
• 4.47 System Sessions Waiting
• • 4.47.1 Waiting Session Count
• 4.48 Tablespace Allocation
• • 4.48.1 Tablespace Allocated Space (MB)
  • 4.48.2 Tablespace Used Space (MB)
• 4.49 Tablespaces Full
• • 4.49.1 Tablespace Free Space (MB)
  • 4.49.2 Tablespace Space Used (%)
• 4.50 Tablespaces Full (dictionary managed)
• • 4.50.1 Tablespace Free Space (MB) (dictionary managed)
  • 4.50.2 Tablespace Space Used (%) (dictionary managed)
• 4.51 Tablespaces With Problem Segments
• • 4.51.1 Segments Approaching Maximum Extents
  • 4.51.2 Segments Approaching Maximum Extents Count
  • 4.51.3 Segments Not Able to Extend
  • 4.51.4 Segments Not Able to Extend Count
• 4.52 Throughput
• • 4.52.1 All Sessions
  • 4.52.2 BG Checkpoints (per second)
  • 4.52.3 Branch Node Splits (per second)
  • 4.52.4 Branch Node Splits (per transaction)
  • 4.52.5 Consistent Read Blocks Created (per second)
  • 4.52.6 Consistent Read Blocks Created (per transaction)
  • 4.52.7 Consistent Read Changes (per second)
  • 4.52.8 Consistent Read Changes (per transaction)
  • 4.52.9 Consistent Read Gets (per second)
  • 4.52.10 Consistent Read Gets (per transaction)
  • 4.52.11 Consistent Read Undo Records Applied (per second)
  • 4.52.12 Consistent Read Undo Records Applied (per transaction)
  • 4.52.13 Cumulative Logons (per second)
  • 4.52.14 Cumulative Logons (per transaction)
  • 4.52.15 Database Block Changes (per second)
  • 4.52.16 Database Block Changes (per transaction)
  • 4.52.17 Database Block Gets (per second)
  • 4.52.18 Database Block Gets (per transaction)
  • 4.52.19 DBWR Checkpoints (per second)
  • 4.52.20 Enqueue Deadlocks (per second)
  • 4.52.21 Enqueue Deadlocks (per transaction)
  • 4.52.22 Enqueue Requests (per second)
  • 4.52.23 Enqueue Requests (per transaction)
  • 4.52.24 Enqueue Timeout (per second)
  • 4.52.25 Enqueue Timeout (per transaction)
  • 4.52.26 Enqueue Waits (per second)
  • 4.52.27 Enqueue Waits (per transaction)
  • 4.52.28 Executes (per second)
  • 4.52.29 Executes Performed without Parses (%)
  • 4.52.30 Full Index Scans (per second)
  • 4.52.31 Full Index Scans (per transaction)
  • 4.52.32 Hard Parses (per second)
  • 4.52.33 Hard Parses (per transaction)
  • 4.52.34 Leaf Node Splits (per second)
  • 4.52.35 Leaf Node Splits (per transaction)
  • 4.52.36 Network Bytes (per second)
  • 4.52.37 Number of Transactions (per second)
  • 4.52.38 Open Cursors (per second)
  • 4.52.39 Open Cursors (per transaction)
  • 4.52.40 Parse Failure Count (per second)
  • 4.52.41 Parse Failure Count (per transaction)
  • 4.52.42 Physical Reads (per second)
  • 4.52.43 Physical Reads (per transaction)
  • 4.52.44 Physical Reads Direct (per second)
  • 4.52.45 Physical Reads Direct (per transaction)
  • 4.52.46 Physical Reads Direct Lobs (per second)
  • 4.52.47 Physical Reads Direct Lobs (per transaction)
  • 4.52.48 Physical Writes (per second)
  • 4.52.49 Physical Writes (per transaction)
  • 4.52.50 Physical Writes Direct (per second)
  • 4.52.51 Physical Writes Direct (per transaction)
  • 4.52.52 Physical Writes Direct Lobs (per second)
  • 4.52.53 Physical Writes Direct Lobs (per transaction)
  • 4.52.54 Recursive Calls (per second)
  • 4.52.55 Recursive Calls (per transaction)
  • 4.52.56 Redo Generated (per second)
  • 4.52.57 Redo Generated (per transaction)
  • 4.52.58 Redo Writes (per second)
  • 4.52.59 Redo Writes (per transaction)
  • 4.52.60 Rows Processed (per sort)
  • 4.52.61 Scans on Long Tables (per second)
  • 4.52.62 Scans on Long Tables (per transaction)
  • 4.52.63 Session Logical Reads (per second)
  • 4.52.64 Session Logical Reads (per transaction)
  • 4.52.65 Soft Parse (%)
  • 4.52.66 Sorts to Disk (per second)
  • 4.52.67 Sorts to Disk (per transaction)
  • 4.52.68 Total Index Scans (per second)
  • 4.52.69 Total Index Scans (per transaction)
  • 4.52.70 Total Parses (per second)
  • 4.52.71 Total Parses (per transaction)
  • 4.52.72 User Calls (%)
  • 4.52.73 User Calls (per second)
  • 4.52.74 User Calls (per transaction)
  • 4.52.75 User Commits (per second)
  • 4.52.76 User Commits (per transaction)
  • 4.52.77 User Rollback Undo Records Applied (per second)
  • 4.52.78 User Rollback Undo Records Applied (per transaction)
  • 4.52.79 User Rollbacks (per second)
  • 4.52.80 User Rollbacks (per transaction)
• 4.53 User Audit
• • 4.53.1 Audited User
  • 4.53.2 Audited User Host
  • 4.53.3 Audited User Session Count
• 4.54 User Block
• • 4.54.1 Blocking Session Count
• 4.55 User-Defined SQL Metrics
• • 4.55.1 User-Defined Numeric Metric
  • 4.55.2 User-Defined String Metric
• 4.56 Wait Bottlenecks
• • 4.56.1 Active Sessions Using CPU
  • 4.56.2 Active Sessions Waiting: I/O
  • 4.56.3 Active Sessions Waiting: Other
  • 4.56.4 Average Instance CPU (%)
  • 4.56.5 Buffer busy waits (%)
  • 4.56.6 CPU Time Delta (sec)
  • 4.56.7 DB file scattered read (%)
  • 4.56.8 DB file sequential read (%)
  • 4.56.9 DB file single write (%)
  • 4.56.10 Direct path read (%)
  • 4.56.11 Direct path read (lob) (%)
  • 4.56.12 Direct path write (%)
  • 4.56.13 Direct path write (lob) (%)
  • 4.56.14 Enqueue - other (%)
  • 4.56.15 Enqueue: DML - contention (%)
  • 4.56.16 Enqueue: HW, Segment High Water Mark - contention (%)
  • 4.56.17 Enqueue: ST, Space Transaction - contention (%)
  • 4.56.18 Enqueue: TM, TX, Transaction - row lock contention (%)
  • 4.56.19 Enqueue: TX mode 4, Transaction - allocate ITL entry (%)
  • 4.56.20 Enqueue: UL: User-defined - contention (%)
  • 4.56.21 Free buffer waits (%)
  • 4.56.22 Host CPU Utilization (%)
  • 4.56.23 Latch free - other (%)
  • 4.56.24 Latch: cache buffer chains (%)
  • 4.56.25 Latch: library cache (%)
  • 4.56.26 Latch: redo copy (%)
  • 4.56.27 Latch: shared pool (%)
  • 4.56.28 Library cache load lock (%)
  • 4.56.29 Library cache lock (%)
  • 4.56.30 Library cache pin (%)
  • 4.56.31 Local write wait (%)
  • 4.56.32 Log buffer space (%)
  • 4.56.33 Log file switch (archiving needed) (%)
  • 4.56.34 Log file switch (checkpoint complete) (%)
  • 4.56.35 Log file switch completion (%)
  • 4.56.36 Log file sync (%)
  • 4.56.37 Log switch/archive (%)
  • 4.56.38 Pipe put (%)
  • 4.56.39 Row cache lock (%)
  • 4.56.40 SQL*Net break/reset to client (%)
  • 4.56.41 SQL*Net break/reset to dblink (%)
  • 4.56.42 SQL*Net message to client (%)
  • 4.56.43 SQL*Net message to dblink (%)
  • 4.56.44 SQL*Net more data from client (%)
  • 4.56.45 SQL*Net more data from dblink (%)
  • 4.56.46 SQL*Net more data to client (%)
  • 4.56.47 SQL*Net more data to dblink (%)
  • 4.56.48 Wait Time (%)
  • 4.56.49 Write complete waits (%)
• 4.57 Wait by Session Count
• • 4.57.1 Session Waiting for Event Count
• 4.58 Waits by Wait Class
• • 4.58.1 Average Users Waiting Count
  • 4.58.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