Orace9i Performance Tuning

Author: [USA] Richard J. Niemiec, translated by Wang Haitao, Lu Fan
Publisher:
Publish Date: 2004-03-01
Features: This book comprehensively and systematically introduces various methods and techniques for maintaining high performance in the Oracle9i environment. Written by Richard J. Niemiec, CEO of TUSC, with his extensive experience in Oracle consulting and debugging, the book is considered the "authority" in performance optimization literature. It demonstrates the best solutions for performance tuning through detailed examples and provides an in-depth analysis of the new performance tuning options introduced in Oracle9i. The main content of the book includes:
· Selecting the best index options for different scenarios;
· Distributing important data files across available hard drives;
· Optimizing database performance using key init.ora parameters;
· Fully utilizing Oracle Enterprise Manager;
· Using tools such as EXPLAIN, TRACE, TKPROF, STORED OUTLINES, and others;
· Using hints as needed to rewrite optimizer settings;
· Executing automatic queries using PL/SQL stored procedures;
· Improving performance using the Parallel Execution Option (PEO);
· Monitoring and tuning the database using STATSPACK;
· Querying V$ views and X$ tables.