• Skip to main content
  • Skip to primary sidebar

Ravi Shankar

Lifelong Learner

  • About
  • Portfolio

How to find out maximum open cursors and no of cursors open in Oracle

By Ravi Shankar Leave a Comment

The maximum number of open cursors in an oracle database can be determined by the following query

select name, value
from v$parameter
where name like ‘open-cursors’

the value for open_cursors parameter refers to maximum number of open cursors allowed.

The below query can be used to determine number of open cursors for the current session.

SELECT
sid,user_name, COUNT(*) "Cursors per session"
FROM v$open_cursor
GROUP BY sid,user_name

Filed Under: Technical

Reader Interactions

Trackbacks

  1. Key posts in Techno Masala for March 2008 | Techno Masala says:
    May 18, 2008 at 3:08 pm

    […] How to find out maximum open cursors and no of cursors open in Oracle […]

    Reply
  2. Useful articles posted on Blogmines | Blogmines says:
    March 26, 2009 at 3:11 am

    […] How to find out maximum open cursors and no of cursors open in Oracle […]

    Reply

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Primary Sidebar

  • Email
  • LinkedIn
  • Twitter

iOS Cheat Sheets

Download free copy of iOS Cheat Sheets

Copyright 2023 © rshankar.com

Terms and Conditions - Privacy Policy