SELECT * FROM v$thread;

THREAD#    STATUS ENABLED  GROUPS     INSTANCE         OPEN_TIME CURRENT_GR SEQUENCE#  CHECKPOINT CHECKPOIN ENABLE_CHA ENABLE_TI DISABLE_CH DISABLE_T
---------- ------ -------- ---------- ---------------- --------- ---------- ---------- ---------- --------- ---------- --------- ---------- ---------
         1 OPEN   PUBLIC            4 orcl             20-JUL-00          4          4     113004 20-JUL-00      91818 02-JUL-00          0