Activity Summary (PD_PDAS)
- Organization of this page
Function
The Activity Summary (PD_PDAS) record stores performance data indicating the operating status (at a specific point in time) of the Oracle system.
- Notes
-
If the monitoring target is Oracle Database 12c Release 2 or later in a CDB configuration, some fields in this record collect common performance data for database instances. For details, see the descriptions of each field.
Default and changeable values
|
Item |
Default value |
Changeable |
|---|---|---|
|
Collection Interval |
300 |
Y |
|
Collection Offset |
30 |
Y |
|
Log |
No |
Y |
|
LOGIF |
(Blank) |
Y |
|
Over 10 Sec Collection Time |
No |
N |
ODBC key fields
None
Lifetime
From the creation to the deletion of an Oracle instance
Record size
-
Fixed part: 868 bytes
-
Variable part: 0 bytes
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#8 |
-- |
long |
No |
All |
SUM(V$ROLLSTAT.XACTS) |
|
Avg Wait (AVERAGE_WAIT) |
Average wait time for all events in all sessions. In centiseconds (1/100 of a second).#7 |
-- |
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). In seconds.#7 |
-- |
string(30) |
No |
All |
AVG(V$SESSION_EVENT.AVERAGE_WAIT) / 100 |
|
Cursor Open Hit % (CURSOR_OPEN_HIT_PERCENTAGE) |
Percentage ratio of open cursors that were found during cursor search#9 |
-- |
double |
No |
All |
V$SYSTEM_CURSOR_CACHE.HIT_RATIO * 100 |
|
Cursor Open Hits (CURSOR_OPEN_HITS) |
Total cursor open hits#9 |
-- |
ulong |
No |
All |
V$SYSTEM_CURSOR_CACHE.HITS |
|
Cursor Opens (CURSOR_OPENS) |
Total cursor opens#9 |
-- |
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#7 |
-- |
double |
No |
All |
(COUNT(DBA_DML_LOCKS) / init.ora DML_LOCKS) * 100 |
|
DML Locks Held (DML_LOCKS_HELD) |
Number of current DML locks#7 |
-- |
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#7 |
-- |
long |
No |
All |
COUNT(V$LOCK) where V$LOCK.LMODE is NOT NULL |
|
Open Cursors (OPEN_CURSORS) |
Number of current open cursors#8 |
-- |
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#8 |
-- |
double |
No |
All |
(COUNT(V$OPEN_CURSOR) / init.ora OPEN_CURSORS) * 100 |
|
Processes (PROCESSES) |
Number of current Oracle processes#8 |
-- |
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#8 |
-- |
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 |
Agent Collector |
|
Record Type (INPUT_RECORD_TYPE) |
Record name (always PDAS) |
-- |
string(4) |
No |
All |
Agent Collector |
|
Session Events (SESSION_EVENTS) |
Number of events queued by sessions#7 |
-- |
ulong |
No |
All |
COUNT(V$SESSION_EVENT) |
|
Session Waits (SESSION_WAITS) |
Number of session waits#7 |
-- |
ulong |
No |
All |
COUNT(V$SESSION_WAIT) |
|
Sessions (SESSIONS) |
Number of current sessions#7 |
-- |
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#7 |
-- |
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 |
Agent Collector |
|
System Sessions (SESSIONS_SYSTEM) |
Number of current system sessions#7 |
-- |
ulong |
No |
All |
COUNT(V$SESSION) where V$SESSION.TYPE<>'USER' |
|
Table Accesses (TABLE_ACCESSES) |
Number of current table accesses#7 |
-- |
long |
No |
All |
COUNT(V$ACCESS) |
|
Time Waited (TIME_WAITED) |
Total length of time that all sessions queued all events. In centiseconds (1/100 of a second).#7 |
-- |
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). In seconds.#7 |
-- |
string(30) |
No |
All |
SUM(V$SESSION_EVENT.TIME_WAITED) / 100 |
|
Total Timeouts (TOTAL_TIMEOUTS) |
Total number of timeouts for all events in all sessions#7 |
-- |
ulong |
No |
All |
SUM(V$SESSION_EVENT.TOTAL_TIMEOUTS) |
|
Total Waits (TOTAL_WAITS) |
Number of waits for all events in all sessions#7 |
-- |
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#8 |
-- |
double |
No |
All |
(SUM(V$ROLLSTAT.XACTS) / init.ora TRANSACTION) * 100 |
|
User Sessions (SESSIONS_USER) |
Number of current user sessions#7 |
-- |
ulong |
No |
All |
COUNT(V$SESSION) where V$SESSION.TYPE = 'USER' |
- #7
-
Displays performance data for the PDBs that are being monitored and common performance data for database instances.
- #8
-
Displays performance data for the PDBs that are being monitored.
- #9
-
Displays performance data for the entire CDB.