How to know the count of cursor opened?
Printable View
How to know the count of cursor opened?
select count(*) from v$open_cursor
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 ?
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
Thanks .
But how can I close the idle cursor returned by this query(select count(*) from v$open_cursor)?
What are you trying to do utimately? Why do you want the cursor closed? Do you want to get rid of the user?
D.
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.