DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: how to know the count of cursor opened

  1. #1
    Join Date
    Oct 2000
    Posts
    20
    How to know the count of cursor opened?

  2. #2
    Join Date
    Jun 2000
    Posts
    104
    select count(*) from v$open_cursor

  3. #3
    Join Date
    Aug 2000
    Location
    -
    Posts
    7
    does someone know how to delete some rows of a synonym contents, for example how to delete/kill some rows of the v$open_cursor ?

  4. #4
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    hm You cant delete rows in v$, it´s managed by Oracle. It´s in data dictionary and you must no touch data dictionary never ever

  5. #5
    Join Date
    Oct 2000
    Posts
    20
    Thanks .
    But how can I close the idle cursor returned by this query(select count(*) from v$open_cursor)?

  6. #6
    Join Date
    Oct 2000
    Location
    Cambridge, MA (Boston)
    Posts
    144
    What are you trying to do utimately? Why do you want the cursor closed? Do you want to get rid of the user?

    D.

  7. #7
    Join Date
    Oct 2000
    Posts
    20
    My application is based on website. I want to monitor which program isn't efficient and doesn't close cursor when program is end.
    thanks.

Posting Permissions

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


Click Here to Expand Forum to Full Width