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

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_at_yahoo.com> 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_at_gmail.com>* wrote:

>

> 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

> >

>

>

>

>

>    *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>.

>

>

>


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