the bug number is *Bug 5010879* On Nov 2, 2007 3:35 PM, J Buchanan <oracle@xxxxxxxxxxxx> wrote: > > 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 >