Session Event Interval (PI_PIEV)
- Organization of this page
Function
The Session Event Interval (PI_PIEV) record stores performance data, taken at specific intervals, about session events. PFM - Agent for Oracle creates one record for each event the session waits for. This is a multi-instance record.
When Log is set to Yes, if you collect history over a long period of time, because of the short lifetime, it is not summarized in units of years or months. All instances are retained, resulting in a bloated store database. In addition, when the collected history is summarized, more memory is used than necessary. The memory shortage might cause monitoring to stop. If you want to collect history over a long period of time, use the Session Event (PD_PDEV) record for monitoring.
Default and changeable values
Item |
Default value |
Changeable |
---|---|---|
Collection Interval |
600 |
Y |
Collection Offset |
0 |
Y |
Log |
No |
Y |
LOGIF |
(Blank) |
Y |
Over 10 Sec Collection Time |
No |
N |
ODBC key fields
-
PI_PIEV_SID
-
PI_PIEV_EVENT
Lifetime
From the start to the end of a session event
Record size
-
Fixed part: 678 bytes
-
Variable part: 289 bytes
Fields
PFM - View name (PFM - Manager name) |
Description |
Summary |
Format |
Delta |
Supported version |
Data source |
---|---|---|---|---|---|---|
Avg Wait (AVERAGE_WAIT) |
Average time of all events the session is waiting for in hundredths of a second (to collect the value of this field, the TIMED_STATISTICS parameter must be set to TRUE in the init.ora file) #2 |
AVG |
double |
No |
All |
V$SESSION_EVENT.AVERAGE_WAIT |
Avg Wait String (AVERAGE_WAIT_STRING) |
Average time (character string) of all events the session is waiting for in seconds (to collect the value of this field, the TIMED_STATISTICS parameter must be set to TRUE in the init.ora file)#1 |
COPY |
string(21) |
No |
All |
V$SESSION_EVENT.AVERAGE_WAIT / 100 |
Event (EVENT) |
Name of the event the session is waiting for#1 |
COPY |
string(64) |
No |
All |
V$SESSION_EVENT.EVENT |
Program (PROGRAM) |
Name of the program being executed#1 |
COPY |
string(64) |
No |
All |
V$SESSION.PROGRAM where V$SESSION_EVENT.SID = V$SESSION.SID |
Record Time (RECORD_TIME) |
Collection termination time for the performance data stored in the record#1 |
COPY |
time_t |
No |
All |
Agent Collector |
Record Type (INPUT_RECORD_TYPE) |
Record name (always PIEV)#1 |
COPY |
string(4) |
No |
All |
Agent Collector |
SID (SID) |
Session ID#1 |
COPY |
ulong |
No |
All |
V$SESSION_EVENT.SID |
Start Time (START_TIME) |
Collection start time for the performance data stored in the record#1 |
COPY |
time_t |
No |
All |
Agent Collector |
Time Waited (TIME_WAITED) |
Total time the session was waiting for event in hundredths of a second (to collect the value of this field, the TIMED_STATISTICS parameter must be set to TRUE in the init.ora file)#2 |
AVG |
double |
Yes |
All |
V$SESSION_EVENT.TIME_WAITED |
Time Waited String (TIME_WAITED_STRING) |
Total time the session was waiting for event in seconds (to collect the value of this field, the TIMED_STATISTICS parameter must be set to TRUE in the init.ora file)#1 |
COPY |
string(21) |
No |
All |
V$SESSION_EVENT.TIME_WAITED / 100 |
Total Timeouts (TOTAL_TIMEOUTS) |
Total number of timeouts for the session event#2 |
AVG |
double |
Yes |
All |
V$SESSION_EVENT.TOTAL_TIMEOUTS |
Total Waits (TOTAL_WAITS) |
Session's total number of waits for the events#2 |
AVG |
double |
Yes |
All |
V$SESSION_EVENT.TOTAL_WAITS |
User (USERNAME) |
Oracle user name#1 |
COPY |
string(30) |
No |
All |
V$SESSION.USERNAME where V$SESSION_EVENT.SID = V$SESSION.SID |