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
Item | Default value | Changeable |
---|---|---|
Collection Interval | 300 | Y |
Collection Offset | 30 | Y |
Log | No | Y |
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) | Description | Summary | Format | Delta | Supported version | Data source |
---|---|---|---|---|---|---|
Active Transactions (ACTIVE_TRANSACTIONS) | Number of active transactions in active sessions | -- | long | No | All | SUM(V$ROLLSTAT.XACTS) |
Avg Wait (AVERAGE_WAIT) | Average wait time for all events in all sessions | -- | ulong | No | All | AVG(V$SESSION_EVENT.AVERAGE_WAIT) |
Avg Wait String (AVERAGE_WAIT_STRING) | Average wait time for all events in all sessions (character string) | -- | string(20) | No | All | AVG(V$SESSION_EVENT.AVERAGE_WAIT) |
Cursor Open Hit % (CURSOR_OPEN_HIT_PERCENTAGE) | Percentage ratio of open cursors that were found during cursor search | -- | double | No | All | V$SYSTEM_CURSOR_CACHE.HIT_RATIO * 100 |
Cursor Open Hits (CURSOR_OPEN_HITS) | Total cursor open hits | -- | ulong | No | All | V$SYSTEM_CURSOR_CACHE.HITS |
Cursor Opens (CURSOR_OPENS) | Total cursor opens | -- | ulong | No | All | V$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 | -- | double | No | All | (COUNT(DBA_DML_LOCKS) / init.ora DML_LOCKS) * 100 |
DML Locks Held (DML_LOCKS_HELD) | Number of current DML locks | -- | long | No | All | COUNT(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. | -- | double | No | All | (COUNT(V$LOCK) where V$LOCK.LMODE is NOT NULL / init.ora ENQUEUE_RESOURCES) * 100 |
Locks Held (LOCKS_HELD) | Number of current locks | -- | long | No | All | COUNT(V$LOCK) where V$LOCK.LMODE is NOT NULL |
Open Cursors (OPEN_CURSORS) | Number of current open cursors | -- | long | No | All | COUNT(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 | -- | double | No | All | (COUNT(V$OPEN_CURSOR) / init.ora OPEN_CURSORS) * 100 |
Processes (PROCESSES) | Number of current Oracle processes | -- | ulong | No | All | COUNT(V$PROCESS) |
Processes % (PERCENT_PROCESSES) | Percentage ratio of processes to the value of the PROCESSES parameter in the init.ora file | -- | double | No | All | (COUNT(V$PROCESS) / init.ora PROCESSES) * 100 |
Record Time (RECORD_TIME) | Collection termination time for the performance data stored in the record | -- | time_t | No | All | Remote Monitor Collector |
Record Type (INPUT_RECORD_TYPE) | Record name (always PDAS) | -- | string(4) | No | All | Remote Monitor Collector |
Session Events (SESSION_EVENTS) | Number of events queued by sessions | -- | ulong | No | All | COUNT(V$SESSION_EVENT) |
Session Waits (SESSION_WAITS) | Number of session waits | -- | ulong | No | All | COUNT(V$SESSION_WAIT) |
Sessions (SESSIONS) | Number of current sessions | -- | ulong | No | All | COUNT(V$SESSION) |
Sessions % (PERCENT_SESSIONS) | Percentage ratio of sessions to the value of the SESSIONS parameter in the init.ora file | -- | double | No | All | (COUNT(V$SESSION) / init.ora SESSIONS) * 100 |
Start Time (START_TIME) | Collection start time for the performance data stored in the record | -- | time_t | No | All | Remote Monitor Collector |
System Sessions (SESSIONS_SYSTEM) | Number of current system sessions | -- | ulong | No | All | COUNT(V$SESSION) where V$SESSION.TYPE<>'USER' |
Table Accesses (TABLE_ACCESSES) | Number of current table accesses | -- | long | No | All | COUNT(V$ACCESS) |
Time Waited (TIME_WAITED) | Total length of time that all sessions queued all events | -- | double | No | All | SUM(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) | No | All | SUM(V$SESSION_EVENT.TIME_WAITED) |
Total Timeouts (TOTAL_TIMEOUTS) | Total number of timeouts for all events in all sessions | -- | ulong | No | All | SUM(V$SESSION_EVENT.TOTAL_TIMEOUTS) |
Total Waits (TOTAL_WAITS) | Number of waits for all events in all sessions | -- | ulong | No | All | SUM(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 | -- | double | No | All | (SUM(V$ROLLSTAT.XACTS) / init.ora TRANSACTION) * 100 |
User Sessions (SESSIONS_USER) | Number of current user sessions | -- | ulong | No | All | COUNT(V$SESSION) where V$SESSION.TYPE = 'USER' |
VA DeviceID (VADEVICEID) | Device ID of virtual agent. | -- | string(256) | No | All | Remote Monitor Collector |