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

From: LS Cheng <exriscer_at_gmail.com>
Date: Fri, 2 Nov 2007 16:16:46 +0100
Message-ID: <6e9345580711020816i4b6d2624hff0abb05edfb1752@mail.gmail.com>

the bug number is *Bug 5010879*

On Nov 2, 2007 3:35 PM, J Buchanan <oracle_at_digistar.com> 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
>

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Nov 02 2007 - 10:16:46 CDT