Instance (PD_PDI)
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 |