-
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.
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
|