Re: database is slow after 3 days

Hi,

  Instead of increasing the size of the shared pool reduce it. You can also put in a routine to flush the shared pool when the performance decreases.

Regards,
Denny
---
Denny Koovakattu
denny_at_vitalsol.com
http://vitalsol.com/

On Tue, 14 Sep 1999 01:04:08 jack_kesselman_at_my-deja.com wrote:
> Message from the Deja.com forum:
> comp.databases.oracle.server
> Your subscription is set to individual email delivery
> >In article <37dcb275.16629887_at_news.earthlink.net>,
> andreyNSPAM_at_bookexchange.net (NetComrade) wrote:
>Thanks for the information. Our Buffer Hit ratio is fine. It looks
>like our "library cache hits" are low. We grow the shared pool sized
>but we still end up hitting performance problems. We think this is due
>to the fact the the SQL we use does not make use of bind variables. As
>we increase the SGA we really don't see any improvements in
>performance...only longer times before the application becomes "slow".
>
>It would be a major undertaking to add bind variables to all the code
>although we are definitely working towards this
>
>Any ideas?
>
>> 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
>> ---------------
>> Andrey Dmitriev eFax: (978) 383-5892 Daytime: (917) 373-5417
>> AOL: NetComrade ICQ: 11340726 remove NSPAM to email

--== Sent via Deja.com http://www.deja.com/ ==-- Share what you know. Learn what you don't.

 Sent via Deja.com http://www.deja.com/  Share what you know. Learn what you don't. Received on Tue Sep 14 1999 - 15:03:41 CDT