Database Tuning (MOSC)

MOSC Banner

How to find Current open Cursors sql text

edited Jan 7, 2011 6:39PM in Database Tuning (MOSC) 6 commentsAnswered
 Hi,
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>
	

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center