RE: Info=> Help tuning the SGA...

2001-09-26 Thread Ivan_Rivera
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

RE: Info=> Help tuning the SGA...

2001-09-26 Thread Denmark Weatherburne
tory. Regards, Denmark 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 increase

Help tuning the SGA...

2001-09-26 Thread Denmark Weatherburne
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 configurat