Re: OPEN_CURSORS-???

• Post for FREE via your newsreader at post.usenet.com ****

Hi

"DK" <dakight_at_bellsouth.net> wrote in message news:K6TSc.25$ii.5_at_bignews5.bellsouth.net...
> I have a developer who would like for the open_cursors to be set to 2000.
> He tells me that he will open his cursor once for the life of his
> application to avoid reparsing his sql statements by oracle. He's using
> bind variable in his code. Is there an advantage of leaving these cursors
> open for the duration of the application versus just having Oracle search
> the shared pool for the matching sql?

Reusing cursors it is usually a good thing for statements that are frequently re-executed. Unfortunately, if you have lots of connections that open lots of cursors, you will need a huge shared pool.

Chris

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=

• Usenet.com - The #1 Usenet Newsgroup Service on The Planet! *** http://www.usenet.com Unlimited Download - 19 Seperate Servers - 90,000 groups - Uncensored -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=