If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Hybrid View

Hi,
I've a problem. My open_cursors in init.ora is 2048.
If i query (select * from v$sysstat
where statistic# = '3' gives me a value 3463
and my query (select count(*) from v$open_cursor gives me a value of 2734. Which one is correct / or what could be wrong ?
The database is 8.1.5 on Solaris.

what is it

the parameter OPEN_CURSORS will state the MAXIMUM open cursors allowed in the DB. I forget what the default is but it is fairly low (5 or 10). I remember that we used to get ORA errors until I increased the open_cursors parameter.