System Overview(8.0)(real-time report on the general status of instance)
- Organization of this page
Overview
The System Overview(8.0) report displays in real-time the main performance data indicating the general status of an instance.
Storage location
Reports/Oracle/Troubleshooting/Real-Time/
Record
System Stat Summary (PD)
Fields
Field name |
Description |
---|---|
Cache Hit % |
Buffer cache usage. To display the Physical I/O - Top 10 Sessions(8.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 Logons |
Number of logons to the Oracle Database during data collection |
Deadlocks |
Number of process deadlocks caused by enqueuing resulting from manipulation of DML |
Disk Sorts |
Number of disk sort operations. To display the Disk Sorts - Top 10 Sessions(8.0) report, choose this field. |
Lock Requests |
Number of lock requests. To display the Lock Usage - Top 10 Sessions(8.0) report, choose this field. |
Memory Sorts |
Number of memory sort operations. To display the Disk Sorts - Top 10 Sessions(8.0) report, choose this field. |
Session CPU Usage |
CPU time used in 1/100 seconds |
Session PGA Memory |
PGA size used by active sessions during data collection. To display the Memory Usage - Top 10 Sessions(8.0) report, choose this field. |
Session UGA Memory |
UGA size used by active sessions. To display the Memory Usage - Top 10 Sessions(8.0) report, choose this field. |
Sort Overflow % |
Percentage of sort operations using temporary segments. To display the Disk Sorts - Top 10 Sessions(8.0) report, choose this field. |
Total SQL Executions |
Total number of SQL statement executions |
User Calls |
Number of requests from application to database that have been processed |
User Commits |
Number of transactions. To display the Longest Transactions - Top 10 Sessions(8.0) report, choose this field. |
User Rollbacks |
Number of rollbacks |
Drilldown reports (report level)
Report name |
Description |
---|---|
Database Activity Status(8.0) |
Displays the instance activity status. |
Database Space Overview(8.0) |
Displays usage information about tablespaces and data files for the instance. |
Error Log(8.0) |
Displays the error messages that have been issued since the agent started. |
Server Configuration Status(4.0) |
Displays all setup parameter information for the server. |
Tablespace Status(4.0) |
Displays all tablespace information. |
Drilldown reports (field level)
Report name |
Description |
---|---|
Disk Sorts - Top 10 Sessions(8.0) |
Displays the top 10 sessions in terms of the frequency of disk sort operations. To display this report, choose the following fields:
|
Lock Usage - Top 10 Sessions(8.0) |
Displays the top 10 sessions in terms of the number of locks held. To display this report, choose the Lock Requests field. |
Longest Transaction - Top 10 Sessions(8.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(8.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(8.0) |
Displays the top 10 sessions in terms of concentration of I/O operations. To display this report, choose the Cache Hit % field. |