Skip Headers
Oracle® Enterprise Manager Oracle Database and Database-Related Metric Reference Manual
11
g
Release 1 (11.1.0.1)
Part Number E16285-01
Home
Book List
Contact Us
Next
PDF
·
Mobi
·
ePub
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 (10
i
)
4.7.2
Data Guard (for 9
i
)
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 - 11
g
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
Scripting on this page enhances content navigation, but does not change the content in any way.