How to check how many number of cursor open in database?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: How to check how many number of cursor open in database?

  1. 11-11-2008, 04:26 AM #1
    ptarudkar
    ptarudkar is offline Junior Member
    Join Date
    Nov 2008
    Posts
    5

    How to check how many number of cursor open in database?

    Hi all,
    I want to find out how many cursor are open in database,
    because of thant it affects the CPU utilization.


    Thanks
    Prashant T.
    Reply With Quote Reply With Quote Share on Google+
  2. 11-11-2008, 04:35 AM #2
    davey23uk
    davey23uk is offline Senior Advisor
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    v$open_cursor
    Reply With Quote Reply With Quote Share on Google+
  3. 11-11-2008, 04:54 AM #3
    JChiappa
    JChiappa is offline Senior Member
    Join Date
    Sep 2000
    Location
    Sao Paulo,SP,Brazil, Earth, Milky Way
    Posts
    350
    V$OPEN_CURSOR can be misleading sometimes, maybe he could follow http://asktom.oracle.com/pls/asktom/...D:553222846752

    Regards,

    Chiappa
    Reply With Quote Reply With Quote Share on Google+
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width