Hitachi

JP1 Version 12 JP1/Performance Management - Agent Option for Oracle Description, User's Guide and Reference


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

Organization of this page

Overview

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

Storage location

Reports/Oracle/Status Reporting/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(9.1) 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(9.1) report, choose this field.

Lock Requests

Number of lock requests. To display the Lock Usage - Top 10 Sessions(9.1) report, choose this field.

Memory Sorts

Number of memory sort operations. To display the Disk Sorts - Top 10 Sessions(9.1) 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(9.1) report, choose this field.

Session UGA Memory

UGA size used by active sessions. To display the Memory Usage - Top 10 Sessions(9.1) report, choose this field.

Sort Overflow %

Percentage of sort operations using temporary segments. To display the Disk Sorts - Top 10 Sessions(9.1) report, choose this field.

Total SQL Executions

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(9.1) report, choose this field.

User Rollbacks

Number of rollbacks

Drilldown reports (report level)

Report name

Description

Database Activity Status(8.0)

Displays instance activity status.

Database Space Overview(8.0)

Displays usage information about tablespaces and data files for the instance.

Error Log(9.1)

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(9.1)

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(9.1)

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(9.1)

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(9.1)

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(9.1)

Displays the top 10 sessions in terms of concentration of I/O operations. To display this report, choose the Cache Hit % field.