Job Management Partner 1 Version 10, Job Management Partner 1/Performance Management - Remote Monitor for Oracle Description, User's Guide and Reference

[Contents][Glossary][Index][Back][Next]

Database Activity Status Detail(5.0)

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