1-855-DBA-GURU

Optimizing Performance by Identifying Problem SQL



Robin Schumacher. “Optimizing Performance by Identifying Problem SQL”

SELECT Journal  (3rd Qtr. 2004): 31-37.

Optimizing Performance by Identifying Problem SQL

OVERVIEW

As a DBA, you need to have the right game plan in place for finding and fixing problem SQL code in your database. Fortunately, Oracle is better than most DBMSs at providing information in the data dictionary to help a DBA locate and analyze potentially bad SQL, so by using the roadmap and scripts provided in this article, you should be able to pinpoint any bad SQL that’s run through your system.

. . .

 

About the Author

Speak Your Mind

*