• Skip to main content
  • Skip to primary sidebar

Ravi Shankar

Tweaking Apps

  • Swift
  • Tech Tips
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 block keywords in Jio broadband
  • How to disable opening an app automatically at login in Mac
  • How to set preferred Wifi network on Mac
  • Attribute Unavailable: Estimated section warning before iOS 11.0
  • How to recover Firefox password from Time Machine backup

Pages

  • About
  • Privacy Policy
  • Terms and Conditions

Copyright 2022 © rshankar.com

Terms and Conditions - Privacy Policy