Tuning When You Can’t Touch The Code

This presentation is from Michael R. Ault, Senior Seminar Leader, DBAGroup LLC DBA World Tour 2001.

Tuning When You Cant Touch the Code


In many Oracle shops today third-party applications are the norm. The major problem for DBAs with these third-party applications is that you are not allowed to alter the source code of the SQL used within the application. Many times the application will generate SQL statements in an ad-hoc manner that further complicates the tuning picture. This paper will attempt to provide insights into how to tune Oracle when you can’t touch the code.

. . .

About the Author

Speak Your Mind