Skip Headers
Oracle® Enterprise Manager Oracle Database and Database-Related Metric Reference Manual
10
g
Release 2 (10.2)
Part Number B25986-01
Home
Book List
Master Index
Contact Us
Next
View PDF
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 (10
g
)
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 9
i
)
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