Re: how do you guys tune private sql areas?

skymax_at_cityscape.co.uk wrote:
>Any tips/hints for tuning private sql areas are more than welcome ....
>
>
>
>Thanks.
>
>

Hi there,

Try the following.

1. Cursors can be used in precompilers to improve performance by reducing the frequency of parsing.
2. To take advantage of cursors. it may be necessary to increase the value of Oracle Parameter OPEN_CURSORS.

Regards

N.Prabhakar Received on Tue Dec 31 1996 - 00:00:00 CST