Re: database is slow after 3 days

Low buffer hit-> increase db_block_buffers Low library cache hit-> increase shared_pool_size

On Mon, 13 Sep 1999 03:04:49 GMT, jack_kesselman_at_my-deja.com wrote:

>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.

Andrey Dmitriev	 eFax: (978) 383-5892  Daytime: (917) 373-5417
AOL: NetComrade	 ICQ: 11340726 remove NSPAM to email