Re: Performance Problem - Parsing twice

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: 30 Aug 2001 10:36:30 -0700
Message-ID: <9mltiu02jvi@drn.newsguy.com>

In article <a4mrotk62i54qdmm3ui45o4kn12rulpibi_at_4ax.com>, Andreas says...
>
>Hi,
>we have a big performance problem with our Oracle 8.1.7.1 DB running
>on AIX 433-08. We have an Appl running on an NT System whos statements
>are always parsed twice as much as executed !!
>Any hints and tips are welcome.

recode the apps after training the developers ;)

look at:

session_cached_cursors

see
http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:865497961356 http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:904605517791 for other details on this setting.

>Thanks
>Andreas
>Andreas Wizemann

--
Thomas Kyte (tkyte@us.oracle.com)             http://asktom.oracle.com/ 
Expert one on one Oracle, programming techniques and solutions for Oracle.
http://www.amazon.com/exec/obidos/ASIN/1861004826/  
Opinions are mine and do not necessarily reflect those of Oracle Corp

Received on Thu Aug 30 2001 - 12:36:30 CDT