Table of Contents

• Title and Copyright Information
• Preface
  • Audience
  • Documentation Accessibility
  • Related Resources
  • Conventions
• How to Use This Manual
  • Structure of the Metric Reference Manual
    • Metric Information
    • Examples of Metric Summary Tables
    • Definitions of Columns in Metric Summary Tables
    • Abbreviations and Acronyms
  • About Metrics, Thresholds, and Alerts
    • Accessing Metrics
    • Editing Metrics
    • Specifying Multiple Thresholds
• 1 Database Instance
  • Alert Log
    • Alert Log Error Trace File
    • Alert Log Name
    • Archiver Alert Log Error
    • Data Block Corruption Alert Log Error
    • Generic Alert Log Error
    • Media Failure Alert Log Error
    • Session Terminated Alert Log Error
  • Alert Log Error Status
    • Archiver Alert Log Error Status
    • Data Block Corruption Alert Log Error Status
    • Generic Alert Log Error Status
    • Media Failure Alert Log Error Status
    • Session Terminated Alert Log Error Status
  • Archive Area
    • Archive Area Used (%)
    • Archive Area Used (KB)
    • Free Archive Area (KB)
    • Total Archive Area (KB)
  • Availability Notifications (Server Generated Alert)
  • Collect SQL Response Time
    • SQL Response Time (%)
  • Data Failure
    • Alert Log Name
    • Data Failure Detected
  • Data Guard Fast-Start Failover
  • Data Guard Fast-Start Failover Observer – Oracle Database 11gR2 to 18c
    • Observer Status
  • Data Guard Fast-Start Failover Observers – Oracle Database 19c and later
  • Data Guard Performance
    • Apply Lag (seconds)
    • Estimated Failover Time (seconds)
    • Redo Apply Rate (KB/second)
    • Redo Generation Rate (KB/second)
    • Transport Lag (seconds)
    • Transport Lag Data Refresh Time
  • Data Guard Status
    • Data Guard Status
  • Database Files
    • Average File Read Time (centi-seconds)
    • Average File Write Time (centi-seconds)
  • Database Job Status
    • Broken Job Count
    • Failed Job Count
  • Database Limits
    • Current Logons Count
    • Current Open Cursors Count
    • Lock Limit Usage (%)
    • Process Limit Usage (%)
    • Session Limit Usage (%)
    • User Limit Usage (%)
  • Database Replay
    • Workload Capture Status
    • Workload Replay Status
  • Database Replay Client
    • Average I/O Latency (milliseconds)
    • Replay Threads (%) Performing I/O
    • Replay Threads (%) Using CPU
  • Database Scheduler Jobs
    • Elapsed Running Time (in Minutes)
    • Failure Count
    • State
  • Database Services
    • Service CPU Time (per user call) (microseconds)
    • Service Response Time (per user call) (microseconds)
  • Database Vault Attempted Violations - Command Rules
    • Database Vault Attempted Violations Count - Command Rules
  • Database Vault Attempted Violations - Realms
    • Database Vault Attempted Violations - Realms
  • Database Vault Configuration Issues - Command Rules
    • DV (Command Rule) - Configuration Issue Count
  • Database Vault Configuration Issues - Realms
    • Database Vault Configuration Issues Count - Realms
  • Database Vault Policy Changes
    • Database Vault Policy Changes Count
  • Datafile Allocation
  • DB Alert Log
    • Archiver Alert Log Error
    • Data Block Corruption Alert Log Error
    • Generic Alert Log Error
    • Media Failure Alert Log Error
    • Session Terminated Alert Log Error
  • DB Alert Log Error Status
    • Archiver Alert Log Error Status
    • Data Block Corruption Alert Log Error Status
    • Generic Alert Log Error Status
    • Media Failure Alert Log Error Status
    • Session Terminated Alert Log Error Status
  • DB Managed by Single Instance
    • CRS Home Directory
    • DB Managed by Single Instance HA
  • Deferred Transactions
    • Deferred Transaction Count
    • Deferred Transaction Error Count
  • Dump Area
    • Dump Area Directory
    • Dump Area Used (%)
    • Dump Area Used (KB)
    • Free Dump Area (KB)
    • Total Dump Area (KB)
  • 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
    • Error Count
  • Failed Logins
    • Failed Login Count
  • Fast Recovery
    • Fast Recovery Area
    • Fast Recovery Area Size
    • Flashback On
    • Log Mode
    • Non-Reclaimable Fast Recovery Area (%)
    • Oldest Flashback Time
    • Reclaimable Fast Recovery Area (%)
    • Usable Fast Recovery Area (%)
  • Fragmented Text Indexes
    • Fragmented Text Index count
    • Fragmented Text Index count crossing critical threshold
    • Fragmented Text Index count crossing warning threshold
  • Global Cache Statistics
    • Global Cache Average CR Block Request Time (centi-seconds)
    • Global Cache Average Current Block Request Time (centi-seconds)
    • Global Cache Blocks Corrupt
    • Global Cache Blocks Lost
  • 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
    • Interface Type
  • Interconnect Traffic
    • Transfer Rate (MB/s)
  • Invalid Objects
    • Invalid Object Count
  • Invalid Objects by Schema
    • Invalid Object Count 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
    • Total Memory Usage (MB)
  • Monitoring User Account
    • Monitoring User Connectivity Issue
    • Monitoring User Expiry
    • Database Monitoring User Privileges Check
  • OCM Instrumentation
    • Instrumentation Present
    • Need to Instrument with OCM
    • OCM Configured
  • Operational Error
    • Alert Log Error Trace File
    • Alert Log Name
    • Archiver Error
    • Data Block Corruption
    • Generic Operational Error
    • Media Failure
    • User-Defined Error
    • User-Defined Text
    • User-Defined Warning
  • Operating System Audit Records
    • Size of Audit Files (MB)
  • Recovery Area
    • Recovery Area Free Space (%)
    • Recovery Area Used Space (%)
  • Response
    • State
    • Status
  • SCN Growth Statistics
    • Current SCN
    • Current SCN Compatibility
    • Max Rate
    • Maximum SCN Compatibility
    • SCN Health
    • SCN Total Growth Rate (per sec)
  • SCN Instance Statistics
    • SCN Intrinsic Growth Rate (per sec)
  • SCN Max Statistics
    • Max SCN Jump in one second (last 24 hours)
  • Segment Advisor Recommendations
    • Number of Recommendations
  • Session Suspended
    • Session Suspended by Data Object Limitation
    • Session Suspended by Quota Limitation
    • Session Suspended by Rollback Segment Limitation
    • Session Suspended by Tablespace Limitation
  • SGA Pool Wastage
    • Java Pool Free (%)
    • Large Pool Free (%)
    • Shared Pool Free (%)
  • Snapshot Too Old
    • Snapshot Too Old Due to Rollback Segment Limit
    • Snapshot Too Old Due to Tablespace Limit
  • Space Usage by Buffered Queues
    • Queue Size (MB)
    • Space Usage of Buffered Queue With Respect to Streams Pool Size (%)
  • SQL Response Time
    • Baseline SQL Response Time
    • Current SQL Response Time
    • SQL Response Time (%)
  • Streams Apply Aborted
    • Streams Apply Process Aborted
    • Streams Apply Process Error
  • Streams Apply Coordinator Statistics
    • Total Number of Transactions Assigned
    • Rate of Transactions Applied (per Sec)
    • Rate of Transactions Assigned (per Sec)
    • Rate of Transactions Received (per Sec)
    • Total Number of Transactions Applied
    • Total Number of Transactions Received
  • Streams Apply Errors
    • Error Message
    • Error Number
    • Local Transaction ID
    • Message Count
    • Source Transaction ID
  • Streams Apply Queue - Buffered
    • Streams Apply - (%) Spilled Messages
  • Streams Apply Queue - Persistent
    • Streams Apply - (%) Messages in Waiting State
  • Streams Apply Reader Statistics
    • Rate at Which Messages Are Getting Spilled (per Sec)
    • Total Number of Messages Dequeued
    • Total Number of Spilled Messages
  • Streams Capture Message Statistics
    • Message Capture Rate (per Sec)
    • Messages Enqueue Rate (per Sec)
    • Total Messages Captured
    • Total Messages Enqueued
  • Streams Capture Queue Statistics
    • Capture Queue - Cumulative Number of Messages
    • Capture Queue - Cumulative Number of Spilled Messages
    • Capture Queue - Number of Messages
    • Capture Queue - Number of Spilled Messages
    • Streams Capture - (%) Cumulative Spilled Messages
    • Streams Capture - (%) Spilled Messages
  • Streams Latency and Throughput
    • Latency
    • Throughput (per sec)
    • Total Messages
  • Streams Pool Usage
    • Streams Pool Full
  • Streams Processes Count
    • Number of Apply Processes Having Errors
    • Number of Capture Processes Having Errors
    • Number of Apply Processes
    • Number of Capture Processes
    • Number of Propagation Jobs
    • Number of Propagations Having Errors
    • Total Number of Propagation Errors
  • Streams Processes Status
    • Streams Process Errors
    • Streams Process Status
  • Streams Propagation - Messages State Stats
    • Number of Ready Messages
    • Number of Waiting Messages
    • Streams Prop - (%) Messages in Waiting State
  • Streams Propagation - Queue Propagation
    • Message Propagation Rate (per Sec)
    • Rate of KBytes Propagated (per Sec)
    • Total Number of KBytes Propagated
    • Total Number of Messages Propagated
  • Streams Propagation Aborted
    • Streams Propagation Process Aborted
  • System Response Time Per Call
    • Response Time (centi-seconds per call)
  • System Time Model
  • Tablespace Allocation
    • Tablespace Allocated Space (MB)
    • Tablespace Used Space (MB)
  • Tablespaces Full
    • Tablespace Free Space (MB)
    • Tablespace Space Used (%)
  • Tablespaces Full (Temp)
    • Tablespace Free Space (MB) (Temp)
    • Tablespace Space Used (%) (Temp)
  • Tablespaces Full (Undo)
    • Tablespace Free Space (MB) (Undo)
    • Tablespace Space Used (%) (Undo)
  • Temporary File Status
    • 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)
  • Top Wait Events
  • Total Objects by Schema
    • Total Object Count
  • Total Tables by Schema
    • Total Table Count
  • Unusable Indexes
    • Unusable Index Count
  • Unusable Indexes by Schema
    • Unusable Index Count by Schema
  • User Audit
    • Audited User
    • Audited User - Host
    • Audited User Session Count
  • User Block
    • Blocking Session Count
  • User Block Chain
    • Blocking Session Count
    • Blocking Session DB Time
  • User Locks
    • Maximum Blocked DB Time (seconds)
    • Maximum Blocked Session Count
  • User-Defined SQL
    • User-Defined Numeric Metric
    • User-Defined String Metric
  • Wait Bottlenecks
    • Active Sessions Using CPU
    • Active Sessions Waiting: I/O
    • Active Sessions Waiting: Other
    • Average Instance CPU (%)
    • Host CPU Utilization (%)
    • Wait Time (%)
  • Waits by Wait Class
    • Average Users Waiting Count
    • Database Time Spent Waiting (%)
• 2 Cluster Database
  • Archive Area
    • Archive Area Used (%)
    • Archive Area Used (KB)
    • Free Archive Area (KB)
    • Total Archive Area (KB)
  • Availability Notifications (Server Generated Alert)
  • Data Guard Fast-Start Failover
  • Data Guard Fast-Start Failover Observer – Oracle Database 11gR2 to 18c
    • Observer Status
  • Data Guard Fast-Start Failover Observers – Oracle Database 19c and later
  • Data Guard Performance
    • Apply Lag (seconds)
    • Estimated Failover Time (seconds)
    • Redo Apply Rate (KB/second)
    • Redo Generation Rate (KB/second)
    • Transport Lag (seconds)
    • Transport Lag Data Refresh Time
  • Data Guard Status
    • Data Guard Status
  • Database Cardinality
    • Open Instance Count
  • Database Job Status
    • Broken Job Count
    • Failed Job Count
  • Database Scheduler Jobs
    • Elapsed Running Time (in Minutes)
    • Failure Count
    • State
  • Database Wait Bottlenecks
    • Active Sessions Using CPU
    • Active Sessions Waiting: I/O
    • Active Sessions Waiting: Other
    • Average Database CPU (%)
    • Host CPU Utilization (%)
    • Load Average
    • Maximum CPU
    • Wait Time (%)
  • Database Vault Attempted Violations - Command Rules
    • Database Vault Attempted Violations Count - Command Rules
  • Database Vault Attempted Violations - Realms
    • Database Vault Attempted Violations Count - Realms
  • Database Vault Configuration Issues - Realms
    • Database Vault Configuration Issues Count - Realms
  • Database Vault Configuration Issues - Command Rules
    • DV (Command Rule) - Configuration Issue Count
  • Database Vault Policy Changes
    • Database Vault Policy Changes Count
  • Datafile Allocation
  • Deferred Transactions
    • Deferred Transaction Count
    • Deferred Transaction Error Count
  • Exadata Module Version Failure
    • Error Count
  • Failed Logins
    • Failed Login Count
  • Fast Recovery
    • Fast Recovery Area
    • Fast Recovery Area Size
    • Flashback On
    • Log Mode
    • Non-Reclaimable Fast Recovery Area (%)
    • Oldest Flashback Time
    • Reclaimable Fast Recovery Area (%)
    • Usable Fast Recovery Area (%)
  • Fragmented Text Indexes
    • Fragmented Text Index count
    • Fragmented Text Index count crossing critical threshold
    • Fragmented Text Index count crossing warning threshold
  • 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 Object Count
  • Invalid Objects by Schema
    • Invalid Object Count 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
  • PDB Mode (All Pluggable Databases)
  • Monitoring User Account
    • Monitoring User Connectivity Issue
    • Monitoring User Expiry
    • Database Monitoring User Privileges Check
  • QoS Management - Performance Satisfaction
    • Negative PSM Duration (seconds)
  • Recovery
    • Corrupt Data Block Count
    • Missing Media File Count
  • Recovery Area
    • Recovery Area Free Space (%)
    • Recovery Area Used Space (%)
  • SCN Growth Statistics
    • SCN Health
  • SCN Max Statistics
    • Max SCN Jump in one second (last 24 hours)
  • Segment Advisor Recommendations
    • Number of recommendations
  • Session Suspended
    • Session Suspended by Data Object Limitation
    • Session Suspended by Quota Limitation
    • Session Suspended by Rollback Segment Limitation
    • Session Suspended by Tablespace Limitation
  • Snapshot Too Old
    • Snapshot Too Old due to Rollback Segment Limit
    • Snapshot Too Old due to Tablespace Limit
  • Space Usage by Buffered Queues
    • Queue Size (MB)
    • Space Usage of Buffered Queue With Respect to Streams Pool Size (%)
  • Streams Apply Queue - Buffered
    • Streams Apply - (%)Spilled Messages
  • Streams Apply Queue - Persistent
    • Streams Apply - (%)Messages in Waiting State
  • Streams Apply Reader Statistics
    • Rate at Which Messages Are Getting Spilled (Per Sec)
  • Streams Capture Queue Statistics
    • Streams Capture - (%)Spilled Messages
  • Streams Latency and Throughput
    • Latency
    • Throughput (per sec)
  • Streams Processes Count
    • Apply Processes Having Errors
    • Capture Processes Having Errors
    • Number of Apply Processes
    • Number of Capture Processes
    • Number of Propagation Jobs
    • Propagation Errors
  • Streams Propagation - Message State Stats
    • Streams Prop - (%)Messages in Waiting State
  • Suspended Session
    • Suspended Session Count
  • Tablespace Allocation
    • Tablespace Allocated Space (MB)
    • Tablespace Used Space (MB)
  • Tablespaces Full
    • Tablespace Free Space (MB)
    • Tablespace Space Used (%)
  • Tablespaces Full (dictionary managed)
    • Tablespace Free Space (MB) (dictionary managed)
    • Tablespace Space Used (%) (dictionary managed)
  • Tablespaces With Problem Segments
    • Segments Approaching Maximum Extents Count
    • Segments Not Able to Extend Count
  • Temporary File Status
    • Temporary File Id
  • Top Wait Events
  • Total Objects by Schema
    • Total Object Count
  • Total Tables by Schema
    • Total Table Count
  • Unusable Indexes
    • Unusable Index Count
  • Unusable Indexes by Schema
    • Unusable Index Count by Schema
  • User Block
    • Blocking Session Count
  • User Locks
    • Maximum Blocked DB Time (seconds)
    • Maximum Blocked Session Count
• 3 Far Sync Instance
• 4 Listener
  • General Status
    • Alias
    • Security
    • SID List
    • SNMP Status
    • Start Date
    • TNS Address
    • Trace Level
    • Version
  • Listener Ports
  • Listener Services
  • Load
    • Connections Established
    • Connections Established (per min)
    • Connections Refused
    • Connections Refused (per min)
  • Response
    • Response Time (msec)
    • Status
  • TNS Errors
    • TNSMsg
• 5 Pluggable Database
  • Database Feature Usage
    • Count
    • Currently Used
    • DBID
    • Detected Usages
    • Feature Info
    • Feature Name
    • First Usage Date
    • Last Sample Date
    • Last Sample Period
    • Last Usage Date
    • Total Samples
    • Version
  • Datafiles
    • Autoextensible
    • Datafile Name
    • File Size
    • Initial File Size
    • Increment By
    • Max File Size
    • Status
    • Storage Entity
    • Tablespace
  • Database Job Status
    • Broken Job Count
    • Failed Job Count
  • Database Scheduler Jobs
    • Elapsed Running Time (in Minutes)
    • Failure Count
    • State
  • Database Services
    • Service CPU Time (per user call) (microseconds)
    • Service Response Time (per user call) (microseconds)
  • Datafile Allocation
  • Failed Logins
    • Failed Login Count
  • Invalid Objects
    • Total Invalid Object Count
  • Invalid Objects by Schema
    • Owner's Invalid Object Count
  • 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
  • PDB Mode
  • Resource Usage
  • Response
    • State
    • Status
    • ORA- Error
  • Rollback Segments
    • Name
    • Aveactive
    • Aveshrink
    • Extents
    • Hwmsize
    • Initial Size
    • Maximum Size
    • Minimum Extents
    • Next Size
    • Optsize
    • Pct Increase
    • Size
    • Shrinks
    • Status
    • Tablespace Name
    • Wraps
  • Segment Advisor Recommendations
    • Number of recommendations
  • Shard Apply Lag
  • Shard Replication Units
  • Shard Transport Lag
  • Tablespaces
    • Allocation Type
    • Big File
    • Block Size
    • Extent Management
    • Increment By
    • Initial Ext Size
    • Logging
    • Max Extents
    • Minimum Extent Size
    • Minimum Extents
    • Next Extent
    • Segment Space Management
    • Size
    • Status
    • Tablespace Name
    • Type
    • Used Size(B)
    • Tablespace Used Space (MB)
  • Tablespace Allocation
    • Tablespace Allocated Space (MB)
    • Tablespace Used Space (MB)
  • Tablespaces Full
    • Tablespace Free Space (MB)
    • Tablespace Space Used (%)
  • Tablespaces Full (Temp)
    • Tablespace Free Space (MB) (Temp)
    • Tablespace Space Used (%) (Temp)
  • Temporary File Status
    • File Name
    • Status
    • Temporary File Id
  • Total Objects by Schema
    • Total Object Count
  • Total Tables by Schema
    • Total Table Count
  • Wait Count
    • Active Sessions: CPU
    • Active Sessions: I/O
    • Active Sessions: Other
• 6 Autonomous Database
• 7 Global Data Services
  • Global Service Manager
    • Shard Global Service Performance
    • Load
    • General Status
  • Global Data Service Pool
    • Global Service Status
• 8 Globally Distributed Database
  • Shard Director
    • Global Service Performance
    • Load
    • General Status
  • Chunk Performance
  • Response
  • Service Distribution
  • Service Status
  • Shard Chunk Size (GB)
  • Shard Global Service Performance
  • Shard Replication Units Summary
  • Shard Size (GB)
  • Shard Status Details
  • Shard Tablespace Summary
  • Unique Keys Count