Subject: Re: Query against V$SESSION hangs on 10g RAC systems 2007-11-02 - By LS Cheng
Back
hi
querying blocking_session is the problem, if you dont query that columnd
then it should be fine
I have a customer who requested a backport to fix the bug but the one-off
patch has no effect so might have to wait until 10.2.0.4
thanks
--
LSC
On 11/1/07, Dean <snowman327@(protected)> wrote:
>
> We recently had a locking/blocking problem on two different 10.2.0.3 RAC
> systems. I ran a query similar to below to get more information:
>
>
>
> select sid, serial#, program, module, action, username, osuser,
>
> sql_hash_value, machine, event, blocking_session
>
> from v$session
>
> where status='ACTIVE';
>
>
>
> About 1 out of 5 times this query hangs. When it hangs, it waits for
> exactly 60 seconds on "DIAG idle wait" and then returns the result set. If
> I remove the blocking_session column, this query runs fine and never hangs.
> Has anyone run into this or have any ideas why this would happen?
>
<div>hi</div>
<div> </div>
<div>querying blocking_session is the problem, if you dont query that columnd
then it should be fine</div>
<div> </div>
<div>I have a customer who requested a backport to fix the bug but the one-off
patch has no effect so might have to wait until <a href="http://10.2.0.4">10.2
.0.4</a></div>
<div> </div>
<div>thanks</div>
<div> </div>
<div>--</div>
<div>LSC</div>
<div><br><br> </div>
<div><span class="gmail_quote">On 11/1/07, <b class="gmail_sendername">Dean</b>
<<a href="mailto:snowman327@(protected)">snowman327@(protected)</a>> wrote:<
/span>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0
.8ex; BORDER-LEFT: #ccc 1px solid">
<div lang="EN-US" vlink="purple" link="blue">
<div>
<p><font face="Arial" size="2"><span style="FONT-SIZE: 10pt; FONT-FAMILY: Arial
">We recently had a locking/blocking problem on two different <a onclick="return
top.js.OpenExtLink(window,event,this)" href="http://10.2.0.3/" target="_blank">
10.2.0.3</a> RAC systems. I ran a query similar to below to get more
information:</span></font></p>
<p><font face="Arial" size="2"><span style="FONT-SIZE: 10pt; FONT-FAMILY: Arial
"> </span></font></p>
<p><font face="Courier New" size="2"><span style="FONT-SIZE: 10pt">select sid,
serial#, program, module, action, username, osuser,</span></font></p>
<p><font face="Courier New" size="2"><span style="FONT-SIZE: 10pt">sql_hash
_value, machine, event, blocking_session </span></font></p>
<p><font face="Courier New" size="2"><span style="FONT-SIZE: 10pt">from v
$session </span></font></p>
<p><font face="Courier New" size="2"><span style="FONT-SIZE: 10pt">where status
='ACTIVE';</span></font></p>
<p><font face="Courier New" size="2"><span style="FONT-SIZE: 10pt"> </span
></font></p>
<p><font face="Arial" size="2"><span style="FONT-SIZE: 10pt; FONT-FAMILY: Arial
">About 1 out of 5 times this query hangs. When it hangs, it waits for
exactly 60 seconds on "DIAG idle wait" and then returns the result set.
If I remove the blocking_session column, this query runs fine and never hangs.
Has anyone run into this or have any ideas why this would happen?
</span></font></p></div></div></blockquote></div><br>
|
|
