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