GV$INSTANCE_LOG_GROUP
select USERENV ('Instance'), -- INST_ID NUMBER THREAD#, -- THREAD# NUMBER STATUS, -- STATUS VARCHAR2(6) ENABLED, -- ENABLED VARCHAR2(8) GROUPS, -- GROUPS NUMBER INSTANCE, -- INSTANCE VARCHAR2(80) OPEN_TIME, -- OPEN_TIME DATE CURRENT_GROUP#, -- CURRENT_GROUP# NUMBER SEQUENCE#, -- SEQUENCE# NUMBER CHECKPOINT_CHANGE#, -- CHECKPOINT_CHANGE# NUMBER CHECKPOINT_TIME, -- CHECKPOINT_TIME DATE ENABLE_CHANGE#, -- ENABLE_CHANGE# NUMBER ENABLE_TIME, -- ENABLE_TIME DATE DISABLE_CHANGE#, -- DISABLE_CHANGE# NUMBER DISABLE_TIME -- DISABLE_TIME DATE from V$THREAD

home |  up  |  mailbox