Query against V$SESSION hangs on 10g RAC systems 2007-11-02 - By LS Cheng
Back
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
>
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="border-left: 1px solid rgb(204, 204,
204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><div style=""><div class=
"Ih2E3d"><br><div><div>On Nov 2, 2007, at 10:01 AM, M Rafiq wrote:
</div><br><blockquote type="cite"><span style="border-collapse: separate; color
: rgb(0, 0, 0); font-family: Tahoma; font-size: 13px; font-style: normal; font
-variant: normal; font-weight: normal; letter-spacing: normal; line-height:
normal; text-indent: 0px; text-transform: none; white-space: normal; word
-spacing: 0px;">
<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>
|
|
