V$THREAD

Data Dictionary View

Columns
   ___________________________
 
   THREAD#
   STATUS
   ENABLED
   GROUPS
   INSTANCE       (the Oracle SID)
   OPEN_TIME
   CURRENT_GROUP#
   SEQUENCE#
   CHECKPOINT_CHANGE#
   CHECKPOINT_TIME
   ENABLE_CHANGE#
   ENABLE_TIME
   DISABLE_CHANGE#
   DISABLE_TIME

Related:

V$CIRCUIT 
V$DISPATCHER 
V$DISPATCHER_RATE 
V$MTS
V$QUEUE 
V$REQDIST 
V$SHARED_SERVER 


© Copyright SS64.com 1999-2013
Some rights reserved