OCP: Oracle9i Performance Tuning Study Guide

Author: [USA] John
Publisher:
Publish Date: 2003-01-01
Features: This book covers all the content required for candidates taking the Oracle9i:PerformanceTuning exam. It explains how to use Oracle's tuning methods and techniques to improve database performance, including how to use data dictionary and dynamic performance views, as well as various tuning tools provided by Oracle. It also covers how to evaluate and adjust application system design with optimizer behavior, execution plans, and indexing strategies; how to assess and tune the performance of memory structures such as SharedPool, DatabaseBufferCache, LargePool, JavaPool, and SharedServer; how to monitor and manage Oracle's redo mechanism; how to evaluate and manage the performance of physical disk I/O in Oracle architecture; how to assess and adjust performance issues related to latches, FreeLists, and lock contention; and how to use Oracle's ResourceManager to improve the utilization of Oracle Server resources. This exam is part of the Oracle9i Certified Professional series. Therefore, this book is suitable for candidates preparing for this certification exam and can also serve as a reference for professionals studying Oracle9i.