SQL> select instance_name,host_name,thread#,status from v$instance;
INSTANCE_NAME HOST_NAME THREAD# STATUS
---------------- ---------------------------------------------------------------- ---------- ------------
orcl LESSION6 1 OPEN
SQL> select dbid,name,log_mode,current_scn from v$database;
DBID NAME LOG_MODE CURRENT_SCN
---------- --------- ------------ -----------
1181980082 ORCL ARCHIVELOG 1977951