Re: Optimal values in init.ora file

Mark.Powell_at_eds.com (Mark D Powell) wrote in message news:<2687bb95.0411301823.49a62e20_at_posting.google.com>...
>
> What kind of application do you have that needs a session to be able
> to hold a 1,000 open cursors?

I have an app that needs open_cursors=7000. I would characterize this as an application that suffers from database independence. [Ironically from using OCI to dynamically generate everything].

But it works well regardless, and that is what is important.

From the 9i reference manual:

..."This parameter also constrains the size of the PL/SQL cursor cache which PL/SQL uses to avoid having to reparse as statements are reexecuted by a user.
"...

"Assuming that a session does not open the number of cursors specified by OPEN_CURSORS, there is no added overhead to setting this value higher than actually needed."

So I would add to Mark's answer, if a vendor supplied your app, see if they have anything to say about init parameters.

Also wrt shared SQL areas,
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96533/memory.htm#36979

jg

--
@home.com is bogus.
I took a hologram making class in 1981. 
http://slate.msn.com/id/2110446/