The Management Pack for Oracle Database collects the metrics listed in the table below, according to Oracle Database resource kinds.

Download metrics list as .csv file

Resource Kind Resource Group Resource Attribute Attribute Type
Oracle DB Database General Host List string
Oracle DB Database General Archive Log Mode string
Oracle DB Database General Oracle DB Type string
Oracle DB Database General OMF Configured string
Oracle DB Database General Fast Recovery Area Configured string
Oracle DB Database General Archive Log Files Count integer
Oracle DB Database General Online Log Files Average Count integer
Oracle DB Database General Controlfile Count integer
Oracle DB Database General Flashback Enabled string
Oracle DB Database Undo Expired Undo Extents Size integer
Oracle DB Database Undo Undo Tablespace Size integer
Oracle DB Database Undo Unexpired Undo Extents Size integer
Oracle DB Database Health And Configuration Archive Logging Enabled Score integer
Oracle DB Database Health And Configuration Flashback Enabled Score integer
Oracle DB Database Health And Configuration Multiplexed Controlfile Score integer
Oracle DB Database Health And Configuration Multiplexed Online Log Files Score integer
Oracle DB Database Health And Configuration Multiplexed Archive Log Files Score integer
Oracle DB Database Health And Configuration Fast Recovery Area Configured Score integer
Oracle DB Database Health And Configuration OMF Configured Score integer
Oracle DB Database Health And Configuration Fast Recovery Area Usage Score integer
Oracle DB Database Health And Configuration Processes Limit Score integer
Oracle DB Database Health And Configuration Sessions Limit Score integer
Oracle DB Database Health And Configuration RMAN Backup Frequency Score integer
Oracle DB Database Health And Configuration Average Datafile Read Time Score integer
Oracle DB Database Health And Configuration Overall Health & Config Score integer
Oracle DB Database Activity Average Datafile Read Time integer
Oracle DB Database Activity Days Since Last RMAN Backup integer
Oracle DB Database Activity Session Usage integer
Oracle DB Database Activity Process Usage integer
Oracle DB Database Activity Fast Recovery Area Usage integer
Oracle DB Database Control File|General Control File Size integer
Oracle DB Database Redo Log File|Status Status Extended string
Oracle DB Database Redo Log File|Status Status string
Oracle DB Database Redo Log File|General Member Name string
Oracle DB Database Redo Log File|General Sequence # integer
Oracle DB Database Redo Log File|General Thread # integer
Oracle DB Database Redo Log File|General Size integer
Oracle DB Database Database File|Status Status string
Oracle DB Database Database File|Disk I/O Max Write Time integer
Oracle DB Database Database File|Disk I/O Average I/O Time integer
Oracle DB Database Database File|Disk I/O Write Time integer
Oracle DB Database Database File|Disk I/O Single Blocks Read integer
Oracle DB Database Database File|Disk I/O Physical Blocks Read integer
Oracle DB Database Database File|Disk I/O Average Write Time integer
Oracle DB Database Database File|Disk I/O Average Read Time integer
Oracle DB Database Database File|Disk I/O Physical Blocks Written integer
Oracle DB Database Database File|Disk I/O Physical Writes integer
Oracle DB Database Database File|Disk I/O Read Time integer
Oracle DB Database Database File|Disk I/O Physical Reads integer
Oracle DB Database Database File|Disk I/O Max Read Time integer
Oracle DB Database Database File|General Autoextensible string
Oracle DB Database Database File|General Tablespace Name string
Oracle DB Database Database File|General Max Size integer
Oracle DB Database Database File|General Size integer
Oracle DB Instance Sessions Unblocked User Sessions integer
Oracle DB Instance Sessions Blocked User Sessions integer
Oracle DB Instance Sessions Active User Sessions integer
Oracle DB Instance Sessions User Types integer
Oracle DB Instance Sessions Unknown Wait Time User Sessions integer
Oracle DB Instance Sessions Blocked by Unknown User Sessions integer
Oracle DB Instance Sessions Non-Waiting User Sessions integer
Oracle DB Instance Sessions Background Types integer
Oracle DB Instance Sessions Sessions Count integer
Oracle DB Instance Sessions Applications integer
Oracle DB Instance Sessions Sniped User Sessions integer
Oracle DB Instance Sessions O/S Machines integer
Oracle DB Instance Sessions Waiting User Sessions integer
Oracle DB Instance Sessions Inactive User Sessions integer
Oracle DB Instance Sessions O/S Client Users string
Oracle DB Instance Sessions Killed User Sessions integer
Oracle DB Instance Sessions Cached User Sessions integer
Oracle DB Instance Latch Latch Timeouts integer
Oracle DB Instance Latch Latch Time Waited integer
Oracle DB Instance Latch Latch Waits integer
Oracle DB Instance Performance Enqueue Timeouts Per Txn float
Oracle DB Instance Performance Memory Sorts Ratio float
Oracle DB Instance Performance PX downgraded 75 to 99 percent float
Oracle DB Instance Performance Recursive Calls Per Txn float
Oracle DB Instance Performance Soft Parse Ratio float
Oracle DB Instance Performance Physical Read Total float
Oracle DB Instance Performance Consistent Read Gets float
Oracle DB Instance Performance Row Cache Miss Ratio float
Oracle DB Instance Performance User Calls Per Txn float
Oracle DB Instance Performance Background CPU Usage float
Oracle DB Instance Performance CR Undo Records Applied float
Oracle DB Instance Performance DB Block Changes Per User Call float
Oracle DB Instance Performance Physical Writes Direct Per Txn float
Oracle DB Instance Performance DB Block Gets float
Oracle DB Instance Performance User Rollback UndoRec Applied float
Oracle DB Instance Performance Workload Capture and Replay status integer
Oracle DB Instance Performance Hard Parse Count float
Oracle DB Instance Performance Physical Read Total I/O Requests float
Oracle DB Instance Performance Physical Writes Direct Lobs Per Txn float
Oracle DB Instance Performance I/O Throughput float
Oracle DB Instance Performance PQ QC Session Count float
Oracle DB Instance Performance CPU Usage Per Txn float
Oracle DB Instance Performance Executions Per Txn float
Oracle DB Instance Performance Consistent Read Changes float
Oracle DB Instance Performance Enqueue Requests float
Oracle DB Instance Performance Long Table Scans Per Txn float
Oracle DB Instance Performance Logical Reads float
Oracle DB Instance Performance PX downgraded 25 to 50 Percent float
Oracle DB Instance Performance SQL Service Response Time float
Oracle DB Instance Performance Total Index Scans Per Txn float
Oracle DB Instance Performance Redo Generated Per Txn float
Oracle DB Instance Performance Logons float
Oracle DB Instance Performance Current Open Cursors Count float
Oracle DB Instance Performance Physical Write Total I/O Requests float
Oracle DB Instance Performance User Commits float
Oracle DB Instance Performance Host CPU Utilization float
Oracle DB Instance Performance User Transactions float
Oracle DB Instance Performance Enqueue Timeouts float
Oracle DB Instance Performance Physical Read float
Oracle DB Instance Performance Redo Generated float
Oracle DB Instance Performance PX operations not downgraded float
Oracle DB Instance Performance Physical Reads Direct float
Oracle DB Instance Performance Executions float
Oracle DB Instance Performance Queries parallelized float
Oracle DB Instance Performance Full Index Scans float
Oracle DB Instance Performance User Calls Ratio float
Oracle DB Instance Performance Average Active Sessions float
Oracle DB Instance Performance Physical Reads float
Oracle DB Instance Performance Leaf Node Splits float
Oracle DB Instance Performance GC Current Block Received Per Txn float
Oracle DB Instance Performance Row Cache Hit Ratio float
Oracle DB Instance Performance DB Block Changes float
Oracle DB Instance Performance Physical Writes Direct float
Oracle DB Instance Performance Executions Per User Call float
Oracle DB Instance Performance User Rollbacks float
Oracle DB Instance Performance Physical Read I/O Requests float
Oracle DB Instance Performance Logical Reads Per Txn float
Oracle DB Instance Performance Global Cache Average CR Get Time float
Oracle DB Instance Performance Disk Sort Per Txn float
Oracle DB Instance Performance Total PGA Used by SQL Workareas float
Oracle DB Instance Performance Run Queue Processes float
Oracle DB Instance Performance Enqueue Waits float
Oracle DB Instance Performance Enqueue Deadlocks Per Txn float
Oracle DB Instance Performance DB Block Gets Per Txn float
Oracle DB Instance Performance Physical Write I/O Requests float
Oracle DB Instance Performance Redo Writes Per Txn float
Oracle DB Instance Performance PGA Cache Hit float
Oracle DB Instance Performance Total Index Scans float
Oracle DB Instance Performance PX downgraded to serial float
Oracle DB Instance Performance Response Time Per Txn float
Oracle DB Instance Performance Hard Parse Count Per Txn float
Oracle DB Instance Performance Enqueue Waits Per Txn float
Oracle DB Instance Performance Consistent Read Changes Per Txn float
Oracle DB Instance Performance DB Block Gets Per User Call float
Oracle DB Instance Performance Average Synchronous Single-Block Read Latency float
Oracle DB Instance Performance Parse Failure Count float
Oracle DB Instance Performance User Commits float
Oracle DB Instance Performance DB Block Changes Per Txn float
Oracle DB Instance Performance Execute Without Parse Ratio float
Oracle DB Instance Performance Branch Node Splits Per Txn float
Oracle DB Instance Performance Physical Reads Direct Per Txn float
Oracle DB Instance Performance Parse Failure Count Per Txn float
Oracle DB Instance Performance GC Current Block Received float
Oracle DB Instance Performance PX downgraded 1 to 25 percent float
Oracle DB Instance Performance Active Parallel Sessions float
Oracle DB Instance Performance Total Table Scans Per User Call float
Oracle DB Instance Performance Total Table Scans float
Oracle DB Instance Performance User Rollbacks float
Oracle DB Instance Performance Redo Writes float
Oracle DB Instance Performance Process Limit float
Oracle DB Instance Performance Streams Pool Usage float
Oracle DB Instance Performance User Rollback Undo Records Applied Per Txn float
Oracle DB Instance Performance Session Count float
Oracle DB Instance Performance Total Parse Count float
Oracle DB Instance Performance Consistent Read Gets Per Txn float
Oracle DB Instance Performance Database Time float
Oracle DB Instance Performance Database CPU Time Ratio float
Oracle DB Instance Performance Current OS Processes Load float
Oracle DB Instance Performance Physical Reads Direct Lobs float
Oracle DB Instance Performance PQ Slave Session Count float
Oracle DB Instance Performance Total Sorts Per User Call float
Oracle DB Instance Performance Network Traffic Volume float
Oracle DB Instance Performance Recursive Calls float
Oracle DB Instance Performance GC CR Block Received Per Txn float
Oracle DB Instance Performance Full Index Scans Per Txn float
Oracle DB Instance Performance PX downgraded 50 to 75 percent float
Oracle DB Instance Performance Buffer Cache Hit Ratio float
Oracle DB Instance Performance Rows Per Sort float
Oracle DB Instance Performance Background Time float
Oracle DB Instance Performance Cursor Cache Hit Ratio float
Oracle DB Instance Performance Disk Sort float
Oracle DB Instance Performance CR Blocks Created Per Txn float
Oracle DB Instance Performance Cell Physical I/O Interconnect float
Oracle DB Instance Performance Open Cursors Per Txn float
Oracle DB Instance Performance Physical Writes Per Txn float
Oracle DB Instance Performance Session Limit float
Oracle DB Instance Performance Long Table Scans float
Oracle DB Instance Performance Global Cache Blocks Corrupted float
Oracle DB Instance Performance Txns Per Logon float
Oracle DB Instance Performance CPU Usage float
Oracle DB Instance Performance CR Undo Records Applied Per Txn float
Oracle DB Instance Performance Physical Writes Direct Lobs float
Oracle DB Instance Performance Logical Reads Per User Call float
Oracle DB Instance Performance Physical Write Total float
Oracle DB Instance Performance Library Cache Hit Ratio float
Oracle DB Instance Performance User Calls float
Oracle DB Instance Performance Branch Node Splits float
Oracle DB Instance Performance Logons Per Txn float
Oracle DB Instance Performance Leaf Node Splits Per Txn float
Oracle DB Instance Performance Redo Allocation Hit Ratio float
Oracle DB Instance Performance Physical Write float
Oracle DB Instance Performance Database Wait Time Ratio float
Oracle DB Instance Performance User Limit float
Oracle DB Instance Performance Enqueue Deadlocks float
Oracle DB Instance Performance Host CPU Usage float
Oracle DB Instance Performance Global Cache Average Current Get Time float
Oracle DB Instance Performance Background Checkpoints float
Oracle DB Instance Performance Shared Pool Free float
Oracle DB Instance Performance Physical Reads Direct Lobs Per Txn float
Oracle DB Instance Performance Current Logons Count float
Oracle DB Instance Performance DBWR Checkpoints float
Oracle DB Instance Performance DDL statements parallelized float
Oracle DB Instance Performance Total PGA Allocated float
Oracle DB Instance Performance Total Parse Count Per Txn float
Oracle DB Instance Performance Global Cache Blocks Lost float
Oracle DB Instance Performance CR Blocks Created float
Oracle DB Instance Performance Open Cursors float
Oracle DB Instance Performance GC CR Block Received float
Oracle DB Instance Performance Physical Writes float
Oracle DB Instance Performance Enqueue Requests Per Txn float
Oracle DB Instance Performance Active Serial Sessions float
Oracle DB Instance Performance Temp Space Used float
Oracle DB Instance Performance Library Cache Miss Ratio float
Oracle DB Instance Performance Total Table Scans Per Txn float
Oracle DB Instance Performance Physical Reads Per Txn float
Oracle DB Instance Performance I/O Requests float
Oracle DB Instance Performance DML statements parallelized float
Oracle DB Instance Disk I/O Max Write Time integer
Oracle DB Instance Disk I/O Average I/O Time integer
Oracle DB Instance Disk I/O Write Time integer
Oracle DB Instance Disk I/O Single Blocks Read integer
Oracle DB Instance Disk I/O Physical Blocks Read integer
Oracle DB Instance Disk I/O Average Write Time integer
Oracle DB Instance Disk I/O Average Read Time integer
Oracle DB Instance Disk I/O Physical Blocks Written integer
Oracle DB Instance Disk I/O Physical Writes integer
Oracle DB Instance Disk I/O Read Time integer
Oracle DB Instance Disk I/O Physical Reads integer
Oracle DB Instance Disk I/O Max Read Time integer
Oracle DB Instance Shared Memory Data Transfer Cache Size integer
Oracle DB Instance Shared Memory Redo Buffers Size integer
Oracle DB Instance Shared Memory Large Pool Size integer
Oracle DB Instance Shared Memory Shared Pool Size integer
Oracle DB Instance Shared Memory Java Pool Size integer
Oracle DB Instance Shared Memory Shared IO Pool Size integer
Oracle DB Instance Shared Memory Startup overhead in Shared Pool integer
Oracle DB Instance Shared Memory Free SGA Memory Available integer
Oracle DB Instance Shared Memory Granule Size integer
Oracle DB Instance Shared Memory Streams Pool Size integer
Oracle DB Instance Shared Memory Fixed SGA Size integer
Oracle DB Instance Shared Memory Buffer Cache Size integer
Oracle DB Instance Shared Memory Maximum SGA Size integer
Oracle DB Instance Activity Time Waited integer
Oracle DB Instance Activity Enqueue Locks Current Utilization integer
Oracle DB Instance Activity Timeouts integer
Oracle DB Instance Activity Parallel Max Servers Current Utilization integer
Oracle DB Instance Activity Waits integer
Oracle DB Instance Activity Sessions Current Utilization integer
Oracle DB Instance Activity Processes Current Utilization integer
Oracle DB Instance General Sessions Limit integer
Oracle DB Instance General Parallel Max Servers Limit integer
Oracle DB Instance General Enqueue Locks Limit integer
Oracle DB Instance General Instance Role string
Oracle DB Instance General Startup Time string
Oracle DB Instance General Database Status string
Oracle DB Instance General Status string
Oracle DB Instance General Blocked string
Oracle DB Instance General Instance Name string
Oracle DB Instance General Host Name string
Oracle DB Instance General Parallel string
Oracle DB Instance General Version string
Oracle DB Instance General Archiver string
Oracle DB Instance General Active State string
Oracle DB Instance General Login Mode string
Oracle DB Instance General Shutdown Pending string
Oracle DB Instance General Processes Limit integer
Oracle DB Instance Parameter|General Parameter has not been Modified by Configuration File string
Oracle DB Instance Parameter|General Parameter has been Modified after Instance Startup string
Oracle DB Instance Parameter|General Parameter Description string
Oracle DB Instance Parameter|General Parameter Value string
Oracle DB Instance Parameter|General Parameter Value Type integer
Oracle DB Instance Event Wait Group|Activity Time Waited integer
Oracle DB Instance Event Wait Group|Activity Waits integer
Oracle DB Instance Data Guard Destination|Status Status string
Oracle DB Instance Data Guard Destination|General Destination Name string
Oracle DB Tablespace Status Status string
Oracle DB Tablespace General Contents string
Oracle DB Tablespace General Free Space integer
Oracle DB Tablespace General Allocated Size integer
Oracle DB Query Activity SQL Text string
Oracle DB Query Activity Last Load Time string
Oracle DB Query Activity Physical Read Data integer
Oracle DB Query Activity Buffer Gets integer
Oracle DB Query Activity Concurrency Wait Time integer
Oracle DB Query Activity Users Executing integer
Oracle DB Query Activity Last Active Time string
Oracle DB Query Activity Optimized Physical Read Requests integer
Oracle DB Query Activity I/O Interconnect Data integer
Oracle DB Query Activity Direct Writes integer
Oracle DB Query Activity Total Locks integer
Oracle DB Query Activity Application Wait Time integer
Oracle DB Query Activity Runtime Memory Used integer
Oracle DB Query Activity CPU Time integer
Oracle DB Query Activity Average Time integer
Oracle DB Query Activity Executions integer
Oracle DB Query Activity Total Pins integer
Oracle DB Query Activity Rows Processed integer
Oracle DB Query Activity Physical Read Requests integer
Oracle DB Query Activity Physical Write Requests integer
Oracle DB Query Activity Physical Write Data integer
Oracle DB Query Activity Parse Calls integer
Oracle DB Query Activity Elapsed Time integer
Oracle DB Query Activity User I/O Wait Time integer
Oracle DB Query Activity Disk Reads integer
Oracle DB Query Activity Child Count integer
Oracle DB Query General Rank integer
Oracle DB Query General Sharable Memory integer