• Skip to main content
  • Skip to primary sidebar

Ravi Shankar

Tweaking Apps

  • About
  • Portfolio
  • Privacy Policy
You are here: Home / Technical / How to find out maximum open cursors and no of cursors open in Oracle

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

March 4, 2008 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

TwitterLinkedin

Recent Posts

  • How to know the size of the folders in iCloud
  • Errors were encountered while preparing your device
  • We have blocked all requests from this device – Firebase Phone Authentication
  • iPhone is not available error message in Xcode
  • Clear CocoaPods cache, re-download and reinstall all pods

Copyright 2021 © rshankar.com