Re: Urgent Oracle parsing question

In article <364BD569.ED9B8D21_at_india.hp.com>,   rajeshb_at_india.hp.com 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
>
>

Just general suggestions:

  1). If it is a code that is used regularly, you could think about

      saving it as stored procedures where it would not be parsed
      for each user and would reduce network traffic. If you are
      worried about protecting your code, the code can be encripted
      in the database.

  2). Ensure that the statements are the same. Same meaning same
      case, same number of space between columns selected and columns
      used in the where clause. Of course if the statement is in a
      stored procedure or a library.

Delton.

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Fri Nov 13 1998 - 10:15:12 CST