Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Query against V$SESSION hangs on 10g RAC systems

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US