Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Top 200 Terrific PL/SQL Tuning Tips
A new file has just been added to the "Archives" section of the PL/SQL
Pipeline - a free internet community for Oracle
PL/SQL developers worldwide. The PL/SQL Pipeline features a growing library
of white papers, presentations and
free software utilities. It also includes "Pipe Talk" - one of the most
active discussion groups for PL/SQL developers
on the internet. The PL/SQL Pipeline is hosted by author Steven Feuerstein
and sponsored by RevealNet.
http://www.revealnet.com/plsql-pipeline/index.htm
Top 200 Terrific PL/SQL Tuning Tips
By Steven Feuerstein
You can spend all day tuning your SQL statements. You can apply any one of a number of fantastic first-party (Oracle) and third-party analysis tools to the SQL side of your application. You can bring in an Oracle tuning specialist. Yes, you can tune and tune and tune -- and still your PL/SQL-based programs can run very inefficiently. It is difficult to find detailed, comprehensive recommendations for tuning the PL/SQL side of one's Oracle applications. After spending 12 years learning, using and writing about Oracle's PL/SQL language, Steven Feuerstein has assembled 1,247 tuning tips for PL/SQL developers. He has selected the top 200 most terrific of these tips for this presentation.
Subscribe to the Pipeline Newsletter
http://www.revealnet.com/newsletter/newsletter_0400.htm