Expert Oracle Practices: Oracle Database Administration from the Oak Table

by Pete Finnigan, Alex Gorbachev, Tim Gorman, Charles Hooper, Jonathan Lewis

Overview

This book is an anthology of effective database management techniques representing the collective wisdom of the OakTable Network. With an emphasis upon performance—but also branching into security, national language, and other issues—the book helps you deliver the most value for your company’s investment in Oracle Database technologies. You’ll 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.

Product Details

ISBN-13:	9781430226680
Publisher:	Apress
Publication date:	01/20/2010
Series:	Expert's Voice in Oracle
Edition description:	1st ed.
Pages:	592
Product dimensions:	7.30(w) x 9.20(h) x 1.40(d)

About the Author

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.

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