Re: Urgent Oracle parsing question

Remember that Oracle only does what the application is asking .....

Many applications have the following logic:

    open cursor

    parse cursor

    define variables

    bind variables

    execute

After one execute, many programs go back to parse the same SQL statement again. That is not needed. One can just execute, even if the define or bind variables have changed.

Fix the application ....

Anjo.

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 Tue Nov 24 1998 - 23:27:44 CST