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 nameDescription
Active TransactionsNumber 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 HeldNumber of current DML locks
Open CursorsNumber of current open cursors
Open Cursors %Percentage of open cursors to the OPEN_CURSORS parameter in the init.ora initialization parameter file
ProcessesNumber of current Oracle processes
Processes %Percentage of processes to the PROCESSES parameter in the init.ora initialization parameter file
SessionsNumber 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