Re: Urgent Oracle parsing question

As you didn't specify which frontend and which version of Oracle, my advice can only be generic.
First of all (and I don't know in which version it was introduced) there is an init.ora parameter session_cached_cursors. The default value is 0, change it to non-zero and Oracle will keep that number of (closed) cursors in it's cache and reuse them if necessary. Please note this has been introduced mainly because there are packages in which you can't influence this, in Pro*C for example you can arrange this yourself. Secondly, as I already mentioned in Pro*C you should use the compiler switches HOLD_CURSOR=YES and RELEASE_CURSOR=NO.

Hth,

Sybrand Bakker, Oracle DBA.

Rajesh Bhave wrote:

> Hello Oracle gurus,
>
> We are facing extensive performance degradation.
> This is because of Oracle parsing the same SQL
> statements for too many number of times. If someone
> could throw some lights on how to stop / avoid this,
> it will of great help.
>
> Thanx and Regards,
> Rajesh

Received on Fri Nov 13 1998 - 03:53:19 CST