Hi DBA's/Developers,
I've been monitoring our production Oracle database (8.0.5.0.0) on NT with
Spotlight on Oracle. I've also read some documents relating to Oracle
database tuning. I have identified some components that need to be tuned.
One of them is the SGA.
This is the current
Weatherburne
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED], [EMAIL PROTECTED]
Subject: RE: Help tuning the SGA...
Date: Wed, 26 Sep 2001 11:48:30 -0700
The buffer hit ratio is very poor (around 70%).
I've already increased the value of DB_BLOCK_BUFFERS from 1000 to 4000,
but I still have
Title: RE: Info= Help tuning the SGA...
Looking at the scripts you are querying the best advice I would give is close and put away Niemiec's Book (Oracle Performance Tuning tips and techniques)! It has some use, but if you are new to tuning and you said this is a learning process for you
