Re: Query against V$SESSION hangs on 10g RAC systems

  • From: J Buchanan <oracle@xxxxxxxxxxxx>
  • To: rafiq9857@xxxxxxxxxxx
  • Date: Fri, 2 Nov 2007 10:35:54 -0400


On Nov 2, 2007, at 10:01 AM, M Rafiq wrote:


select sid, serial#, program, module, action, username, osuser,
sql_hash_value, machine, event, blocking_session
from v$session
where status='ACTIVE';
different environment, fwiw, I ran it about 50 times here and it never hung. 11g RAC on OEL5 64bit. 

SQL*Plus: Release 11.1.0.6.0 - Production on Fri Nov 2 10:34:29 2007


thanks jason

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 11-2007