Re: database is slow after 3 days

From: <jack_kesselman_at_my-deja.com>
Date: Mon, 13 Sep 1999 03:04:49 GMT
Message-ID: <7rhpkb$qga$1@nnrp1.deja.com>

I'm really interested in this issue....my question is this.... what does one do if the buffer hit ratio and/or library cache hit ratio is low????

In article <37dc48c5_at_defiant.btitelecom.net>, "Jeff Hunter" <jeffh_at_btitelecom.net> wrote:
> Without knowing specifics, I would guess that that either your buffer
hit
> ratio is low or your library cache hit ratio is low. You should run
> utlbstat/utlestat and examine the results in the report.txt file. Run
> utlbstat on about day number 2 and let it run just until you shut
down the
> instance. Run utlestat before you shut down the instance. This
should shed
> some light on your problems...

> Jeff Hunter, OCP DBA
> Enterprise Database Administrator
>
> wozi wrote in message
> <3CF3218126D50624.BED143061FAC9BA5.40E6692494AD7D72_at_lp.airnews.net>...
> >When our oracle database first comes up, everything runs smoothly.
> >After about 3 days, it really starts to slow down. I am having to
shutdown
> >the instance every 3 days to improve performance.
> >
> >This is Oracle 7.3 on Sco Unix 5.5
> >
> >We have over 300M of RAM, and have 2 instances: test and prod.
> >
> >Any help will be appreciated.
> >
> >Please, reply as well to tyc77_at_hotmail.com
> >
> >
> >
>
>

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Sun Sep 12 1999 - 22:04:49 CDT