Re: statspack report shows low execute to parse%

On 4 Sep 2005 08:45:04 -0700, "Mark D Powell" <Mark.Powell_at_eds.com> wrote:

>Sybrand has likely hit the nail on the head. If you have a web based
>front-end many tools build SQL statements by concatenating the SQL
>boiler plate to a variable. That means that nearly every SQL statement
>executed is a new SQL statement to Oracle and is not reusable. In this
>case the applications should be changed to using prepared statements
>with bind variables.
>
>Applications that generate dynamic SQL require parsing. Substitue
>static SQL for dyamic SQL wherever possible.
>
>HTH -- Mark D Powell --

I trust the last sentence should read
'Substitute dynamic sql for static sql wherever possible' and you do know the difference between the two ; -)

--
Sybrand Bakker, Senior Oracle DBA