System Overview(5.0)(real-time report on the overall status of instance)

Overview

The System Overview(5.0) report displays in real-time the main performance data indicating the overall status of an instance.

Storage location

Reports/RM Oracle/Status Reporting/Real-Time/

Record

System Stat Summary (PD)

Fields

Field nameDescription
Cache Hit %Buffer cache usage. To display the Physical I/O - Top 10 Sessions(5.0) report, choose this field.
Continued Row %Percentage of the rows that are longer than one block or moved (continued rows or moved rows)
Current LogonsNumber of logons to the Oracle Database during data collection
DeadlocksNumber of process deadlocks caused by enqueuing resulting from manipulation of DML
Disk SortsNumber of disk sort operations. To display the Disk Sorts - Top 10 Sessions(5.0) report, choose this field.
Lock RequestsNumber of lock requests. To display the Lock Usage - Top 10 Sessions(5.0) report, choose this field.
Memory SortsNumber of memory sort operations. To display the Disk Sorts - Top 10 Sessions(5.0) report, choose this field.
Session CPU UsageCPU time used in 1/100 seconds
Session PGA MemoryPGA size used by active sessions during data collection. To display the Memory Usage - Top 10 Sessions(5.0) report, choose this field.
Session UGA MemoryUGA size used by active sessions. To display the Memory Usage - Top 10 Sessions(5.0) report, choose this field.
Sort Overflow %Percentage of sort operations using temporary segments. To display the Disk Sorts - Top 10 Sessions(5.0) report, choose this field.
Total SQL ExecutionsNumber of SQL statement executions
User CallsNumber of requests from application to database that have been processed
User CommitsNumber of transactions. To display the Longest Transactions - Top 10 Sessions(5.0) report, choose this field.
User RollbacksNumber of rollbacks

Drilldown reports (report level)

Report nameDescription
Database Activity Status(5.0)Displays instance activity status.
Database Space Overview(5.0)Displays usage information about tablespaces and data files for the instance.
Error LogDisplays the error messages that have been issued since the agent started.
Server Configuration StatusDisplays all setup parameter information for the server.
Tablespace StatusDisplays all tablespace information.

Drilldown reports (field level)

Report nameDescription
Disk Sorts - Top 10 Sessions(5.0)Displays the top 10 sessions in terms of the frequency of disk sort operations. To display this report, choose the following fields:
  • Disk Sorts
  • Memory Sorts
  • Sort Overflow %
Lock Usage - Top 10 Sessions(5.0)Displays the top 10 sessions in terms of the number of locks held. To display this report, choose the Lock Requests field.
Longest Transactions - Top 10 Sessions(5.0)Displays the top 10 transactions in terms of the length of a transaction that placed another session in wait status. To display this report, choose the User Commits field.
Memory Usage - Top 10 Sessions(5.0)Displays the top 10 sessions in terms of memory usage. To display this report, choose the Session PGA Memory or Session UGA Memory field.
Physical I/O - Top 10 Sessions(5.0)Displays the top 10 sessions in terms of concentration of I/O operations. To display this report, choose the Cache Hit % field.