Re: Query against V$SESSION hangs on 10g RAC systems
- From: "LS Cheng" <exriscer@xxxxxxxxx>
- To: "fairlie rego" <fairlie_r@xxxxxxxxx>
- Date: Sat, 3 Nov 2007 11:04:21 +0100
Hi
My customer applied patch 5010879 on top of 10.2.0.3 in Linux x64-64 and the
issue didnt go away. I am not sure about your platform but for this one it
didnt fix.
Thanks
--
LSC
On 11/3/07, fairlie rego <fairlie_r@xxxxxxxxx> wrote:
>
> LSC,
>
> Patch 6154852 on top of 10.2.0.3 is supposed to fix 2 issues
>
> 1. Incorrect blocking session in gv$session in RAC ( This is a real
> pain since the value is 1 + the actual value)
> 2. Querying blocking session is sometimes very slow (especially when
> you really need it)
>
> I am supposed to be applying this patch along with a whole host of other
> patches for an environment next week. Are you saying that the second problem
> is not fixed by this patch.
>
> Thanks much
> Fairlie
>
>
> *LS Cheng <exriscer@xxxxxxxxx>* wrote:
>
> 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
> >
>
>
>
>
> *Fairlie Rego
> *Senior Oracle Consultant
> http://el-caro.blogspot.com/
> M: +61 402 792 405
>
>
> ------------------------------
> Get the World's number 1 free email service. Find out
> more<http://au.rd.yahoo.com/mail/taglines/hotmail/number_one/*http://mail.yahoo.com.au>.
>
>
>
Other related posts:
