INSTANCE

Definition

The system table INSTANCE describes some details about the database instance.

Structure

INSTANCE

NODE

CHAR(64)

Name with which the database instance can be addressed by applications

LOCALNODE

CHAR(64)

Name with which this hot standby instance can be addressed (if you have a hot standby configuration)

ADMINSTATEDATE

TIMESTAMP

Time at which the ADMIN operational state was reached

ONLINESTATEDATE

TIMESTAMP

Time at which the ONLINE operational state was reached

KERNELPROCESSID

FIXED(20)

Identification of the kernel process

See also:

Evaluating System Tables, INSTANCE

Concepts of the Database System, Overview of the Database System, Architecture of a Hot Standby System