Job Management Partner 1 Version 10, Job Management Partner 1/Performance Management - Remote Monitor for Oracle Description, User's Guide and Reference
System Overview(5.0) (real-time report on the general status of instance)
Overview
The System Overview(5.0) report displays in real-time the main performance data indicating the general status of an instance.
Storage location
Reports/RM 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(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 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(5.0) report, choose this field. |
| Lock Requests | Number of lock requests. To display the Lock Usage - Top 10 Sessions(5.0) report, choose this field. |
| Memory Sorts | Number of memory sort operations. To display the Disk Sorts - Top 10 Sessions(5.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(5.0) report, choose this field. |
| Session UGA Memory | UGA 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 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(5.0) report, choose this field. |
| User Rollbacks | Number of rollbacks |
Drilldown reports (report level)
| Report name | Description |
|---|---|
| Database Activity Status(5.0) | Displays the instance activity status. |
| Database Space Overview(5.0) | Displays usage information about tablespaces and data files for the instance. |
| Error Log | Displays the error messages that have been issued since the agent started. |
| Server Configuration Status | Displays all setup parameter information for the server. |
| Tablespace Status | Displays all tablespace information. |
Drilldown reports (field level)
| Report name | Description |
|---|---|
| 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:
|
| 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 Transaction - 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. |
Copyright (C) 2013, Hitachi, Ltd.
Copyright (C) 2013, Hitachi Solutions, Ltd.