Boss wrote:
> I'm are facing a problem with max. number of open cursors exeeded
>
> Querying the v$sesstat (statistic#=3) I can observe how many open cursors a
> session has. The returned number corresponds to the number of entries in
> v$open_cursor.
>
> But according to Metalink note:1020427.102 the cursors remain in
> v$open_cursor even if they are closed by the application.
>
> The question is: How does Oracle keep track on which cursors are actually
> open (=not closed) and which are kept for caching??
>
> The v$sesstat (statistic#=3, opened cursors current) should show current
> number of opened cursors - but it seems as it shows how many distinct
> cursors that were opened for this session (until it reaches the
> maximum=OPEN_CURSORS). Of what use is this statistic then??
>
> When does Oracle actually raise: ORA-1000 Maximum open cursors execeeded ???
>
> Regards
> Hans Peter
>
>
What _is_ your setting for open_cursors? Anything lower than 1000 for a
Forms application is _low_
--
Regards, Frank van Bortel
Received on Thu May 15 2003 - 14:45:19 CDT
