Re: slowing down after a few days

From: Steve Adams <steve.adams_at_ixora.com.au>
Date: Tue, 07 Dec 1999 12:15:44 GMT
Message-ID: <384ceed9.288618351@news.eagles.bbs.net.au>

Hello Peter,

There are lots of possibilities. One common cause of these symptoms is having too large a shared pool. Performance is great until the shared pool gets full and degrades in proportion with activity thereafter. You can monitor the 'free memory' statistic in V$SGASTAT to check out this possibility.

Regards,
Steve Adams

http://www.ixora.com.au/

http://www.oreilly.com/catalog/orinternals/

http://www.christianity.com.au/

On Mon, 6 Dec 1999 12:43:55 +0100, "Peter Vyvey" <peter.vyvey_at_skynet.be> wrote:

>Hello,
>we have a strange problem with an application having the same workload every
>day, slowing down after a few days. A stop/start of the database resolves
>the problem.
>
>Why is this happening ??????
>
>
>Thanks
>
>peter_vyvey_at_hotmail.com
Received on Tue Dec 07 1999 - 06:15:44 CST