![[Contents]](FIGURE/CONTENT.GIF)
Job Management Partner 1 Version 10, Job Management Partner 1/Performance Management - Remote Monitor for Oracle Description, User's Guide and Reference
![[Glossary]](FIGURE/GLOSS.GIF)
![[Index]](FIGURE/INDEX.GIF)
![[Back]](FIGURE/FRONT.GIF)
![[Next]](FIGURE/AFTER.GIF)
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
| Item | Default value | Changeable |
|---|---|---|
| Collection Interval | 300 | Y |
| Collection Offset | 25 | Y |
| Log | No | Y |
| 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) |
Description | Summary | Format | Delta | Supported version | Data source |
|---|---|---|---|---|---|---|
| Block Changes (BLOCK_CHANGES) |
Number of times changes were made to session blocks#2 | AVG | double | Yes | All | V$SESS_IO.BLOCK_CHANGES |
| Block Gets (BLOCK_GETS) |
Number of times session blocks were acquired#2 | AVG | double | Yes | All | V$SESS_IO.BLOCK_GETS |
| Cache Hit % (CACHE_HIT_PERCENTAGE) |
Buffer cache usage#2 | AVG | double | No | All | 100 * (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#2 | AVG | double | Yes | All | V$SESS_IO.CONSISTENT_CHANGES |
| Consistent Gets (CONSISTENT_GETS) |
Number of times a consistent acquisition was made in the session#2 | AVG | double | Yes | All | V$SESS_IO.CONSISTENT_GETS |
| OS PID (PID) |
Client process ID of the OS#1 | COPY | string(30) | No | All | V$SESSION.PROCESS |
| Physical Reads (PHYSICAL_READS) |
Number of physical read operations in the session#2 | AVG | double | Yes | All | V$SESS_IO.PHYSICAL_READS |
| Record Time (RECORD_TIME) |
Collection termination time for the performance data stored in the record#1 | COPY | time_t | No | All | Remote Monitor Collector |
| Record Type (INPUT_RECORD_TYPE) |
Record name (always PIIO)#1 | COPY | string(4) | No | All | Remote Monitor Collector |
| SID (SID) |
Session ID#1 | COPY | ulong | No | All | V$SESS_IO.SID |
| Start Time (START_TIME) |
Collection start time for the performance data stored in the record#1 | COPY | time_t | No | All | Remote Monitor Collector |
| User (USERNAME) |
User name of the session#1 | COPY | string(30) | No | All | V$SESSION.USERNAME |
| VA DeviceID (VADEVICEID) |
Device ID of virtual agent. | -- | string(256) | No | All | Remote Monitor Collector |
Copyright (C) 2013, Hitachi, Ltd.
Copyright (C) 2013, Hitachi Solutions, Ltd.