Activity Summary (PD_PDAS)

Function

The Activity Summary (PD_PDAS) record stores performance data indicating the operating status (at a specific point in time) of the Oracle system.

Default and changeable values

ItemDefault valueChangeable
Collection Interval300Y
Collection Offset30Y
LogNoY
LOGIF(Blank)Y

ODBC key fields

None

Lifetime

From the creation to the deletion of an Oracle instance

Record size

Fields

PFM - View name
(PFM - Manager name)
DescriptionSummaryFormatDeltaSupported versionData source
Active Transactions
(ACTIVE_TRANSACTIONS)
Number of active transactions in active sessions--longNoAllSUM(V$ROLLSTAT.XACTS)
Avg Wait
(AVERAGE_WAIT)
Average wait time for all events in all sessions--ulongNoAllAVG(V$SESSION_EVENT.AVERAGE_WAIT)
Avg Wait String
(AVERAGE_WAIT_STRING)
Average wait time for all events in all sessions (character string)--string(20)NoAllAVG(V$SESSION_EVENT.AVERAGE_WAIT)
Cursor Open Hit %
(CURSOR_OPEN_HIT_PERCENTAGE)
Percentage ratio of open cursors that were found during cursor search--doubleNoAllV$SYSTEM_CURSOR_CACHE.HIT_RATIO * 100
Cursor Open Hits
(CURSOR_OPEN_HITS)
Total cursor open hits--ulongNoAllV$SYSTEM_CURSOR_CACHE.HITS
Cursor Opens
(CURSOR_OPENS)
Total cursor opens--ulongNoAllV$SYSTEM_CURSOR_CACHE.OPENS
DML Locks %
(PERCENT_DML_LOCKS)
Percentage ratio of DML locks to the DML_LOCKS parameter value in the init.ora file--doubleNoAll(COUNT(DBA_DML_LOCKS) / init.ora DML_LOCKS) * 100
DML Locks Held
(DML_LOCKS_HELD)
Number of current DML locks--longNoAllCOUNT(DBA_DML_LOCKS)
Enqueue Resources %
(PERCENT_ENQUEUE_RESOURCES)
Percentage ratio of locks to the value of the ENQUEUE_RESOURCES parameter in the init.ora file
Always 0 if the monitoring target is Oracle 10g Release2 or later.
--doubleNoAll(COUNT(V$LOCK) where V$LOCK.LMODE is NOT NULL / init.ora ENQUEUE_RESOURCES) * 100
Locks Held
(LOCKS_HELD)
Number of current locks--longNoAllCOUNT(V$LOCK) where V$LOCK.LMODE is NOT NULL
Open Cursors
(OPEN_CURSORS)
Number of current open cursors--longNoAllCOUNT(V$OPEN_CURSOR)
Open Cursors %
(PERCENT_OPEN_CURSORS)
Percentage ratio of open cursors to the value of the OPEN_CURSORS parameter in the init.ora file--doubleNoAll(COUNT(V$OPEN_CURSOR) / init.ora OPEN_CURSORS) * 100
Processes
(PROCESSES)
Number of current Oracle processes--ulongNoAllCOUNT(V$PROCESS)
Processes %
(PERCENT_PROCESSES)
Percentage ratio of processes to the value of the PROCESSES parameter in the init.ora file--doubleNoAll(COUNT(V$PROCESS) / init.ora PROCESSES) * 100
Record Time
(RECORD_TIME)
Collection termination time for the performance data stored in the record--time_tNoAllRemote Monitor Collector
Record Type
(INPUT_RECORD_TYPE)
Record name (always PDAS)--string(4)NoAllRemote Monitor Collector
Session Events
(SESSION_EVENTS)
Number of events queued by sessions--ulongNoAllCOUNT(V$SESSION_EVENT)
Session Waits
(SESSION_WAITS)
Number of session waits--ulongNoAllCOUNT(V$SESSION_WAIT)
Sessions
(SESSIONS)
Number of current sessions--ulongNoAllCOUNT(V$SESSION)
Sessions %
(PERCENT_SESSIONS)
Percentage ratio of sessions to the value of the SESSIONS parameter in the init.ora file--doubleNoAll(COUNT(V$SESSION) / init.ora SESSIONS) * 100
Start Time
(START_TIME)
Collection start time for the performance data stored in the record--time_tNoAllRemote Monitor Collector
System Sessions
(SESSIONS_SYSTEM)
Number of current system sessions--ulongNoAllCOUNT(V$SESSION) where V$SESSION.TYPE<>'USER'
Table Accesses
(TABLE_ACCESSES)
Number of current table accesses--longNoAllCOUNT(V$ACCESS)
Time Waited
(TIME_WAITED)
Total length of time that all sessions queued all events--doubleNoAllSUM(V$SESSION_EVENT.TIME_WAITED)
Time Waited String
(TIME_WAITED_STRING)
Total length of time that all sessions queued all events (character string)--string(20)NoAllSUM(V$SESSION_EVENT.TIME_WAITED)
Total Timeouts
(TOTAL_TIMEOUTS)
Total number of timeouts for all events in all sessions--ulongNoAllSUM(V$SESSION_EVENT.TOTAL_TIMEOUTS)
Total Waits
(TOTAL_WAITS)
Number of waits for all events in all sessions--ulongNoAllSUM(V$SESSION_EVENT.TOTAL_WAITS)
Transactions %
(PERCENT_TRANSACTIONS)
Percentage ratio of the number of transactions to the value of the TRANSACTIONS parameter in the init.ora file--doubleNoAll(SUM(V$ROLLSTAT.XACTS) / init.ora TRANSACTION) * 100
User Sessions
(SESSIONS_USER)
Number of current user sessions--ulongNoAllCOUNT(V$SESSION) where V$SESSION.TYPE = 'USER'
VA DeviceID
(VADEVICEID)
Device ID of virtual agent.--string(256)NoAllRemote Monitor Collector