How to find Current open Cursors sql text
Hi,
The following query helps identify open cursors currently open.
The following query helps identify open cursors currently open.
<span class="kwd">select</span><span class="pln"> a</span><span class="pun">.</span><span class="pln">value</span><span class="pun">,</span><span class="pln"> s</span><span class="pun">.</span><span class="pln">username</span><span class="pun">,</span><span class="pln"> s</span><span class="pun">.</span><span class="pln">sid</span><span class="pun">,</span><span class="pln"> s</span><span class="pun">.</span><span class="pln">serial</span><span class="pun">#</span><span class="pln">
<br/></span><span class="kwd">from</span><span class="pln"> v</span><span class="pun">$</span><span class="pln">sesstat a</span><span class="pun">,</span><span class="pln"> v</span><span class="pun">$</span><span class="pln">statname b</span><span class="pun">,</span><span class="pln"> v</span><span class="pun">$</span><span class="pln">session s
<br/></span><span class="kwd">where</span><span class="pln"> a</span><span class="pun">.</span><span class="pln">statistic</span><span class="pun">#</span><span class="pln"> </span><span class="pun">=</span><span class="pln"> b</span><span class="pun">.</span><span class="pln">statistic</span><span class="pun">#</span><span class="pln"> </span><span class="kwd">and</span><span class="pln"> s</span><span class="pun">.</span><span class="pln">sid</span><span class="pun">=</span><span class="pln">a</span><span class="pun">.</span><span class="pln">sid
<br/></span><span class="kwd">and</span><span class="pln"> b</span><span class="pun">.</span><span class="pln">name </span><span class="pun">=</span><span class="pln"> </span><span class="str">'opened cursors current'</span><span class="pun">;
<br/>
<br/>But
<br/></span><span class="pln"></span>
0