The Management Pack for Oracle Database collects the metrics listed in the table below, according to Oracle Database resource kinds.
Resource Kind |
Resource Group |
Resource Attribute |
Attribute Type |
|---|---|---|---|
Oracle Database Archive Log |
Disk |
Backup Count |
Indicates the number of times this file has been backed up. Values range from 0-15. If the file has been backed up more than 15 times, the value remains 15 |
Oracle Database Archive Log |
Performance |
Completion Time |
Time when the archiving completed |
Oracle Database Archive Log |
General |
Deleted |
Indicates whether an RMAN DELETE command has physically deleted the archived log file from disk, as well as logically removing it from the control file of the target database and from the recovery catalog (YES) or not (NO) |
Oracle Database Archive Log |
General |
Destination ID |
Original destination from which the archive log was generated |
Oracle Database Archive Log |
General |
Instance ID |
|
Oracle Database Archive Log |
General |
Name |
Archived log file name |
Oracle Database Archive Log |
General |
Record ID |
Archived log record ID |
Oracle Database Archive Log |
Disk |
Size |
Size of the archive log |
Oracle Database Archive Log |
Status |
Status |
Status of the archived log |
Oracle Database Archive Log |
General |
Thread Number |
Redo Thread Number |
Oracle Database ASM Disk |
General |
Compound Index |
A 32-bit number consisting of a disk group number in the high-order 8 bits and a disk number in the low-order 24 bits |
Oracle Database ASM Disk |
General |
Create Date |
Date and time when the disk was added to the disk group |
Oracle Database ASM Disk |
Disk |
Total Disk Capacity |
Total capacity of the disk |
Oracle Database ASM Disk |
General |
Disk Number |
Number assigned to the disk withing its group |
Oracle Database ASM Disk |
General |
Fail Group |
Name of the failure group containing the disk |
Oracle Database ASM Disk |
Disk |
Free Disk Space |
Unused capacity of the disk |
Oracle Database ASM Disk |
Details |
Group Number |
Number of the disk group containing the disk |
Oracle Database ASM Disk |
Status |
Header Status |
Per-instance status of the disk as seen by discovery |
Oracle Database ASM Disk |
General |
Instance ID |
|
Oracle Database ASM Disk |
General |
Discovery Label |
Disk label portion of the name returned by discovery |
Oracle Database ASM Disk |
General |
Library |
Name of the library that discovered the disk |
Oracle Database ASM Disk |
Status |
Mode Status |
Global status about which kinds of I/O requests are allowed to the disk |
Oracle Database ASM Disk |
General |
Mount Date |
Date and time when the disk was was first mounted by the first instance |
Oracle Database ASM Disk |
Status |
Mount Status |
Per-instance status of the disk relative to group mounts |
Oracle Database ASM Disk |
General |
Name |
Name of the disk |
Oracle Database ASM Disk |
General |
Path |
Operating system pathname portion of the name returned by discovery |
Oracle Database ASM Disk |
General |
Product |
The name of the manufacturer and the name of the product |
Oracle Database ASM Disk |
Performance |
Read |
Total number of bytes read from the disk |
Oracle Database ASM Disk |
Performance |
Read Errors |
Total number of failed I/O read requests for the disk |
Oracle Database ASM Disk |
Performance |
Read Time |
Total I/O time for read requests for the disk |
Oracle Database ASM Disk |
Disk |
Reads |
Total number of I/O read requests for the disk |
Oracle Database ASM Disk |
General |
Redundancy |
External redundancy of the disk |
Oracle Database ASM Disk |
Status |
State |
Global state of the disk with respect to the disk group |
Oracle Database ASM Disk |
General |
Universal Device ID |
Universal Device ID portion of the name returned by discovery |
Oracle Database ASM Disk |
Performance |
Bytes Written |
Total number of bytes written to the disk |
Oracle Database ASM Disk |
Performance |
Write Errors |
Total number of failed I/O write requests for the disk |
Oracle Database ASM Disk |
Performance |
Write Time |
Total I/O time for write requests for the disk |
Oracle Database ASM Disk |
Disk |
Writes |
Total number of I/O write requests for the disk |
Oracle Database ASM Disk |
Disk |
ASM Free Space |
ASM free disk space percentage |
Oracle Database Control File |
General |
Name |
|
Oracle Database Control File |
General |
Control File Size |
|
Oracle Database Database |
Activity |
Average Datafile Read Duration |
|
Oracle Database Database |
General |
Oracle Database Type |
|
Oracle Database Database |
General |
Cluster Database |
|
Oracle Database Database |
General |
Multiplexed Archive Log Files Count |
|
Oracle Database Database |
General |
Multiplexed Online Log Files Average Count |
|
Oracle Database Database |
Activity |
Connection Processes |
|
Oracle Database Database |
General |
Container ID |
|
Oracle Database Database |
General |
Controlfile Count |
|
Oracle Database Database |
General |
database_id |
|
Oracle Database Database |
General |
Database Type |
Non-CDB, CDB, or PDB |
Oracle Database Database |
Undo |
Expired Undo Extents Size |
|
Oracle Database Database |
General |
Fast Recovery Area |
|
Oracle Database Database |
Activity |
Fast Recovery Area Usage |
|
Oracle Database Database |
General |
Flashback Enabled |
|
Oracle Database Database |
General |
Global Name |
|
Oracle Database Database |
General |
Host List |
|
Oracle Database Database |
General |
Instances |
|
Oracle Database Database |
Activity |
Last RMAN Backup |
|
Oracle Database Database |
General |
Archive Log Mode |
|
Oracle Database Database |
Activity |
Long Running Jobs |
|
Oracle Database Database |
General |
Oracle Managed Files |
|
Oracle Database Database |
Activity |
Processes Usage |
|
Oracle Database Database |
Activity |
Sessions Usage |
|
Oracle Database Database |
Undo |
Undo Tablespace Size |
|
Oracle Database Database |
Undo |
Unexpired Undo Extents Size |
|
Oracle Database Database File |
General |
Autoextensible |
|
Oracle Database Database File |
Disk IO |
Average I/O Time |
|
Oracle Database Database File |
Disk IO |
Average Read Time |
|
Oracle Database Database File |
Disk IO |
Average Write Time |
|
Oracle Database Database File |
General |
Container ID |
|
Oracle Database Database File |
General |
File Name |
|
Oracle Database Database File |
Disk IO |
Max Read Time |
|
Oracle Database Database File |
General |
Max Size |
|
Oracle Database Database File |
Disk IO |
Max Write Time |
|
Oracle Database Database File |
Disk IO |
Physical Blocks Read |
|
Oracle Database Database File |
Disk IO |
Physical Blocks Written |
|
Oracle Database Database File |
Disk IO |
Physical Reads |
|
Oracle Database Database File |
Disk IO |
Physical Writes |
|
Oracle Database Database File |
Disk IO |
Read Time |
|
Oracle Database Database File |
Disk IO |
Single Blocks Read |
|
Oracle Database Database File |
General |
Size |
|
Oracle Database Database File |
Status |
Status |
|
Oracle Database Database File |
General |
Tablespace Name |
|
Oracle Database Database File |
Disk IO |
Write Time |
|
Oracle Database Event Wait Group |
Activity |
Foreground Time Waited |
|
Oracle Database Event Wait Group |
Activity |
Foreground Waits |
|
Oracle Database Event Wait Group |
General |
Instance ID |
|
Oracle Database Event Wait Group |
Activity |
Total Time Waited |
|
Oracle Database Event Wait Group |
Activity |
Total Waits |
|
Oracle Database Event Wait Group |
General |
Wait Class |
|
Oracle Database Instance |
Performance |
Active Parallel Sessions |
|
Oracle Database Instance |
Performance |
Active Serial Sessions |
|
Oracle Database Instance |
General |
Active State |
|
Oracle Database Instance |
Session |
Active User Sessions |
|
Oracle Database Instance |
Session |
Applications |
|
Oracle Database Instance |
General |
Archiver |
|
Oracle Database Instance |
Performance |
Average Active Sessions |
|
Oracle Database Instance |
Disk IO |
Average I/O Time |
The average Input/Output time of the physical storage on the disk. |
Oracle Database Instance |
Disk IO |
Average Read Time |
Average read time to the physical storage on the disk. |
Oracle Database Instance |
Performance |
Average Synchronous Single-Block Read Latency |
|
Oracle Database Instance |
Disk IO |
Average Write Time |
Average write time to the physical storage on the disk. |
Oracle Database Instance |
Activity |
Background Checkpoints |
|
Oracle Database Instance |
Performance |
Background Checkpoints |
|
Oracle Database Instance |
Performance |
Background CPU Usage |
|
Oracle Database Instance |
Performance |
Background Time |
|
Oracle Database Instance |
Session |
Background Types |
|
Oracle Database Instance |
General |
Blocked |
|
Oracle Database Instance |
Session |
Blocked by Unknown User Sessions |
|
Oracle Database Instance |
Session |
Blocked User Sessions |
|
Oracle Database Instance |
Activity |
Branch Node Splits |
|
Oracle Database Instance |
Performance |
Branch Node Splits Per Transaction |
|
Oracle Database Instance |
Performance |
Branch Node Splits |
|
Oracle Database Instance |
Performance |
Buffer Cache Hit Ratio |
|
Oracle Database Instance |
Shared Memory |
Buffer Cache Size |
|
Oracle Database Instance |
Session |
Cached User Sessions |
|
Oracle Database Instance |
Performance |
Cell Physical I/O Interconnect |
|
Oracle Database Instance |
Activity |
Consistent Read Blocks Created |
|
Oracle Database Instance |
Activity |
Consistent Read Changes |
|
Oracle Database Instance |
Performance |
Consistent Read Changes Per Transaction |
|
Oracle Database Instance |
Performance |
Consistent Read Changes |
|
Oracle Database Instance |
Activity |
Consistent Read Gets |
|
Oracle Database Instance |
Performance |
Consistent Read Gets Per Transaction |
|
Oracle Database Instance |
Performance |
Consistent Read Gets |
|
Oracle Database Instance |
Activity |
Consistent Read Undo Records Applied |
|
Oracle Database Instance |
Activity |
CPU Usage |
|
Oracle Database Instance |
Performance |
CPU Usage Per Transaction |
|
Oracle Database Instance |
Performance |
CPU Usage |
|
Oracle Database Instance |
Performance |
Consistent Read Blocks Created |
|
Oracle Database Instance |
Performance |
Consistent Read Blocks Created Per Transaction |
|
Oracle Database Instance |
Performance |
Consistent Read Undo Records Applied |
|
Oracle Database Instance |
Performance |
Consistent Read Undo Records Applied Per Transaction |
|
Oracle Database Instance |
Performance |
Current Logons Count |
|
Oracle Database Instance |
Performance |
Current Open Cursors Count |
|
Oracle Database Instance |
Performance |
Current OS Processes Load |
|
Oracle Database Instance |
Performance |
Cursor Cache Hit Ratio |
|
Oracle Database Instance |
Activity |
Data Definition Language Statements Parallelized |
|
Oracle Database Instance |
Activity |
Data Manipulation Language Statements Parallelized |
|
Oracle Database Instance |
Shared Memory |
Data Transfer Cache Size |
|
Oracle Database Instance |
Activity |
Database Block Changes |
|
Oracle Database Instance |
Activity |
Database Block Gets |
|
Oracle Database Instance |
Performance |
Database CPU Time Ratio |
|
Oracle Database Instance |
General |
Database Status |
|
Oracle Database Instance |
Performance |
Database Time |
|
Oracle Database Instance |
Performance |
Database Wait Time Ratio |
|
Oracle Database Instance |
Activity |
Database Writer Checkpoints |
|
Oracle Database Instance |
Performance |
Database Block Changes |
|
Oracle Database Instance |
Performance |
Database Block Changes Per Transaction |
|
Oracle Database Instance |
Performance |
Database Block Changes Per User Call |
|
Oracle Database Instance |
Performance |
Database Block Gets |
|
Oracle Database Instance |
Performance |
Database Block Gets Per Transaction |
|
Oracle Database Instance |
Performance |
Database Block Gets Per User Call |
|
Oracle Database Instance |
Performance |
Database Writer Checkpoints |
|
Oracle Database Instance |
Performance |
Data Definition Language Statements Parallelized |
|
Oracle Database Instance |
Activity |
Direct Read Full Index Scans |
|
Oracle Database Instance |
Disk IO |
Disk Sorts |
|
Oracle Database Instance |
Performance |
Disk Sort Per Transaction |
|
Oracle Database Instance |
Performance |
Disk Sort |
|
Oracle Database Instance |
Performance |
Data Manipulation Language Statements Parallelized |
|
Oracle Database Instance |
Activity |
Enqueue Deadlocks |
|
Oracle Database Instance |
Performance |
Enqueue Deadlocks Per Transaction |
|
Oracle Database Instance |
Performance |
Enqueue Deadlocks |
|
Oracle Database Instance |
General |
Enqueue Locks Limit |
|
Oracle Database Instance |
Activity |
Enqueue Locks Utilization |
|
Oracle Database Instance |
Activity |
Enqueue Requests |
|
Oracle Database Instance |
Performance |
Enqueue Requests Per Transaction |
|
Oracle Database Instance |
Performance |
Enqueue Requests |
|
Oracle Database Instance |
Activity |
Enqueue Timeouts |
|
Oracle Database Instance |
Performance |
Enqueue Timeouts Per Transaction |
|
Oracle Database Instance |
Performance |
Enqueue Timeouts |
|
Oracle Database Instance |
Activity |
Enqueue Waits |
|
Oracle Database Instance |
Performance |
Enqueue Waits Per Transaction |
|
Oracle Database Instance |
Performance |
Enqueue Waits |
|
Oracle Database Instance |
Performance |
Execute Without Parse Ratio |
|
Oracle Database Instance |
Activity |
Executions |
|
Oracle Database Instance |
Performance |
Executions Per Transaction |
|
Oracle Database Instance |
Performance |
Executions Per User Call |
|
Oracle Database Instance |
Performance |
Executions |
Represents the rate of SQL command executions over the sampling period. |
Oracle Database Instance |
Activity |
Failed Parse Count |
|
Oracle Database Instance |
Shared Memory |
Fixed System Global Area Size |
|
Oracle Database Instance |
Latch |
Foreground Latch Time Waited |
|
Oracle Database Instance |
Activity |
Foreground Time Waited |
|
Oracle Database Instance |
Shared Memory |
Free System Global Area Memory Available |
|
Oracle Database Instance |
Activity |
Full Index Scans |
|
Oracle Database Instance |
Performance |
Full Index Scans Per Transaction |
|
Oracle Database Instance |
Performance |
Full Index Scans |
|
Oracle Database Instance |
Performance |
Global Cache Consistent Read Block Received |
|
Oracle Database Instance |
Performance |
Global Cache Consistent Read Block Received Per Transaction |
|
Oracle Database Instance |
Performance |
Global Cache Current Block Received |
|
Oracle Database Instance |
Performance |
Global Cache Current Block Received Per Transaction |
|
Oracle Database Instance |
Performance |
Global Cache Average Consistent Read Get Time |
|
Oracle Database Instance |
Performance |
Global Cache Average Current Get Time |
|
Oracle Database Instance |
Performance |
Global Cache Blocks Corrupted |
|
Oracle Database Instance |
Performance |
Global Cache Blocks Lost |
|
Oracle Database Instance |
Activity |
Global Cache Consistent Read Blocks Received |
|
Oracle Database Instance |
Activity |
Global Cache Current Blocks Received |
|
Oracle Database Instance |
Shared Memory |
Granule Size |
|
Oracle Database Instance |
Activity |
Hard Parse Count |
|
Oracle Database Instance |
Performance |
Hard Parse Count Per Transaction |
|
Oracle Database Instance |
Performance |
Hard Parse Count |
|
Oracle Database Instance |
Performance |
Host CPU Usage |
|
Oracle Database Instance |
Performance |
Host CPU Utilization |
|
Oracle Database Instance |
General |
Host Name |
|
Oracle Database Instance |
Session |
Inactive User Sessions |
|
Oracle Database Instance |
Performance |
Total Index Scans |
|
Oracle Database Instance |
Performance |
Total Index Scans Per Transaction |
|
Oracle Database Instance |
General |
Instance ID |
|
Oracle Database Instance |
General |
Instance Name |
|
Oracle Database Instance |
General |
Instance Role |
|
Oracle Database Instance |
Performance |
I/O Requests |
|
Oracle Database Instance |
Performance |
I/O Throughput |
|
Oracle Database Instance |
Shared Memory |
Java Pool Size |
|
Oracle Database Instance |
Session |
Killed User Sessions |
|
Oracle Database Instance |
Shared Memory |
Large Pool Size |
|
Oracle Database Instance |
Activity |
Leaf Node Splits |
|
Oracle Database Instance |
Performance |
Leaf Node Splits Per Transaction |
|
Oracle Database Instance |
Performance |
Leaf Node Splits |
|
Oracle Database Instance |
Performance |
Library Cache Hit Ratio |
|
Oracle Database Instance |
Performance |
Library Cache Miss Ratio |
|
Oracle Database Instance |
Performance |
Logical Reads |
|
Oracle Database Instance |
Performance |
Logical Reads Per Transaction |
|
Oracle Database Instance |
Performance |
Logical Reads Per User Call |
|
Oracle Database Instance |
General |
Login Mode |
|
Oracle Database Instance |
Activity |
Logons |
|
Oracle Database Instance |
Performance |
Logons Per Transaction |
|
Oracle Database Instance |
Performance |
Logons |
|
Oracle Database Instance |
Activity |
Long Table Scans |
|
Oracle Database Instance |
Performance |
Long Table Scans Per Transaction |
|
Oracle Database Instance |
Performance |
Long Table Scans |
|
Oracle Database Instance |
Session |
O/S Machines |
|
Oracle Database Instance |
Disk IO |
Max Read Time |
|
Oracle Database Instance |
Disk IO |
Max Write Time |
|
Oracle Database Instance |
Shared Memory |
Maximum System Global Area Size |
|
Oracle Database Instance |
Performance |
Memory Sorts Ratio |
|
Oracle Database Instance |
Activity |
Network Data Received From Client |
|
Oracle Database Instance |
Activity |
Network Data Received From DBLink |
|
Oracle Database Instance |
Activity |
Network Data Sent to Client |
|
Oracle Database Instance |
Activity |
Network Data Sent to DBLink |
|
Oracle Database Instance |
Performance |
Network Traffic Volume |
|
Oracle Database Instance |
Session |
Non-Waiting User Sessions |
|
Oracle Database Instance |
Activity |
Open Cursors |
|
Oracle Database Instance |
Performance |
Open Cursors Per Transaction |
|
Oracle Database Instance |
Performance |
Open Cursors |
|
Oracle Database Instance |
Session |
O/S Client Users |
|
Oracle Database Instance |
General |
Parallel |
|
Oracle Database Instance |
Activity |
Parallel Execution downgraded 1 to 25 percent |
|
Oracle Database Instance |
Activity |
Parallel Execution downgraded 25 to 50 percent |
|
Oracle Database Instance |
Activity |
Parallel Execution downgraded 50 to 75 percent |
|
Oracle Database Instance |
Activity |
Parallel Execution downgraded 75 to 99 percent |
|
Oracle Database Instance |
Activity |
Parallel Execution downgraded to serial |
|
Oracle Database Instance |
Activity |
Parallel Execution Operations Not Downgraded |
|
Oracle Database Instance |
Activity |
Parallel Max Servers Utilization |
|
Oracle Database Instance |
General |
Parallel Max Servers Limit |
|
Oracle Database Instance |
Performance |
Total Parse Count |
|
Oracle Database Instance |
Performance |
Total Parse Count Per Transaction |
|
Oracle Database Instance |
Performance |
Parse Failure Count |
|
Oracle Database Instance |
Performance |
Parse Failure Count Per Transaction |
|
Oracle Database Instance |
Performance |
Program Global Area Cache Hit |
|
Oracle Database Instance |
Disk IO |
Physical Application Data Read |
Total size of all disk reads by application activity (and not other instance activity) only. |
Oracle Database Instance |
Disk IO |
Physical Application Data Written |
Total size of all disk writes by application activity (and not other instance activity) only. |
Oracle Database Instance |
Disk IO |
Physical Application Read I/O Requests |
Number of read requests for application activity (mainly buffer cache and direct load operation) which read one or more database blocks per request. This is a subset of "Cumulative Physical Read IO Requests" statistic. |
Oracle Database Instance |
Activity |
Physical Application Write I/O Requests |
Number of write requests for application activity (mainly buffer cache and direct load operation) which write one or more database blocks per request. This is a subset of "Cumulative Physical Write IO Requests" statistic. |
Oracle Database Instance |
Disk IO |
Physical Blocks Read |
|
Oracle Database Instance |
Disk IO |
Physical Blocks Written |
|
Oracle Database Instance |
Disk IO |
Physical Data Read |
Total size of disk reads by all database instance activity including application reads, backup and recovery, and other utilities. The difference between this value and "Cumulative Physical Application Data Read" gives the total read size by non-application workload. |
Oracle Database Instance |
Disk IO |
Physical Data Written |
Total size of disk writes by all database instance activity including application writes, backup and recovery, and other utilities. The difference between this value and "Cumulative Physical Application Data Written" gives the total write size by non-application workload. |
Oracle Database Instance |
Disk IO |
Physical Read I/O Requests |
Number of read requests which read one or more database blocks for all instance activity including application, backup and recovery, and other utilities. |
Oracle Database Instance |
Performance |
Physical Read I/O Requests |
|
Oracle Database Instance |
Performance |
Physical Read Rate |
|
Oracle Database Instance |
Performance |
Physical Read Total I/O Requests |
|
Oracle Database Instance |
Disk IO |
Physical Reads |
|
Oracle Database Instance |
Activity |
Physical Reads Direct |
|
Oracle Database Instance |
Activity |
Physical Reads Direct Lobs |
|
Oracle Database Instance |
Performance |
Physical Reads Direct Lobs Per Transaction |
|
Oracle Database Instance |
Performance |
Physical Reads Direct Lobs |
|
Oracle Database Instance |
Performance |
Physical Reads Direct Per Transaction |
|
Oracle Database Instance |
Performance |
Physical Reads Direct |
|
Oracle Database Instance |
Performance |
Physical Reads Per Transaction |
|
Oracle Database Instance |
Performance |
Total Physical Read Rate |
|
Oracle Database Instance |
Disk IO |
Physical Write I/O Requests |
Number of write requests which write one or more database blocks for all instance activity including application, backup and recovery, and other utilities. |
Oracle Database Instance |
Performance |
Physical Write I/O Requests |
|
Oracle Database Instance |
Performance |
Physical Write Rate |
|
Oracle Database Instance |
Performance |
Total Physical Write Rate |
|
Oracle Database Instance |
Performance |
Physical Write Total I/O Requests |
|
Oracle Database Instance |
Disk IO |
Physical Writes |
|
Oracle Database Instance |
Disk IO |
Physical Writes Direct |
|
Oracle Database Instance |
Activity |
Physical Writes Direct Lobs |
|
Oracle Database Instance |
Performance |
Physical Writes Direct Lobs Per Transaction |
|
Oracle Database Instance |
Performance |
Physical Writes Direct Lobs |
|
Oracle Database Instance |
Performance |
Physical Writes Direct Per Transaction |
|
Oracle Database Instance |
Performance |
Physical Writes Direct |
|
Oracle Database Instance |
Performance |
Physical Writes Per Transaction |
|
Oracle Database Instance |
Performance |
Parallel Statement Queuing Query Coordinator Sessions |
|
Oracle Database Instance |
Performance |
Parallel Statement Queuing Slave Sessions |
|
Oracle Database Instance |
General |
Processes Limit |
|
Oracle Database Instance |
Performance |
Process Limit |
|
Oracle Database Instance |
Activity |
Processes |
|
Oracle Database Instance |
Performance |
Parallel Execution Downgraded 1 to 25 Percent |
|
Oracle Database Instance |
Performance |
Parallel Execution Downgraded 25 to 50 Percent |
|
Oracle Database Instance |
Performance |
Parallel Execution Downgraded 50 to 75 Percent |
|
Oracle Database Instance |
Performance |
Parallel Execution Downgraded 75 to 99 Percent |
|
Oracle Database Instance |
Performance |
Parallel Execution downgraded to serial |
|
Oracle Database Instance |
Performance |
Parallel Execution Operations Not Downgraded |
|
Oracle Database Instance |
Activity |
Queries Parallelized |
|
Oracle Database Instance |
Performance |
Queries Parallelized |
|
Oracle Database Instance |
Disk IO |
Read Time |
|
Oracle Database Instance |
Activity |
Recursive Calls |
|
Oracle Database Instance |
Performance |
Recursive Calls Per Transaction |
|
Oracle Database Instance |
Performance |
Recursive Calls |
|
Oracle Database Instance |
Performance |
Redo Allocation Hit Ratio |
|
Oracle Database Instance |
Shared Memory |
Redo Buffers Size |
|
Oracle Database Instance |
Activity |
Redo Generated |
|
Oracle Database Instance |
Performance |
Redo Generated Per Transaction |
|
Oracle Database Instance |
Performance |
Redo Generated |
|
Oracle Database Instance |
Disk IO |
Redo Writes |
|
Oracle Database Instance |
Performance |
Redo Writes Per Transaction |
|
Oracle Database Instance |
Performance |
Redo Writes |
|
Oracle Database Instance |
Performance |
Response Time Per Transaction |
|
Oracle Database Instance |
Performance |
Row Cache Hit Ratio |
|
Oracle Database Instance |
Performance |
Row Cache Miss Ratio |
|
Oracle Database Instance |
Activity |
RowID Ranges Full Index Scans |
|
Oracle Database Instance |
Performance |
Rows Per Sort |
|
Oracle Database Instance |
Performance |
Run Queue Processes |
|
Oracle Database Instance |
General |
Sessions Limit |
|
Oracle Database Instance |
Performance |
Session Limit |
|
Oracle Database Instance |
Session |
Sessions |
|
Oracle Database Instance |
Shared Memory |
Shared IO Pool Size |
|
Oracle Database Instance |
Performance |
Shared Pool Free |
|
Oracle Database Instance |
Shared Memory |
Shared Pool Size |
|
Oracle Database Instance |
Activity |
Short Table Scans |
|
Oracle Database Instance |
General |
Shutdown Pending |
|
Oracle Database Instance |
Disk IO |
Single Blocks Read |
|
Oracle Database Instance |
Session |
Sniped User Sessions |
|
Oracle Database Instance |
Performance |
Soft Parse Ratio |
|
Oracle Database Instance |
Performance |
SQL Service Response Time |
|
Oracle Database Instance |
Shared Memory |
Startup Overhead in Shared Pool |
|
Oracle Database Instance |
General |
Startup Time |
|
Oracle Database Instance |
General |
Status |
|
Oracle Database Instance |
Shared Memory |
Streams Pool Size |
|
Oracle Database Instance |
Performance |
Streams Pool Usage |
|
Oracle Database Instance |
Performance |
Total Table Scans |
|
Oracle Database Instance |
Performance |
Total Table Scans Per Transaction |
|
Oracle Database Instance |
Activity |
Total Time Waited |
|
Oracle Database Instance |
Latch |
Total Foreground Latch Timeouts |
|
Oracle Database Instance |
Latch |
Total Foreground Latch Waits |
|
Oracle Database Instance |
Activity |
Total Foreground Timeouts |
|
Oracle Database Instance |
Activity |
Total Foreground Waits |
|
Oracle Database Instance |
Latch |
Total Latch Time Waited |
|
Oracle Database Instance |
Latch |
Total Latch Timeouts |
|
Oracle Database Instance |
Latch |
Total Latch Waits |
|
Oracle Database Instance |
Activity |
Total Parse Count |
|
Oracle Database Instance |
Performance |
Total Program Global Area Allocated |
|
Oracle Database Instance |
Performance |
Total Program Global Area Used by SQL Workareas |
|
Oracle Database Instance |
Performance |
Total Sorts Per User Call |
|
Oracle Database Instance |
Performance |
Total Table Scans Per User Call |
|
Oracle Database Instance |
Activity |
Total Timeouts |
|
Oracle Database Instance |
Activity |
Total Waits |
|
Oracle Database Instance |
Performance |
Transactions Per Logon |
|
Oracle Database Instance |
Session |
Unblocked User Sessions |
|
Oracle Database Instance |
Session |
Unknown Wait Time User Sessions |
|
Oracle Database Instance |
Activity |
User Calls |
|
Oracle Database Instance |
Performance |
User Calls Per Transaction |
|
Oracle Database Instance |
Performance |
User Calls |
|
Oracle Database Instance |
Performance |
User Calls Ratio |
|
Oracle Database Instance |
Activity |
User Commits |
|
Oracle Database Instance |
Performance |
User Commits |
|
Oracle Database Instance |
Performance |
User Commits Ratio |
|
Oracle Database Instance |
Performance |
User Limit |
|
Oracle Database Instance |
Activity |
User Rollback Undo Records Applied |
|
Oracle Database Instance |
Performance |
User Rollback Undo Records Applied |
|
Oracle Database Instance |
Performance |
User Rollback Undo Records Applied Per Transaction |
|
Oracle Database Instance |
Activity |
User Rollbacks |
|
Oracle Database Instance |
Performance |
User Rollbacks |
|
Oracle Database Instance |
Performance |
User Rollbacks Ratio |
|
Oracle Database Instance |
Performance |
User Transactions |
|
Oracle Database Instance |
Session |
User Types |
|
Oracle Database Instance |
General |
Version |
|
Oracle Database Instance |
Session |
Waiting User Sessions |
|
Oracle Database Instance |
Performance |
Workload Capture and Replay Status |
|
Oracle Database Instance |
Disk IO |
Write Time |
|
Oracle Database PDB |
Activity |
Physical Application Data Read |
Total size of all disk reads by application activity (and not other instance activity) only. |
Oracle Database PDB |
Activity |
Physical Writes Direct |
|
Oracle Database PDB |
Session |
Active User Sessions |
|
Oracle Database PDB |
Session |
Applications |
|
Oracle Database PDB |
Disk IO |
Average I/O Time |
The average Input/Output time of the physical storage on the disk. |
Oracle Database PDB |
Disk IO |
Average Read Time |
Average read time to the physical storage on the disk. |
Oracle Database PDB |
Disk IO |
Average Write Time |
Average write time to the physical storage on the disk. |
Oracle Database PDB |
Activity |
Background Checkpoints |
|
Oracle Database PDB |
Session |
Background Types |
|
Oracle Database PDB |
Disk |
Block Size |
|
Oracle Database PDB |
Session |
Blocked by Unknown User Sessions |
|
Oracle Database PDB |
Session |
Blocked User Sessions |
|
Oracle Database PDB |
Uncategorized |
Branch Node Splits |
|
Oracle Database PDB |
Session |
Cached User Sessions |
|
Oracle Database PDB |
Activity |
Consistent Read Blocks Created |
|
Oracle Database PDB |
Activity |
Consistent Read Changes |
|
Oracle Database PDB |
Activity |
Consistent Read Gets |
|
Oracle Database PDB |
Activity |
Consistent Read Undo Records Applied |
|
Oracle Database PDB |
General |
Container ID |
|
Oracle Database PDB |
Activity |
CPU Usage |
|
Oracle Database PDB |
Activity |
Data Definition Language Statements Parallelized |
|
Oracle Database PDB |
Activity |
Data Manipulation Language Statements Parallelized |
|
Oracle Database PDB |
Activity |
Database Block Changes |
|
Oracle Database PDB |
Activity |
Cumulative Database Block Gets |
|
Oracle Database PDB |
General |
Database ID |
|
Oracle Database PDB |
Activity |
Database Writer Checkpoints |
|
Oracle Database PDB |
Activity |
Direct Read Full Index Scans |
|
Oracle Database PDB |
Disk |
Disk Sorts |
|
Oracle Database PDB |
Activity |
Enqueue Deadlocks |
|
Oracle Database PDB |
Activity |
Enqueue Requests |
|
Oracle Database PDB |
Activity |
Enqueue Timeouts |
|
Oracle Database PDB |
Activity |
Enqueue Waits |
|
Oracle Database PDB |
Activity |
Executions |
|
Oracle Database PDB |
Activity |
Failed Parses |
|
Oracle Database PDB |
Activity |
Full Index Scans |
|
Oracle Database PDB |
Activity |
Global Cache Consistent Read Blocks Received |
|
Oracle Database PDB |
Activity |
Global Cache Current Blocks Received |
|
Oracle Database PDB |
General |
GUID |
|
Oracle Database PDB |
Activity |
Hard Parse Count |
|
Oracle Database PDB |
Session |
Inactive User Sessions |
|
Oracle Database PDB |
Session |
Killed User Sessions |
|
Oracle Database PDB |
Activity |
Cumulative Leaf Node Splits |
|
Oracle Database PDB |
Activity |
Cumulative Logons |
|
Oracle Database PDB |
Activity |
Long Table Scans |
|
Oracle Database PDB |
Session |
O/S Machines |
|
Oracle Database PDB |
Disk IO |
Max Read Time |
|
Oracle Database PDB |
Disk IO |
Max Write Time |
|
Oracle Database PDB |
Uncategorized |
Name |
|
Oracle Database PDB |
Activity |
Network Data Received From Client |
|
Oracle Database PDB |
Activity |
Network Data Received From DBLink |
|
Oracle Database PDB |
Activity |
Network Data Sent to Client |
|
Oracle Database PDB |
Activity |
Network Data Sent to DBLink |
|
Oracle Database PDB |
Session |
Non-Waiting User Sessions |
|
Oracle Database PDB |
Activity |
Open Cursors |
|
Oracle Database PDB |
General |
Open Mode |
Open mode information. Possible values: MOUNTED, READ WRITE, READ ONLY, MIGRATE |
Oracle Database PDB |
Session |
O/S Client Users |
|
Oracle Database PDB |
Activity |
Parallel Execution downgraded 1 to 25 percent |
|
Oracle Database PDB |
Activity |
Parallel Execution downgraded 25 to 50 percent |
|
Oracle Database PDB |
Activity |
Parallel Execution downgraded 50 to 75 percent |
|
Oracle Database PDB |
Activity |
Parallel Execution downgraded 75 to 99 percent |
|
Oracle Database PDB |
Activity |
Parallel Execution downgraded to serial |
|
Oracle Database PDB |
Activity |
Parallel Execution Operations Not Downgraded |
|
Oracle Database PDB |
Activity |
Physical Application Data Written |
Total size of all disk writes by application activity (and not other instance activity) only. |
Oracle Database PDB |
Disk |
Physical Application Read I/O Requests |
Number of read requests for application activity (mainly buffer cache and direct load operation) which read one or more database blocks per request. This is a subset of "Cumulative Physical Read IO Requests" statistic. |
Oracle Database PDB |
Disk |
Physical Application Write I/O Requests |
Number of write requests for application activity (mainly buffer cache and direct load operation) which write one or more database blocks per request. This is a subset of "Cumulative Physical Write IO Requests" statistic. |
Oracle Database PDB |
Disk IO |
Physical Blocks Read |
|
Oracle Database PDB |
Disk IO |
Physical Blocks Written |
|
Oracle Database PDB |
Disk |
Physical Data Read |
Total size of disk reads by all database instance activity including application reads, backup and recovery, and other utilities. The difference between this value and "Cumulative Physical Application Data Read" gives the total read size by non-application workload. |
Oracle Database PDB |
Disk |
Physical Data Written |
Total size of disk writes by all database instance activity including application writes, backup and recovery, and other utilities. The difference between this value and "Cumulative Physical Application Data Written" gives the total write size by non-application workload. |
Oracle Database PDB |
Disk |
Physical Read I/O Requests |
Number of read requests which read one or more database blocks for all instance activity including application, backup and recovery, and other utilities. |
Oracle Database PDB |
Disk IO |
Physical Reads |
|
Oracle Database PDB |
Activity |
Physical Reads Direct |
|
Oracle Database PDB |
Disk |
Physical Reads Direct Lobs |
|
Oracle Database PDB |
Disk |
Physical Write I/O Requests |
Number of write requests which write one or more database blocks for all instance activity including application, backup and recovery, and other utilities. |
Oracle Database PDB |
Disk IO |
Physical Writes |
|
Oracle Database PDB |
Disk |
Physical Writes Direct Lobs |
|
Oracle Database PDB |
Activity |
Queries Parallelized |
|
Oracle Database PDB |
Disk IO |
Read Time |
|
Oracle Database PDB |
Status |
Recovery Status |
Shows whether recovery is enabled or disabled for the PDB. Possible values: ENABLED, DISABLED |
Oracle Database PDB |
Activity |
Recursive Calls |
|
Oracle Database PDB |
Activity |
Redo Generated |
|
Oracle Database PDB |
Activity |
Redo Writes |
|
Oracle Database PDB |
General |
Restricted |
Indicates whether only users possessing RESTRICTED SESSION privilege can connect to the PDB. |
Oracle Database PDB |
Activity |
Row ID Ranges Full Index Scans |
|
Oracle Database PDB |
Session |
Sessions Count |
|
Oracle Database PDB |
Activity |
Short Table Scans |
|
Oracle Database PDB |
Disk IO |
Single Blocks Read |
|
Oracle Database PDB |
General |
Snapshot Parent Container ID |
This column shows the container ID of the primary PDB that this PDB is a snapshot clone of. This column shows a non-zero value only if the PDB is a snapshot clone. For all other cases, it shows a value of 0. |
Oracle Database PDB |
Session |
Sniped User Sessions |
|
Oracle Database PDB |
Activity |
Total Parse Count |
|
Oracle Database PDB |
Session |
Unblocked User Sessions |
|
Oracle Database PDB |
Session |
Unknown Wait Time User Sessions |
|
Oracle Database PDB |
Disk |
Used Space |
Disk space used by the container, including both data and temp files. |
Oracle Database PDB |
Activity |
User Calls |
|
Oracle Database PDB |
Activity |
User Commits |
|
Oracle Database PDB |
Activity |
User Rollback Undo Records Applied |
|
Oracle Database PDB |
Activity |
User Rollbacks |
|
Oracle Database PDB |
Session |
User Types |
|
Oracle Database PDB |
Session |
Waiting User Sessions |
|
Oracle Database PDB |
Disk IO |
Write Time |
|
Oracle Database Query |
Activity |
Application Wait Time |
|
Oracle Database Query |
Activity |
Average Time |
|
Oracle Database Query |
Activity |
Buffer Gets |
|
Oracle Database Query |
Activity |
Child Count |
|
Oracle Database Query |
Activity |
Concurrency Wait Time |
|
Oracle Database Query |
Activity |
CPU Time |
|
Oracle Database Query |
Activity |
Direct Writes |
|
Oracle Database Query |
Activity |
Disk Reads |
|
Oracle Database Query |
Activity |
Elapsed Time |
|
Oracle Database Query |
Activity |
Executions |
|
Oracle Database Query |
General |
Instance ID |
|
Oracle Database Query |
Activity |
I/O Interconnect Data |
|
Oracle Database Query |
Activity |
Last Active Time |
|
Oracle Database Query |
Activity |
Last Load Time |
|
Oracle Database Query |
Activity |
Name |
|
Oracle Database Query |
Activity |
Optimized Physical Read Requests |
|
Oracle Database Query |
Activity |
Parallel Server Executions |
|
Oracle Database Query |
Activity |
Parse Calls |
|
Oracle Database Query |
Activity |
Physical Read Data |
|
Oracle Database Query |
Activity |
Physical Read Requests |
|
Oracle Database Query |
Activity |
Physical Write Data |
|
Oracle Database Query |
Activity |
Physical Write Requests |
|
Oracle Database Query |
General |
Rank |
|
Oracle Database Query |
Activity |
Rows Processed |
|
Oracle Database Query |
Activity |
Runtime Memory Used |
|
Oracle Database Query |
General |
Shareable Memory |
|
Oracle Database Query |
General |
SQL ID |
|
Oracle Database Query |
Activity |
SQL Text |
|
Oracle Database Query |
Activity |
Total Locks |
|
Oracle Database Query |
Activity |
Total Pins |
|
Oracle Database Query |
Activity |
User I/O Wait Time |
|
Oracle Database Query |
Activity |
Users Executing |
|
Oracle Database Redo Log File |
Status |
Status Extended |
|
Oracle Database Redo Log File |
General |
Group Number |
|
Oracle Database Redo Log File |
General |
Member Name |
|
Oracle Database Redo Log File |
General |
Sequence Number |
|
Oracle Database Redo Log File |
General |
Size |
|
Oracle Database Redo Log File |
Status |
Status |
|
Oracle Database Redo Log File |
General |
Thread Number |
|
Oracle Database Service |
Performance |
Application Wait Time |
The total wait time for waits that belong to the Application wait class |
Oracle Database Service |
Performance |
Cluster Wait Time |
The total wait time for waits that belong to the Cluster wait class |
Oracle Database Service |
Memory |
Multipass Work Area Executions |
Total number of times the work area size was too small |
Oracle Database Service |
Performance |
Concurrency Wait Time |
The total wait time for waits that belong to the Concurrency wait class |
Oracle Database Service |
Disk |
Database Block Changes |
Total number of changes that were part of an update or delete operation that were made to all blocks in the SGA. |
Oracle Database Service |
Performance |
Executions |
Total number of calls (user and recursive) that executed SQL statements |
Oracle Database Service |
Disk |
Global Cache Consistent Real Blocks Received |
Total number of blocks received |
Oracle Database Service |
Disk |
Global Cache Consistent Real Block Receive Time |
The total time required for consistent read requests to complete |
Oracle Database Service |
Disk |
Global Cache Current Block Receive Time |
Total time required for consistent read requests to complete |
Oracle Database Service |
Disk |
Global Cache Current Blocks Received |
Number of current blocks received from the holding instance over the hardware interconnect. |
Oracle Database Service |
Details |
Logons |
Total number of logons since the instance started |
Oracle Database Service |
Memory |
One Pass Work Area Executions |
Total number of times the work area size was oversize |
Oracle Database Service |
Memory |
Optimal Work Area Executions |
Total number of times the work area size was optimal |
Oracle Database Service |
Disk |
Physical Reads |
Total number of data blocks read from disk |
Oracle Database Service |
Disk |
Physical Writes |
Total number of data blocks written to disk |
Oracle Database Service |
Redo |
Redo Size |
Total amount of redo generated in bytes |
Oracle Database Service |
General |
Name |
|
Oracle Database Service |
Disk |
Session Logical Reads |
The sum of "db block gets" plus "consistent gets". This includes logical reads of database blocks from either the buffer cache or process private memory. |
Oracle Database Service |
Performance |
SQL Execute Elapsed Time |
The amount of elapsed time SQL statements are executing |
Oracle Database Service |
Performance |
User Calls |
Number of user calls such as login, parse, fetch, or execute |
Oracle Database Service |
Redo |
User Commits |
Number of user commits |
Oracle Database Service |
Performance |
User IO Wait Time |
The total wait time for waits that belong to the User I/O wait class |
Oracle Database Service |
Redo |
User Rollbacks |
Number of times users manually issue the ROLLBACK statement or an error occurs during a user's transactions |
Oracle Database Tablespace |
General |
Allocated Capacity Utilization |
The percentage of the allocated capacity that is currently used |
Oracle Database Tablespace |
General |
Allocated Size |
Current size of the file |
Oracle Database Tablespace |
General |
Capacity Utilization |
The percentage of the maximum capacity that is currently used |
Oracle Database Tablespace |
General |
Container ID |
|
Oracle Database Tablespace |
General |
Contents |
|
Oracle Database Tablespace |
General |
Free Allocated Space |
Amount of currently allocated space that is unused |
Oracle Database Tablespace |
General |
Free Space |
Unused space left for user data. This will include as-yet unallocated space. |
Oracle Database Tablespace |
Uncategorized |
Global Name |
|
Oracle Database Tablespace |
General |
Maximum Space |
Maximum size to which the file can grow |
Oracle Database Tablespace |
Status |
Status |
|
Oracle Database Tablespace |
General |
Tablespace Name |
|
Oracle Database Tablespace |
General |
Used Space |
Amount of space that is currently in use |
