Written by Jeff Smith
 
Where does one start with tackling a performance problem? I think many people assume that they can just start at the SQL step first, but it is very possible the problem lies elsewhere. If you have a PL/SQL program, it could contain many queries and not all of them will be bad. A query can also have problems with things other than the execution step. It must be parsed, executed, and account for the data to be requested and retrieved from the database to the client.  ...
 
PDF Document - 835 KB