With an estimated three out of four SAP shops running Oracle, odds are you or someone on your team could use some help getting that ol' database in shape. This book is filled with tips, tricks, and shortcuts divided into topics like administration, tuning, backup and recovery, troubleshooting, and a general section with logical tips to get essential tasks done. Among other critical tasks, the authors explain in detail how to handle disaster recovery, allow user access while protecting data integrity, Data Guard, use PL/SQL stored program units for administrative tasks, and more.
Chapter 4: Database tuning: Making it sing
Oracle's database engine is a highly tunable creature and, metaphorically speaking, you can make it sing by monitoring how it performs as it runs. This chapter walks you through a number of potential quagmires and tips and tricks on how to crank that extra bit of performance.
Download Chapter 4: Database tuning: Making it sing HERE.
Reproduced from the book "Everyday Oracle DBA," ISBN 0072262087, Copyright 2005. Written permission from McGraw-Hill is required for all other uses. Copyright © 2005 McGraw-Hill. All rights reserved.
Visit the McGraw-Hill website for a detailed description and to learn how to purchase this title.
Want more SAP book excerpts? Click here to browse all our featured chapters!