-
Hi,
Where can I find how many cursors are currently opened.
I tried with following query, will it give accurate result ?
select count(*) from v$open_cursor;
COUNT(*)
----------
51
1 row selected.
My init.ora shows Open_cursors = 150 , but I am getting error that open cursor exceed .
V$sysstat shows :
select value from v$sysstat where statistic# = 3;
VALUE
----------
200
1 row selected.
which one is correct ?
Rgds,
gv.
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
|