Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


Tip of the Day
Language: Enterprise
Expertise: Advanced
Feb 10, 2003

How to Check for Open Cursors in an Oracle Database


If you are using Oracle, you might have faced the following error sometime during the development/testing cycle.
 
ORA-01000: Maximum open cursors exceeded

How do you check for open cursors in the Oracle database? And how can you find out what part of your application is using/wasting these cursors?

Run the following query (remember you should select access to v$open_cursor):
 
select  sql_text, count(*) as "OPEN CURSORS", user_name from v$open_cursor
group by sql_text, user_name order by count(*) desc;

The result will tell you the SQL used and also the OPEN CURSORS used by the corresponding query.
Manish Vashistha
 
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap
Thanks for your registration, follow us on our social networks to keep up-to-date