Query against V$SESSION hangs on 10g RAC systems 2007-11-02 - By J Buchanan
Back
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
<html><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit
-line-break: after-white-space; "><br><div><div>On Nov 2, 2007, at 10:01 AM, M
Rafiq wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite"
><span class="Apple-style-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;
orphans: 2; text-align: auto; text-indent: 0px; text-transform: none; white
-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing:
0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect:
none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0; "><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 class="Apple-converted-space"> </span></span>
</font><br><font face="Courier New" size="2"><span style="font-size: 10pt; "
>from v$session<span class="Apple-converted-space"> </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 class=
"webkit-block-placeholder"></div><div>different environment, fwiw, I ran it
about 50 times here and it never hung. 11g RAC on OEL5 64bit.</div><div>
<br class="webkit-block-placeholder"></div><div><div>SQL*Plus: Release 11.1.0.6
.0 - Production on Fri Nov 2 10:34:29 2007</div><div><br class="webkit-block
-placeholder"></div><div><br class="webkit-block-placeholder"></div><div>thanks
jason</div></div></body></html>
|
|
