Skip navigation.  Oracle SQL tuning with parameters  Donald K.
Burleson's picture  While all SQL tuning professionals advocate
tuning each individual SQL statement to reduce logical I/O,
there are many cases where you do not have the luxury of tuning
each-and-every SQL statement in an application. In these cases,
the best you can hope to do is adjust the global optimizer
parameters to optimizer as many SQL statements as possible.
Cases where you may not be able to tune individual SQL
statements include:    • Vendor applications - If you do not
have access to the source code, if can be very challenging too
change the SQL execution plans.    • Ad-Hoc query tools - Tools
that generate dynamic SQL are notoriously difficult to tune
because there is no SQL source code.    • Economic constraints -
If IT management will not pay to tune 10,000 SQL statements then
you are forced to adjust system-wide Oracle parameters.  While
system-wide tuning is not the best solution to SQL tuning it can
be extremely helpful in tuni