White Paper: Database Tuning Methodology

From: <campbell_white_at_my-deja.com>
Date: Tue, 31 Aug 1999 16:39:58 GMT
Message-ID: <7qh0g9$sbi$1@nnrp1.deja.com>

A new White Paper has been added to the "Archives" section of the "DBA Pipeline" - a free internet community for Oracle DBAs worldwide. http://www.revealnet.com/pipeline.htm

Database Tuning Methodology
By Mike Ault

There is probably no more complex region of database management than that of tuning. A properly tuned database shows good hit ratios (db block buffer, library, etc.), low contention (db block, latch, lock, redo, undo) and good query performance.

Many times to tune one area of the database, another has to take a back seat and compromises must be made. Sometimes we can get everything to work harmoniously together, but not often enough. Let's look at some tuning methodology and discuss some particular areas where tuning is important. Format: zip

---

RevealNet News

• PCWEEK Gives PL/GENERATOR Rave Reviews
• PL/Vision Integrated in Quest Software's SQL Navigator
• RevealNet Announces PL/FORMATTER for TOAD full info at http://www.revealnet.com

Enjoy!

Cam White
RevealNet, Inc.

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Tue Aug 31 1999 - 11:39:58 CDT