This book is an anthology of effective database management techniques representing the collective wisdom of the OakTable Network. With an emphasis upon performancebut also branching into security, national language, and other issuesthe book helps you deliver the most value for your companys investment in Oracle Database technologies. Youll learn to effectively plan for and monitor performance, to troubleshoot systematically when things go wrong, and to manage your database rather than letting it manage you.
- Battle Against Any Guess
- A Partly Cloudy Future
- Developing a Performance Methodology
- The DBA as Designer
- Running Oracle on Windows
- Managing SQL Performance
- PL/SQL and the CBO
- Understanding Performance Optimization Methods
- Choosing a Performance Optimization Method
- Managing the Very Large Database
- Statistics
- Troubleshooting Latch Contention
- Measuring for Robust Performance
- User Security
- Securing Data
Pete Finnigan works as an independent Oracle security consultant for his own company PeteFinnigan.com Limited. Pete specializes in performing detailed Oracle security Health checks against Oracle databases using a detailed methodology developed by Pete from many years of experience in securing databases. Pete performs this service for many clients worldwide, but also offers other specialist consulting services in many areas related to Oracle security. Pete's company PeteFinnigan.com Limited also develops and delivers a number of Oracle security training courses that are well-regarded and comprehensive.This book is an anthology of effective database management techniques representing the collective wisdom of the OakTablelăI