Hitachi

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


Database Activity Status Detail(5.0)

Organization of this page

Overview

The Database Activity Status Detail(5.0) report displays in real-time details about the database activity status. This is a drilldown report.

Storage location

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

Record

Activity Summary (PD_PDAS)

Fields

Field name

Description

Active Transactions

Number of active transactions in active sessions

DML Locks %

Percentage of DML locks to the DML_LOCKS parameter in the init.ora initialization parameter file

DML Locks Held

Number of current DML locks

Open Cursors

Number of current open cursors

Open Cursors %

Percentage of open cursors to the OPEN_CURSORS parameter in the init.ora initialization parameter file

Processes

Number of current Oracle processes

Processes %

Percentage of processes to the PROCESSES parameter in the init.ora initialization parameter file

Sessions

Number of current sessions

Sessions %

Percentage of sessions to the SESSIONS parameter in the init.ora initialization parameter file

Transactions %

Percentage of transactions to the TRANSACTIONS parameter in the init.ora initialization parameter file