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

  • From: "LS Cheng" <exriscer@xxxxxxxxx>
  • To: "J Buchanan" <oracle@xxxxxxxxxxxx>
  • Date: Fri, 2 Nov 2007 16:16:46 +0100

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
>

Other related posts: