How can shared_pool be too large? was Re: slowing down after a few days

On Tue, 07 Dec 1999 12:15:44 GMT, steve.adams_at_ixora.com.au (Steve Adams) wrote:

>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

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