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

ItemDefault valueChangeable
Collection Interval600Y
Collection Offset50Y
LogNoY
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)
DescriptionSummaryFormatDeltaSupported versionData source
Host
(HOST)
Name of the physical host connected to the running instance--string(64)NoAllV$INSTANCE.HOST_NAME
ORACLE_HOME
(ORACLE_HOME)
ORACLE_HOME environment variable--string(255)NoAll--
ORACLE_SID
(ORACLE_SID)
ORACLE_SID environment variable--string(30)NoAll--
Record Time
(RECORD_TIME)
Collection termination time for the performance data stored in the record--time_tNoAllRemote Monitor Collector
Record Type
(INPUT_RECORD_TYPE)
Record name (always PDI)--string(4)NoAllRemote 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.
--shortNoNot supportedV$INSTANCE.LOGINS
Session Current
(SESSION_CURRENT)
Current number of concurrent user sessions--ulongNoAllV$LICENSE.SESSIONS_CURRENT
Session Highwater
(SESSION_HIGHWATER)
Maximum number of concurrent user sessions since the instance started--ulongNoAllV$LICENSE.SESSIONS_HIGHWATER
Sessions Max
(SESSIONS_MAX)
Maximum number of concurrent user sessions permitted for the instance--ulongNoAllV$LICENSE.SESSIONS_MAX
Sessions Warning
(SESSIONS_WARNING)
Warning limit for the concurrent user sessions for the instance--ulongNoAllV$LICENSE.SESSIONS_WARNING
SGA Database Buffers
(SGA_DATABASE_BUFFERS)
Size of SGA database buffer in bytes--doubleNoAllV$SGA.VALUE where V$SGA.NAME = 'Database Buffers'
SGA Fixed Size
(SGA_FIXED_SIZE)
Size of SGA fixed memory in bytes--doubleNoAllV$SGA.VALUE where V$SGA.NAME = 'Fixed Size'
SGA Redo Buffers
(SGA_REDO_BUFFERS)
Size of SGA REDO buffer in bytes--doubleNoAllV$SGA.VALUE where V$SGA.NAME = 'Redo Buffers'
SGA Variable Size
(SGA_VARIABLE_SIZE)
Size of SGA variable memory in bytes--doubleNoAllV$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.--shortNoAllV$INSTANCE.SHUTDOWN_PENDING
Start Time
(START_TIME)
Collection start time for the performance data stored in the record--time_tNoAllRemote Monitor Collector
Startup Time
(STARTUP_TIME)
Start date and time--string(20)NoAllV$INSTANCE.STARTUP_TIME
Users Max
(USERS_MAX)
Maximum number of users permitted for the database--ulongNoAllV$LICENSE.USERS_MAX
VA DeviceID
(VADEVICEID)
Device ID of virtual agent.--string(256)NoAllRemote Monitor Collector
Version
(VERSION)
Oracle Database version--string(20)NoAllPRODUCT_COMPONENT_VERSION