Query against V$SESSION hangs on 10g RAC systems 2007-11-03 - By fairlie rego
Back
LSC,
Patch 6154852 on top of 10.2.0.3 is supposed to fix 2 issues
Incorrect blocking session in gv$session in RAC ( This is a real pain since
the value is 1 + the actual value)
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.
<div>LSC,</div> <div> </div> <div>Patch <FONT size=4><FONT size=3
>6154852 </FONT></FONT><FONT size=2>on top of 10.2.0.3 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> <LI
>Querying blocking session is sometimes very slow (especially when you really
need it)</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> </div> <div> </div>
<div><B><I>LS Cheng <exriscer@(protected)></I></B> wrote:</div> <BLOCKQUOTE
class=replbq 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 href="mailto:oracle@(protected)">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 class=Ih2E3d><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='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><DIV> <DIV> <DIV> <DIV> <DIV>
<DIV><STRONG>Fairlie Rego<BR></STRONG>Senior Oracle Consultant</DIV> <DIV>
<FONT face="comic sans ms"><A href="http://el-caro.blogspot.com/">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 href="http://au.rd.yahoo.com
/mail/taglines/hotmail/number_one/*http://mail.yahoo.com.au" target=_blank>Find
out more</a>.
|
|
