It is a truism that the goals of the SQL programmer and the DBA are not the same. Many developers realize that their primary goal is to write and test SQL as quickly as possible without focusing solely on the performance.
This is especially a problem because the same SQL statement may be written in a number of different ways, all return the same result, but with radically different performance. Consider a few of these examples in the following SlideShow.
- Become an SQL tuning expert and offer to share your expertise with the developers
- Create SQL tuning tip sheets.
- Install Oracle SQL tuning tools such as (SQLab or SQL*Analyzer) and encourage the developers to use these products.
- Be a mentor. Let the developers know that they will not be criticized or ridiculed for sloppy SQL.
Now that we understand the issues involved with working with SQL developers, let us investigate compelling techniques for securing Oracle SQL with stored procedures.