![[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)
Function
The Instance (PD_PDI) record stores performance data indicating the status (at a specific point in time) of an instance.
Default and changeable values
| Item | Default value | Changeable |
|---|---|---|
| Collection Interval | 600 | Y |
| Collection Offset | 50 | Y |
| Log | No | Y |
| LOGIF | (Blank) | Y |
ODBC key fields
None
Lifetime
From the creation to the deletion of an Oracle instance
Record size
Fields
| PFM - View name (PFM - Manager name) |
Description | Summary | Format | Delta | Supported version | Data source |
|---|---|---|---|---|---|---|
| Host (HOST) |
Name of the physical host connected to the running instance | -- | string(64) | No | All | V$INSTANCE.HOST_NAME |
| ORACLE_HOME (ORACLE_HOME) |
ORACLE_HOME environment variable | -- | string(255) | No | All | -- |
| ORACLE_SID (ORACLE_SID) |
ORACLE_SID environment variable | -- | string(30) | No | All | -- |
| Record Time (RECORD_TIME) |
Collection termination time for the performance data stored in the record | -- | time_t | No | All | Remote Monitor Collector |
| Record Type (INPUT_RECORD_TYPE) |
Record name (always PDI) | -- | string(4) | No | All | Remote Monitor Collector |
| Restricted Mode (RESTRICTED_MODE) |
This field is not supported. The value of this field is 1 if the instance is in restricted mode and 0 if the instance is not in restricted mode. |
-- | short | No | Not supported | V$INSTANCE.LOGINS |
| Session Current (SESSION_CURRENT) |
Current number of concurrent user sessions | -- | ulong | No | All | V$LICENSE.SESSIONS_CURRENT |
| Session Highwater (SESSION_HIGHWATER) |
Maximum number of concurrent user sessions since the instance started | -- | ulong | No | All | V$LICENSE.SESSIONS_HIGHWATER |
| Sessions Max (SESSIONS_MAX) |
Maximum number of concurrent user sessions permitted for the instance | -- | ulong | No | All | V$LICENSE.SESSIONS_MAX |
| Sessions Warning (SESSIONS_WARNING) |
Warning limit for the concurrent user sessions for the instance | -- | ulong | No | All | V$LICENSE.SESSIONS_WARNING |
| SGA Database Buffers (SGA_DATABASE_BUFFERS) |
Size of SGA database buffer in bytes | -- | double | No | All | V$SGA.VALUE where V$SGA.NAME = 'Database Buffers' |
| SGA Fixed Size (SGA_FIXED_SIZE) |
Size of SGA fixed memory in bytes | -- | double | No | All | V$SGA.VALUE where V$SGA.NAME = 'Fixed Size' |
| SGA Redo Buffers (SGA_REDO_BUFFERS) |
Size of SGA REDO buffer in bytes | -- | double | No | All | V$SGA.VALUE where V$SGA.NAME = 'Redo Buffers' |
| SGA Variable Size (SGA_VARIABLE_SIZE) |
Size of SGA variable memory in bytes | -- | double | No | All | V$SGA.VALUE where V$SGA.NAME = 'Variable Size' |
| Shutdown Pending (SHUTDOWN_PENDING) |
The value of this field is 1 if shutdown is on hold, and 0 if shutdown is not on hold. | -- | short | No | All | V$INSTANCE.SHUTDOWN_PENDING |
| Start Time (START_TIME) |
Collection start time for the performance data stored in the record | -- | time_t | No | All | Remote Monitor Collector |
| Startup Time (STARTUP_TIME) |
Start date and time | -- | string(20) | No | All | V$INSTANCE.STARTUP_TIME |
| Users Max (USERS_MAX) |
Maximum number of users permitted for the database | -- | ulong | No | All | V$LICENSE.USERS_MAX |
| VA DeviceID (VADEVICEID) |
Device ID of virtual agent. | -- | string(256) | No | All | Remote Monitor Collector |
| Version (VERSION) |
Oracle Database version | -- | string(20) | No | All | PRODUCT_COMPONENT_VERSION |
Copyright (C) 2013, Hitachi, Ltd.
Copyright (C) 2013, Hitachi Solutions, Ltd.