Query against V$SESSION hangs on 10g RAC systems 2007-11-03 - By LS Cheng
Back
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@(protected)> 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@(protected)>* wrote:
>
> the bug number is *Bug 5010879*
>
>
> On Nov 2, 2007 3:35 PM, J Buchanan <oracle@(protected)> 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>.
>
>
>
<div>Hi</div>
<div> </div>
<div>My customer applied patch 5010879 on top of <a href="http://10.2.0.3">10.2
.0.3</a> in Linux x64-64 and the issue didnt go away. I am not sure about your
platform but for this one it didnt fix.</div>
<div> </div>
<div>Thanks</div>
<div> </div>
<div>--</div>
<div>LSC</div>
<div><br><br> </div>
<div><span class="gmail_quote">On 11/3/07, <b class="gmail_sendername">fairlie
rego</b> <<a href="mailto:fairlie_r@(protected)">fairlie_r@(protected)</a>>
wrote:</span>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0
.8ex; BORDER-LEFT: #ccc 1px solid">
<div>LSC,</div>
<div> </div>
<div>Patch <font size="4"><font size="3">6154852 </font></font><font size="2"
>on top of <a onclick="return top.js.OpenExtLink(window,event,this)" href="http:
//10.2.0.3/" target="_blank">10.2.0.3</a> is supposed to fix 2 issues
</font></div>
<ol>
<li>Incorrect blocking session in gv$session in RAC ( This is a real pain since
the value is 1 + the actual value)
<li>Querying blocking session is sometimes very slow (especially when you
really need it)</li></li></ol>
<div>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.</div>
<div> </div>
<div>Thanks much</div>
<div>Fairlie</div>
<div><span class="e" id="q_11604e618c5875d4_1">
<div> </div>
<div> </div>
<div><b><i>LS Cheng <<a onclick="return top.js.OpenExtLink(window,event,this
)" href="mailto:exriscer@(protected)" target="_blank">exriscer@(protected)</a>><
/i></b> wrote:</div>
<blockquote style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #1010ff
2px solid">the bug number is <font face="helvetica"><strong>Bug 5010879</strong
></font><br><br>
<div class="gmail_quote"><br>On Nov 2, 2007 3:35 PM, J Buchanan <<a onclick=
"return top.js.OpenExtLink(window,event,this)" href="mailto:oracle@(protected)"
target="_blank">oracle@(protected)</a>> wrote: <br>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0pt 0pt 0pt 0
.8ex; BORDER-LEFT: rgb(204,204,204) 1px solid">
<div>
<div><br>
<div>
<div>On Nov 2, 2007, at 10:01 AM, M Rafiq wrote: </div><br>
<blockquote type="cite"><span style="WORD-SPACING: 0px; FONT: 13px Tahoma; TEXT
-TRANSFORM: none; COLOR: rgb(0,0,0); TEXT-INDENT: 0px; WHITE-SPACE: normal;
LETTER-SPACING: normal; BORDER-COLLAPSE: separate"><font face="Courier New"
size="2">
<span style="FONT-SIZE: 10pt">select sid, serial#, program, module, action,
username, osuser,</span></font><br><font face="Courier New" size="2"><span
style="FONT-SIZE: 10pt">sql_hash_value, machine, event, blocking_session
<span> </span></span></font><br><font face="Courier New" size="2"><span
style="FONT-SIZE: 10pt">from v$session<span> </span></span></font><br>
<font face="Courier New" size="2"><span style="FONT-SIZE: 10pt">where status=&
#39;ACTIVE';
</span></font></span></blockquote></div><br>
<div><br> </div></div>
<div>different environment, fwiw, I ran it about 50 times here and it never
hung. 11g RAC on OEL5 64bit.</div>
<div><br> </div>
<div>
<div>SQL*Plus: Release 11.1.0.6.0 - Production on Fri Nov 2 10:34:29 2007</div>
<div><br> </div>
<div><br> </div>
<div>thanks jason</div></div></div></blockquote></div><br></blockquote><br><br>
<br></span></div>
<div>
<div>
<div>
<div>
<div>
<div><strong>Fairlie Rego<br></strong>Senior Oracle Consultant</div>
<div><font face="comic sans ms"><a onclick="return top.js.OpenExtLink(window
,event,this)" href="http://el-caro.blogspot.com/" target="_blank">http://el-caro
.blogspot.com/</a></font></div>
<div><font face="Comic Sans MS">M: +61 402 792 405</font></div>
<div> </div></div></div></div></div></div>
<p>
<hr size="1">
Get the World's number 1 free email service. <a onclick="return top.js
.OpenExtLink(window,event,this)" href="http://au.rd.yahoo.com/mail/taglines
/hotmail/number_one/*http://mail.yahoo.com.au" target="_blank">Find out more
</a>.
<p></p></p></blockquote></div><br>
|
|
