Session I/O Interval (PI_PIIO)

Function

The Session I/O Interval (PI_PIIO) record stores performance data, taken at specific intervals, about input/output of all active sessions. PFM - RM for Oracle creates one record for each active session. This is a multi-instance record.

Default and changeable values

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

ODBC key fields

PI_PIIO_SID

Lifetime

From the start to the end of a session

Record size

Fields

PFM - View name
(PFM - Manager name)
DescriptionSummaryFormatDeltaSupported versionData source
Block Changes
(BLOCK_CHANGES)
Number of times changes were made to session blocks#2AVGdoubleYesAllV$SESS_IO.BLOCK_CHANGES
Block Gets
(BLOCK_GETS)
Number of times session blocks were acquired#2AVGdoubleYesAllV$SESS_IO.BLOCK_GETS
Cache Hit %
(CACHE_HIT_PERCENTAGE)
Buffer cache usage#2AVGdoubleNoAll100 * (BLOCK_GETS + CONSISTENT_GETS - PHYSICAL_READS) / (BLOCK_GETS + CONSISTENT_GETS)
Consistent Changes
(CONSISTENT_CHANGES)
Number of times a consistent change was made in the session#2AVGdoubleYesAllV$SESS_IO.CONSISTENT_CHANGES
Consistent Gets
(CONSISTENT_GETS)
Number of times a consistent acquisition was made in the session#2AVGdoubleYesAllV$SESS_IO.CONSISTENT_GETS
OS PID
(PID)
Client process ID of the OS#1COPYstring(30)NoAllV$SESSION.PROCESS
Physical Reads
(PHYSICAL_READS)
Number of physical read operations in the session#2AVGdoubleYesAllV$SESS_IO.PHYSICAL_READS
Record Time
(RECORD_TIME)
Collection termination time for the performance data stored in the record#1COPYtime_tNoAllRemote Monitor Collector
Record Type
(INPUT_RECORD_TYPE)
Record name (always PIIO)#1COPYstring(4)NoAllRemote Monitor Collector
SID
(SID)
Session ID#1COPYulongNoAllV$SESS_IO.SID
Start Time
(START_TIME)
Collection start time for the performance data stored in the record#1COPYtime_tNoAllRemote Monitor Collector
User
(USERNAME)
User name of the session#1COPYstring(30)NoAllV$SESSION.USERNAME
VA DeviceID
(VADEVICEID)
Device ID of virtual agent.--string(256)NoAllRemote Monitor Collector