Advanced Oracle Tuning and Administration

Kevin Loney (Wilmington, DE) is a veteran Oracle developer and DBA. He is the author of the best-selling Oracle8 DBA Handbook and co-author of Advanced Tuning and Administration and Oracle8i: The Complete Reference. He frequently makes presentations at Oracle conferences and contributes to Oracle Magazine

Part I: Managing Database Size, Performance, and Emergencies.Part II: Administration of a Growing Database.Planning for Your Database Growth.Memory and CPU Tuning Issues.Hardware Tuning Issues.Managing the Space Inside Your Database.Database Shutdown/Startup Kit.Part III: Tuning a Growing Database.Managing for Performance.Monitoring.Environment Tuning.EXPLAINing SQL Statement Tuning.The Top Ten SQL Tuning Tips.Part IV: Advanced Tuning Options.Parallel Options.When All Else Fails: New and Improved Tuning Options.Part V: The Oracle DBA Certification Exam.Oracle7 DBA Certification Exam.Candidate Bulletin of Information.Oracle7 DBA Practice Questions.Analysis of the Practice Questions.The Oracle7 Database Administrator Practice Test.