Expert Oracle Practices: Oracle Database Administration from the Oak Table

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. What youll learn Adopt a rational approach to database management; eliminate guesswork Add value to your organization as a database professional Manage and optimize performance Exploit different platform technologies Secure your organization's data Gain deep understanding of database internals and structures Who this book is for This book is aimed at Oracle database administrators who want to further their careers by implementing sound and proven database administration practicesand especially repeatable and predictable practicesin their daily work. Table of Contents 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