Table of Contents
- Title and Copyright Information
- Preface
- How to Use This Manual
-
1
Cluster ASM Metrics
- ASM Cardinality
- ASM Cluster File System
- ASM Cluster File System State
- Disks
- ASM File Group
- ASM Volumes
- Database Disk Group Usage
- Database Sparse Disk Group Usage
- Disk Groups
- Disk Group Attributes
- Disk Group Imbalance Status
- Disk Group Target Component
- Disk Group Usage
- Disk Path
- Disk Status
- Failure Group Imbalance Status
- Failure Group Status
- File Group Usage
- Initialization Parameters
- Instance Disk Performance
- Instance Disk Group Database Performance
- Instance Disk Group Performance
- Offline Disk Count
- Response
- Sparse Disk Group Usage
- Sparse Disks
- Quota Group Usage
-
2
Automatic Storage Management
- Alert Log
- Alert Log Error Status
- ASM Alert Log
- ASM Cluster File System
- ASM Cluster File System State
- ASM File Group
- ASM Volumes
- Database Disk Group Usage
- Database Sparse Disk Group Usage
- Disk Group Imbalance Status
- Disk Group Status
- Disk Group Usage
- Disk Path
- Disk Status
- Disks
- Failure Group Imbalance Status
- Failure Group Status
- File Group Usage
- Incident
- Instance Disk Performance
- Instance Diskgroup Database Performance
- Instance Diskgroup Performance
- Offline Disk Count
- Operational Error
- Response
- Sparse Disk Group Usage
- Sparse Disks
- Quota Group Usage
- 3 Oracle High Availability Service
- 4 Cluster
-
5
Database Instance
- Alert Log
- Alert Log Error Status
- Archive Area
- Availability Notifications (Server Generated Alert)
- Collect SQL Response Time
- Data Failure
- Data Guard Fast-Start Failover
- Data Guard Fast-Start Failover Observer
- Data Guard Performance
- Data Guard Status
- Database Files
- Database Job Status
- Database Limits
- Database Replay
- Database Replay Client
- Database Services
- Database Vault Attempted Violations - Command Rules
- Database Vault Attempted Violations - Realms
- Database Vault Configuration Issues - Command Rules
- Database Vault Configuration Issues - Realms
- Database Vault Policy Changes
- DB Alert Log
- DB Alert Log Error Status
- DB Managed by Single Instance
- Deferred Transactions
- Dump Area
-
Efficiency
- Buffer Cache Hit (%)
- CPU Usage (per second)
- CPU Usage (per transaction)
- Cursor Cache Hit (%)
- Data Dictionary Hit (%)
- Database CPU Time (%)
- Library Cache Hit (%)
- Library Cache Miss (%)
- Parallel Execution Downgraded 25% or more (per second)
- Parallel Execution Downgraded 50% or more (per second)
- Parallel Execution Downgraded 75% or more (per second)
- Parallel Execution Downgraded to Serial (per second)
- Parallel Execution Downgraded to Serial (per transaction)
- PGA Cache Hit (%)
- Redo Log Allocation Hit (%)
- Response Time (per transaction)
- Row Cache Miss Ratio (%)
- Sorts in Memory (%)
- Exadata Module Version Failure
- Failed Logins
- Fast Recovery
- Fragmented Text Indexes
- Global Cache Statistics
- High Availability (RMAN Configuration)
- High Availability Backup
- High Availability Backup History
- High Availability Client Recovery Window
- High Availability Data Guard Target Summary
- High Availability Disk Backup
- High Availability Media Backup
- High Availability Recovery Window
-
Incident
- Setting Thresholds for Incident Metrics
- Access Violation
- Alert Log Error Trace File
- Alert Log Name
- Cluster Error
- Deadlock
- File Access Error
- Generic Incident
- Generic Internal Error
- Impact
- Incident ID
- Inconsistent DB State
- Internal SQL Error
- Oracle Data Block Corruption
- Out of Memory
- Redo Log Corruption
- Session Terminated
- Interconnect
- Interconnect Traffic
- Invalid Objects
- Invalid Objects by Schema
-
Messages Per Buffered Queue
- Average Age of Messages Per Buffered Queue (Seconds)
- First Message Age in Buffered Queue Per Queue (Seconds)
- Messages processed per buffered queue (%)
- Messages Processed Per Buffered Queue (%) Per Minute
- Spilled Messages
- Total Messages Processed per Buffered Queue per Minute
- Total Messages Received per Buffered Queue per Minute
-
Message Per Buffered Queue Per Subscriber
- Average Age of Messages Per Buffered Queue Per Subscriber (Seconds)
- First Message Age in Buffered Queue per Subscriber (Seconds)
- Messages Processed Per Buffered Queue Per Subscriber (%)
- Messages Processed Per Buffered Queue (%) Per Subscriber Per Minute
- Total Messages Processed Per Buffered Queue Per Subscriber Per Minute
- Total Messages Received Per Buffered Queue Per Subscriber Per Minute
-
Messages Per Persistent Queue
- Age of the First Message in Persistent Queue Per Queue
- Average Age of Messages Per Persistent Queue (Seconds)
- Messages Processed Per Persistent Queue (%)
- Messages Processed Per Persistent Queue (%) Per Minute
- Total Messages Processed per Persistent Queue per Minute
- Total Messages Received per Persistent Queue per Minute
-
Messages Per Persistent Queue Per Subscriber
- Average Age of Messages Per Persistent Queue Per Subscriber (Seconds)
- Age of the First Message in Persistent Queue Per Subscriber
- Messages Processed Per Persistent Queue Per Subscriber (%)
- Messages Processed Per Persistent Queue (%) Per Subscriber Per Minute
- Total Messages Processed Per Persistent Queue Per Subscriber Per Minute
- Total Messages Received Per Persistent Queue Per Subscriber Per Minute
- Memory Usage
- Monitoring User Account
- OCM Instrumentation
- Operational Error
- Operating System Audit Records
- Recovery
- Recovery Area
- Response
- SCN Growth Statistics
- SCN Instance Statistics
- SCN Max Statistics
- Segment Advisor Recommendations
- Session Suspended
- SGA Pool Wastage
- Snapshot Too Old
- Space Usage by Buffered Queues
- SQL Response Time
- Streams Apply Aborted
- Streams Apply Coordinator Statistics
- Streams Apply Errors
- Streams Apply Queue - Buffered
- Streams Apply Queue - Persistent
- Streams Apply Reader Statistics
- Streams Capture Message Statistics
- Streams Capture Queue Statistics
- Streams Latency and Throughput
- Streams Pool Usage
- Streams Processes Count
- Streams Processes Status
- Streams Propagation - Messages State Stats
- Streams Propagation - Queue Propagation
- Streams Propagation Aborted
- Suspended Session
- System Response Time Per Call
- System Sessions Waiting
- Tablespace Allocation
- Tablespaces Full
- Tablespaces Full (Dictionary Managed)
- Tablespaces Full (Temp)
- Tablespaces Full (Undo)
- Tablespaces With Problem Segments
- Temporary File Status
-
Throughput
- Average Active Sessions
- Average Synchronous Single-Block Read Latency (ms)
- BG Checkpoints (per second)
- Branch Node Splits (per second)
- Branch Node Splits (per transaction)
- Consistent Read Blocks Created (per second)
- Consistent Read Blocks Created (per transaction)
- Consistent Read Changes (per second)
- Consistent Read Changes (per transaction)
- Consistent Read Gets (per second)
- Consistent Read Gets (per transaction)
- Consistent Read Undo Records Applied (per second)
- Consistent Read Undo Records Applied (per transaction)
- Cumulative Logons (per second)
- Cumulative Logons (per transaction)
- Database Block Changes (per second)
- Database Block Changes (per transaction)
- Database Block Gets (per second)
- Database Block Gets (per transaction)
- Database Time (centiseconds per second)
- DBWR Checkpoints (per second)
- Enqueue Deadlocks (per second)
- Enqueue Deadlocks (per transaction)
- Enqueue Requests (per second)
- Enqueue Requests (per transaction)
- Enqueue Timeout (per second)
- Enqueue Timeout (per transaction)
- Enqueue Waits (per second)
- Enqueue Waits (per transaction)
- Executes (per second)
- Executes Performed without Parses (%)
- Full Index Scans (per second)
- Full Index Scans (per transaction)
- Hard Parses (per second)
- Hard Parses (per transaction)
- I/O Megabytes (per second)
- I/O Requests (per second)
- Leaf Node Splits (per second)
- Leaf Node Splits (per transaction)
- Network Bytes (per second)
- Number of Transactions (per second)
- Open Cursors (per second)
- Open Cursors (per transaction)
- Parse Failure Count (per second)
- Parse Failure Count (per transaction)
- Physical Reads (per second)
- Physical Reads (per transaction)
- Physical Reads Direct (per second)
- Physical Reads Direct (per transaction)
- Physical Reads Direct Lobs (per second)
- Physical Reads Direct Lobs (per transaction)
- Physical Writes (per second)
- Physical Writes (per transaction)
- Physical Writes Direct (per second)
- Physical Writes Direct (per transaction)
- Physical Writes Direct Lobs (per second)
- Physical Writes Direct Lobs (per transaction)
- Recursive Calls (per second)
- Recursive Calls (per transaction)
- Redo Generated (per second)
- Redo Generated (per transaction)
- Redo Writes (per second)
- Redo Writes (per transaction)
- Rows Processed (per sort)
- Scans on Long Tables (per second)
- Scans on Long Tables (per transaction)
- Session Logical Reads (per second)
- Session Logical Reads (per transaction)
- Soft Parse (%)
- Sorts to Disk (per second)
- Sorts to Disk (per transaction)
- Total Index Scans (per second)
- Total Index Scans (per transaction)
- Total Parses (per second)
- Total Parses (per transaction)
- Total Table Scans (per second)
- Total Table Scans (per transaction)
- User Calls (%)
- User Calls (per second)
- User Calls (per transaction)
- User Commits (per second)
- User Commits (per transaction)
- User Rollback Undo Records Applied (per second)
- User Rollback Undo Records Applied (per transaction)
- User Rollbacks (per second)
- User Rollbacks (per transaction)
- Total Objects by Schema
- Total Tables by Schema
- Unusable Indexes
- Unusable Indexes by Schema
- User Audit
- User Block
- User Block Chain
- User Locks
- User-Defined SQL
-
Wait Bottlenecks
- Active Sessions Waiting: I/O
- Active Sessions Waiting: Other
- Buffer busy waits (%)
- CPU Time Delta (sec)
- DB file scattered read (%)
- DB file sequential read (%)
- DB file single write (%)
- Direct path read (%)
- Direct path read (lob) (%)
- Direct path write (%)
- Direct path write (lob) (%)
- Enqueue - other (%)
- Enqueue: DML - contention (%)
- Enqueue: HW, Segment High Water Mark - contention (%)
- Enqueue: ST, Space Transaction - contention (%)
- Enqueue: TM, TX, Transaction - row lock contention (%)
- Enqueue: TX mode 4, Transaction - allocate ITL entry (%)
- Enqueue: UL: User-defined - contention (%)
- Free buffer waits (%)
- Latch free - other (%)
- Latch: cache buffer chains (%)
- Latch: library cache (%)
- Latch: redo copy (%)
- Latch: shared pool (%)
- Library cache load lock (%)
- Library cache lock (%)
- Library cache pin (%)
- Local write wait (%)
- Log buffer space (%)
- Log file switch (archiving needed) (%)
- Log file switch (checkpoint complete) (%)
- Log file switch completion (%)
- Log file sync (%)
- Log switch/archive (%)
- Pipe put (%)
- Row cache lock (%)
- SQL*Net break/reset to client (%)
- SQL*Net break/reset to dblink (%)
- SQL*Net message to client (%)
- SQL*Net message to dblink (%)
- SQL*Net more data from client (%)
- SQL*Net more data from dblink (%)
- SQL*Net more data to client (%)
- SQL*Net more data to dblink (%)
- Wait Time (%)
- Write complete waits (%)
- Wait by Session Count
- Waits by Wait Class
-
6
Cluster Database
- Archive Area
- Availability Notifications (Server Generated Alert)
- Cluster Managed Database Services
- Data Guard Fast-Start Failover
- Data Guard Fast-Start Failover Observer Status
- Data Guard Performance
- Data Guard Status
- Database Cardinality
- Database Job Status
- Database Wait Bottlenecks
- Database Vault Attempted Violations - Command Rules
- Database Vault Attempted Violations - Realms
- Database Vault Configuration Issues - Realms
- Database Vault Configuration Issues - Command Rules
- Database Vault Policy Changes
- Deferred Transactions
- Exadata Module Version Failure
- Failed Logins
- Fast Recovery
- Fragmented Text Indexes
- High Availability (RMAN Configuration)
- High Availability Backup
- High Availability Backup History
- High Availability Client Recovery Window
- High Availability Data Guard Target Summary
- High Availability Disk Backup
- High Availability Media Backup
- High Availability Recovery Window
- Invalid Objects
- Invalid Objects by Schema
-
Messages Per Buffered Queue
- Average age of messages per buffered queue (seconds)
- First Message Age in Buffered Queue Per Queue (Seconds)
- Messages processed per buffered queue (%)
- Messages processed per buffered queue (%) per minute
- Spilled Messages
- Total Messages Processed per Buffered Queue per Minute
- Total Messages Received per Buffered Queue per Minute
-
Messages Per Buffered Queue Per Subscriber
- Average Age of Messages Per Buffered Queue Per Subscriber (Seconds)
- First Message Age in Buffered Queue per Subscriber (Seconds)
- Messages Processed Per Buffered Queue (%) Per Subscriber Per Minute
- Messages Processed Per Buffered Queue Per Subscriber (%)
- Total Messages Processed Per Buffered Queue Per Subscriber Per Minute
- Total Messages Received Per Buffered Queue Per Subscriber Per Minute
-
Messages Per Persistent Queue
- Average Age of Messages Per Persistent Queue (Seconds)
- Age of The First Message in Persistent Queue Per Queue (Seconds)
- Messages Processed Per Persistent Queue (%)
- Messages Processed Per Persistent Queue (%) Per Minute
- Total Messages Processed per Persistent Queue per Minute
- Total Messages Received per Persistent Queue per Minute
-
Messages Per Persistent Queue Per Subscriber
- Average Age of Messages Per Persistent Queue Per Subscriber (Seconds)
- First Message Age in Persistent Queue per Subscriber (Seconds)
- Messages Processed Per Persistent Queue (%) Per Subscriber Per Minute
- Messages Processed Per Persistent Queue Per Subscriber (%)
- Total Messages Processed Per Persistent Queue Per Subscriber Per Minute
- Total Messages Received Per Persistent Queue Per Subscriber Per Minute
- Monitoring User Account
- QoS Management - Performance Satisfaction
- Recovery
- Recovery Area
- SCN Growth Statistics
- SCN Max Statistics
- Segment Advisor Recommendations
- Session Suspended
- Snapshot Too Old
- Space Usage by Buffered Queues
- Streams Apply Queue - Buffered
- Streams Apply Queue - Persistent
- Streams Apply Reader Statistics
- Streams Capture Queue Statistics
- Streams Latency and Throughput
- Streams Processes Count
- Streams Propagation - Message State Stats
- Suspended Session
- Tablespace Allocation
- Tablespaces Full
- Tablespaces Full (dictionary managed)
- Tablespaces With Problem Segments
- Temporary File Status
- Total Objects by Schema
- Total Tables by Schema
- Unusable Indexes
- Unusable Indexes by Schema
- User Block
- User Locks
- 7 Far Sync Instance
-
8
Recovery Appliance
- Data Sent/Received
- Health
-
Protected Databases
- Backup Data Rate (GB/s)
- Copy-to-Tape Data Rate (GB/s)
- Copy-to-Tape Queued Data (GB)
- Copy-to-Tape Queued Data Age (hours)
- Copy-to-Tape Total Data on Tape (GB)
- Cumulative Backup Data (GB)
- Cumulative Backup Data Delta (GB)
- Cumulative Copy-to-Tape Data (GB)
- Cumulative Copy-to-Tape Data Delta (GB)
- Cumulative Replication Data Delta (GB)
- Cumulative Replication Data (GB)
- Current Recovery Window (interval)
- Current Recovery Window (sec)
- Database Key
- Database Unique Name
- Date Added as Protected Database
- Deduplication Ratio
- Keep Backup Space (GB)
- Last Complete Backup
- Last Copy to Tape
- Last Replication
- Most Recent Recovery Point
- Near-Zero Data Loss Enabled
- Number of Protected Databases
- Oldest Recovery Point
- Protection Policy
- Recovery Window Goal (interval)
- Recovery Window Goal (sec)
- Recovery Window Ratio (%)
- Recovery Window Space (GB)
- Recovery Window Space as a Percentage of Reserved Space
- Replication Data Rate (GB/s)
- Replication Queued Data (GB)
- Reserved Space (GB)
- Storage Location
- Unprotected Data Window (sec)
- Unprotected Data Window Threshold (sec)
- Used Space (GB)
-
Queued Data
- Backup Tasks Queued Since Last Collection
- Copy-to-Tape Tasks Queued Since Last Collection
- Replication Tasks Queued Since Last Collection
- Total Backup Tasks Queued
- Total Copy-to-Tape Data Queued (bytes)
- Total Copy-to-Tape Tasks Queued
- Total Replication Data Queued (bytes)
- Total Replication Tasks Queued
- Replication Status
- Response
-
Storage Locations
- Incoming Backup Data Rate (GB/s)
- Key
- Name
- Number of Storage Locations
- Recovery Window Space (GB)
- Recovery Window Space as a Percentage of Reserved Space
- Recovery Window Space as a Percentage of Storage Location Size
- Reserved Space (GB)
- Size (GB)
- Unreserved Space (GB)
- Unused Space (GB)
- Used Space (GB)
- 9 Listener
-
10
Oracle Exadata
-
Oracle Exadata Storage Server
- Aggregated Exadata Capacity
-
Aggregated Exadata CellDisk
- Average CellDisk IO Load
- Average CellDisk Read IOPS
- Average CellDisk Read Response Time
- Average CellDisk Read Throughput
- Average CellDisk Write IOPS
- Average CellDisk Write Response Time
- Average CellDisk Write Throughput
- Maximum CellDisk IO Load
- Total CellDisk IO Load
- Total CellDisk Read IOPS
- Total CellDisk Read Throughput
- Total CellDisk Write IOPS
- Total CellDisk Write Throughput
- Aggregated Exadata Diskgroup Capacity
-
Aggregated Exadata FlashDisk and HardDisk
- Average CellDisk IO Load
- Average CellDisk IO Utilization
- Average CellDisk Large Read IOPS
- Average CellDisk Large Read Response Time
- Average CellDisk Large Read Throughput
- Average CellDisk Large Write IOPS
- Average CellDisk Large Write Response Time
- Average CellDisk Large Write Throughput
- Average CellDisk Read IOPS
- Average CellDisk Read Response Time
- Average CellDisk Read Throughput
- Average CellDisk Small Read IOPS
- Average CellDisk Small Read Response Time
- Average CellDisk Small Read Throughput
- Average CellDisk Small Write IOPS
- Average CellDisk Small Write Response Time
- Average CellDisk Small Write Throughput
- Average CellDisk Write IOPS
- Average CellDisk Write Response Time
- Average CellDisk Write Throughput
- CellDisk Type
- Maximum CellDisk Small Read Response Time
- Maximum CellDisk Small Write Response Time
- Total CellDisk IO Load
- Total CellDisk IO Utilization
- Total CellDisk Read IOPS
- Total CellDisk Read Throughput
- Total CellDisk Write IOPS
- Total CellDisk Write Throughput
- Aggregated Exadata Sparse Diskgroup Capacity
- Cell Generated Alert
- Cell ILOM Generated Alert
- CellSrv Status
- Exadata Cell Metric
-
Exadata CellDisk Metric
- Average Large Read Response Time
- Average Large Write Response Time
- Average Read Response Time
- Average Response Time
- Average Small Read Response Time
- Average Small Write Response Time
- Average Write Response Time
- CellDisk Type
- IO Load
- IO Utilization
- Large Read Bytes
- Large Read Requests
- Large Write Bytes
- Large Write Requests
- Object Name
- Read IOPS
- Read Throughput (MBPS)
- Small Read Bytes
- Small Read Requests
- Small Write Bytes
- Small Write Requests
- Write IOPS
- Write Throughput (MBPS)
- Exadata CellDisk Load Imbalance
- Exadata Disk Status Metric
- Exadata Flash Cache IORM Database Metric
- Exadata Flash Cache IORM Pluggable Database Metric
-
Exadata Flash Cache Metric
- All I/O Requests
- Cell Name
- Default Hits
- Default Hits (%)
- Default Misses
- Default Misses (%)
- Default Read IOPS
- Default Read Throughput (MBPS)
- Default Used (GB)
- Destage Write To Disk Per Second
- First Writes
- First Writes Per Second
- Flash Cache Population Writes Per Second
- I/O Requests Keep Pool Misses
- I/O Requests Read Misses
- I/O Requests for keep
- Keep Hits
- Keep Hits (%)
- Keep Misses
- Keep Misses (%)
- Keep Overwrites Per Second
- Keep Pool Read IOPS
- Keep Pool Read Throughput (MBPS)
- Keep Pool Used (GB)
- Overwrites
- Overwrites Per Second
- Read Hit Ratio for Random I/O
- Read IOPS for Random I/O
- Read IOPS for Scan
- Read Misses (MB)
- Read Throughput Redirected to Disk for Scan (MBPS)
- Read Throughput for Random I/O (MBPS)
- Read Throughput for Scan (MBPS)
- Reads (MB)
- Reads for Keep (MB)
- Used (GB)
- Write IO requests that bypass Flash Cache
-
Exadata Flash IORM Consumer Group
Metric
- Average I/O Throughput (MB/Sec)
- Average Wait Time for I/O (ms/req)
- Average IORM Wait Time for Large I/O (ms/req)
- Average IORM Wait Time for Small I/O (ms/req)
- Cell Name
- I/O Requests per Second (IO/sec)
- I/O Requests per Second - Large (IO/Sec)
- I/O Requests per Second - Small (IO/Sec)
- I/O Utilization (%)
-
Exadata Flash IORM Database Metric
- Average I/O Throughput (MB/Sec)
- Average Wait Time for I/O (ms/req)
- Average IORM Wait Time for Large I/O (ms/req)
- Average IORM Wait Time for Small I/O (ms/req)
- Cell Name
- I/O Requests per Second (IO/sec)
- I/O Requests per Second - Large (IO/Sec)
- I/O Requests per Second - Small (IO/Sec)
- I/O Utilization (%)
-
Exadata Flash IORM Pluggable Database
Metric
- Average I/O Throughput (MB/Sec)
- Average IORM Wait Time for I/O (ms/req)
- Average IORM Wait Time for Large I/O (ms/req)
- Average IORM Wait Time for Small I/O (ms/req)
- Cell Name
- I/O Requests per Second (IO/sec)
- I/O Requests per Second - Large (IO/Sec)
- I/O Requests per Second - Small (IO/Sec)
- I/O Utilization (%)
-
Exadata Flash Log Metric
- Cell Name
- Cumulative Disk Write Errors
- Cumulative Flash Write Errors
- Efficiency of Smart Flash Log Over the Past Hour
- Efficiency of Smart Flash Logging (%)
- Megabytes per second Written to Flash
- Megabytes per second Written to Hard Disk
- Redo Data Kept
- Redo Writes Exceeding Outlier Threshold
- Redo Writes Prevented from Exceeding Outlier Threshold
- Skipped Large Writes
- Skipped Writes Due to Slow Disk
- Skipped Writes Due to Slow Disk During Last Minute
- Skipped Writes Due to Unavailable Buffer
- Writes Serviced
- Exadata IORM Consumer Group Metric
-
Exadata IORM DB
- Average I/O Load
- Average I/O Throughput (MB/Sec)
- Average Wait Time for I/O (ms/req)
- Average Wait Time for Large I/O (ms/req)
- Average Wait Time for Small I/O (ms/req)
- Average latency of reading or writing blocks/request from flash disks
- Average latency of reading or writing blocks/request from hard disks
- Average latency of reading or writing large blocks/request from hard disks
- Average latency of reading or writing small blocks/request from hard disks
- Cell Name
- Cumulative latency of reading or writing blocks from flash disks
- Cumulative latency of reading or writing large blocks from hard disks
- Cumulative latency of reading or writing small blocks from hard disks
- I/O Requests per Second (IO/Sec)
- I/O Requests per Second - Large (IO/Sec)
- I/O Requests per Second - Small (IO/Sec)
- IO Utilization (%)
- Large I/O Utilization (%)
- Small IO Utilization (%)
- Wait Time for Large I/O (ms)
- Wait Time for Small I/O (ms)
-
Exadata IORM Pluggable Database Metric
- Average I/O Load
- Average I/O Throughput (MB/Sec)
- Average Wait Time for Large I/O (ms/req)
- Average Wait Time for Small I/O (ms/req)
- Average Wait Time for I/O (ms/req)
- Cell Name
- I/O Requests per Second (IO/Sec)
- I/O Requests per Second - Large (IO/Sec)
- I/O Requests per Second - Small (IO/Sec)
- I/O Utilization (%)
- Large I/O Utilization (%)
- Small I/O Utilization (%)
- Wait Time for Large I/O (ms)
- Wait Time for Small I/O (ms)
- Exadata Key Performance Indicators
- Exadata Smart IO Metric
- Exadata Storage Type
- Filesystem Utilization
- HCA Port Configuration Monitor
-
HCA Port Errors
- Excessive buffer overruns
- Incoming VL15 packets dropped due to resource limitation
- Link integrity errors
- Link recovers
- Packets not transmitted due to constraints
- Received packets discarded due to constraints
- Received packets marked with the EBP delimiter
- Received packets with error
- Symbol errors
- Total errors
- HCA Port State
- HCA Port State (For Alerts)
- Host Interconnect Statistics
- Response
- Top CPU Activity
- Network Port
-
Oracle Database Exadata Storage Server System
-
Agg_Exadata_System_Celldisk_Metric
- Average Flash Disk IO Load
- Average Flash Disk Read IOPS
- Average Flash Disk Read Throughput
- Average Flash Disk Write IOPS
- Average Flash Disk Write Throughput
- Average Hard Disk IO Load
- Average Hard Disk Read IOPS
- Average Hard Disk Read Throughput
- Average Hard Disk Write IOPS
- Average Hard Disk Write Throughput
- Maximum Flash Disk IO Load
- Maximum Flash Disk Read IOPS
- Maximum Flash Disk Read Throughput
- Maximum Flash Disk Write IOPS
- Maximum Flash Disk Write Throughput
- Maximum Hard Disk IO Load
- Maximum Hard Disk Read IOPS
- Maximum Hard Disk Read Throughput
- Maximum Hard Disk Write IOPS
- Maximum Hard Disk Write Throughput
- Minimum Flash Disk IO Load
- Minimum Flash Disk Read IOPS
- Minimum Flash Disk Read Throughput
- Minimum Flash Disk Write IOPS
- Minimum Flash Disk Write Throughput
- Minimum Hard Disk IO Load
- Minimum Hard Disk Read IOPS
- Minimum Hard Disk Read Throughput
- Minimum Hard Disk Write IOPS
- Minimum Hard Disk Write Throughput
- Response
-
Agg_Exadata_System_Celldisk_Metric
- Oracle Exadata Storage Server Grid
-
Oracle Exadata Storage Server
-
11
Pluggable Databases
- Database Feature Usage
- Datafiles
- Database Job Status
- Database Services
- Failed Logins
- Invalid Objects
- Invalid Objects by Schema
-
Messages per buffered queue
- Average age of messages per buffered queue (seconds)
- Spilled Messages
- First message age in the buffered queue per queue (seconds)
- Messages processed per buffered queue (%)
- Total Messages Processed per Buffered Queue per Minute
- Total messages received per buffered queue per minute
- Total number of messages processed
- Total number of messages received
-
Messages per buffered queue per subscriber
- Average age of messages/buffered queue/subscriber (seconds)
- First message age in buffered queue per subscriber (seconds)
- Messages processed/buffered queue/subscriber (%)
- Messages processed/buffered queue/subscriber per minute (%)
- Total messages processed/buffered queue/subscriber per minute
- Total messages received/buffered queue/subscriber per minute
- Total number of messages processed
- Total number of messages received
-
Messages per persistent queue
- Average age of messages per persistent queue (seconds)
- First message age in persistent queue/queue (seconds)
- Global Database Name
- Messages processed per persistent queue (%)
- Messages processed per persistent queue per minute (%)
- Total messages processed per persistent queue per minute
- Total messages received per persistent queue per minute
- Total number of messages processed
- Total number of messages received
-
Messages per persistent queue per subscriber
- Average age of messages/persistent queue/subscriber (seconds)
- First message age in persistent queue/subscriber (seconds)
- Global Database Name
- Messages processed/persistent queue/subscriber per minute (%)
- Messages processed/persistent queue/subscriber (%)
- Total messages processed/persistent queue/subscriber per minute (%)
- Total messages received/persistent queue/subscriber per minute
- Total number of messages processed
- Total number of messages received
- Response
- Rollback Segments
- Segment Advisor Recommendations
- Tablespaces
- Tablespace Allocation
- Tablespaces Full
- Tablespaces Full (Temp)
- Tablespaces Full (dictionary managed)
- Tablespaces With Problem Segments
- Temporary File Status
- Total Objects by Schema
- Total Tables by Schema
- 12 Autonomous Databases
- 13 Global Data Services
- 14 Sharded Databases
- 15 CISCO Switch Metrics
- 16 KVM Target Metrics
- 17 Integrated Lights Out Manager Metrics
- 18 Infiniband Network
-
19
Infiniband Switch
- Aggregate Sensors
- Fan Speed Sensors
- Fan Speed Sensor Alerts
- FRU Removal Alerts
- Response
-
Switch Gateway Port State
- 10 Gb/s Ethernet Port
- State
- Received Bytes
- Received Packets
- Received Jumbo Packets
- Received Unicast Packets
- Received Broadcast Packets
- Received Buffers
- Received CRC Errors
- Received Runtime Errors
- Received Total Errors
- Transmitted Bytes
- Transmitted Packets
- Transmitted Jumbo Packets
- Transmitted Unicast Packets
- Transmitted Multicast Packets
- Transmitted Broadcast Packets
- Transmitted Total Errors
- Switch Performance Summary
- Switch Port Configuration Monitor
-
Switch Port Errors
- Excessive buffer overruns
- Incoming VL15 packets dropped due to resource limitation
- Link integrity errors
- Link recovers
- Packets not transmitted due to constraints
- Received packets discarded due to constraints
- Received packets marked with the EBP delimiter
- Received packets with error
- Symbol errors
- Total errors
- Switch Port Performance
- Switch Port State
- Switch Port State (For Alerts)
- Switch State Summary
- Switch Temperatures
- Temperature Sensors
- Voltage Sensors