Hitachi

JP1 Version 12 JP1/Performance Management - Agent Option for Oracle Description, User's Guide and Reference


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

Lifetime

From the start to the end of a session event

Record size

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