Free Tuning & PL/SQL Scripts from books

From: Rniemic <rniemic_at_aol.com>
Date: 30 Nov 1999 19:40:26 GMT
Message-ID: <19991130144026.06946.00000073@ng-fa1.aol.com>

Here is where the Tuning book scripts are (over 100): http://www.tusc.com/books/perf_tune.html Here's the link to get the book on Amazon: http://www.amazon.com/exec/obidos/ISBN=0078824346/theultimatesoftwA/102-34 74260-0824009

Here is where the PL/SQL book (by Joe Trezzo) scripts are (over 100): http://www.tusc.com/books/plsql.html
Here's the link to get the book on Amazon: http://www.amazon.com/exec/obidos/ISBN=0078824389/theultimatesoftwA/102-34 74260-0824009

Here's what's in the Tuning Book:
Oracle Performance Tuning Tips and Techniques (ISBN: 0078824346), Richard J. Niemiec

Chapter 1	Over A Decade of Tuning Experience	
Chapter 2	Basic Index Principles	
Chapter 3	Disk I/O and Fragmentation	
Chapter 4	Tuning the init.ora (Also, Appendix A gives full list)	
Chapter 5	Enterprise Manager and Tuning Pack	
Chapter 6	Using explain plan, trace, and tkprof	
Chapter 7	Basic Hint Syntax	
Chapter 8	Query Tuning	
Chapter 9	Table Joins and Other Advance Query Tuning	
Chapter 10	Using pl/sql to Enhance Performance	
Chapter 11	Using Parallel Feature to Improve Performance	
Chapter 12 	Oracle8 and Oracle8i New Feature 
Chapter 13	Examples: Oracle8 and 8i New Tips	
Chapter 14	The v$ Views (Also, Appendix B gives list of all)	
Chapter 15	The x$ Tables (Also, Appendix C gives list of all)	
Chapter 16	Using and Interpreting ultestat/ultbstat	
Chapter 17	Performing a Quick System Review	
Chapter 18	Monitor the System Using unix Utilities	
Appendix A 	Full list of INIT.ora parameters
Appendix B	Full list of both Oracle7/8 V$ views and creation from X$
tables
Appendix C 	Full list of both Oracle7/8 x$ tables

Here's what's in the PL/SQL Book:
By Joseph Trezzo (ISBN: 0078824389)

---

Chapter 1:Reviewing PL/SQL Growth and Setting the Stage
Chapter 2:Maximizing PL/SQL Development with the Power of SQL
Chapter 3:Establishing PL/SQL Coding Standards
Chapter 4:Defining Standard PL/SQL Coding Techniques
Chapter 5:Defining Standard PL/SQL Program Unit Techniques
Chapter 6:Exploring the Expansive PL/SQL Language Commands
Chapter 7:Maximizing PL/SQL By Optimizing SQL
Chapter 8:Maximizing PL/SQL by Optimizing PL/SQL
Chapter 9:Examining DBA-Related PL/SQL Issues
Chapter 10:Unlocking PL/SQL Security
Chapter 11:Exploring the Oracle Supplied PL/SQL Packages
Chapter 12:Understanding the Power of the Oracle Supplied PL/SQL Packages
Chapter 13:Taking Advantage of the PL/SQL Data Dictionary
Chapter 14:Exploring PL/SQL Product Integration
Chapter 15:Understanding the Critical Role of PL/SQL in the Web
Chapter 16:New PL/SQL Related Features in Oracle8 and Oracle8i
Appendix A:The Example Database

Appendix B:PL/SQL Quick Reference
Appendix C:PL/SQL Data Dictionary Reference Received on Tue Nov 30 1999 - 13:40:26 CST