Re: gather stats slows performance?

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

Hi Allan

> > To workaround the bind variables problem I suggest you to set
> > CURSOR_SHARING=FORCE. This setting must be carefully tested!
>
> I recall this from Tom Kyte's book -- however I would rather fix
> things properly than enable a potentially troublesome option.

As I wrote CURSOR_SHARING is a workaround, not a solution!

Chris

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

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