Re: statspack report shows low execute to parse%

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 -- Received on Sun Sep 04 2005 - 10:45:04 CDT