SELECT sid,C.NAME,A.CIRCUIT, A.DISPATCHER, A.SERVER, A.STATUS
      FROM V$CIRCUIT A, V$SESSION B, V$DISPATCHER C
      WHERE (A.SADDR = B.SADDR) AND 
	(A.DISPATCHER = C.PADDR) AND USERNAME = '&user'
/