Open Cursors

[vinit]

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.

Thanx

[raghucharan]

from v$open_cursor==> implicit cursors used + distinct explicit cursors opened + dynamic cursors parsed but not closed

from v$sysstat ===>implicit cursors used + distinct explicit cursors opened + dynamic cursors opened.

Hope it is clear.
Raghu

[vinit]

Hi,
Thanks Raghu. But what does the init parameter OPEN_CURSORS indicate and what is the relation between them..!! ?

[jgmagnus]

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.

- Magnus

[ligang]

In 7.3 , The Default Open_cursor is 50 , I think the value states the number of the cursor opened defaultly after starting the instance .
Am I right ?

[pando]

it states the maximum number of open cursors per session