The system table SYSINFO.INSTANCE describes some details about the database.
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 |
Evaluating System Tables, INSTANCE