Re: ASMM experiences

From: Matthias Hoys <anti_at_spam.com>
Date: Thu, 11 Oct 2007 23:25:17 +0200
Message-ID: <470e94b9$0$22309$ba620e4c@news.skynet.be>

"JAW" <jwilliam_at_aglresources.com> wrote in message news:1192052827.290312.210430_at_o3g2000hsb.googlegroups.com...
>I am running most of my databases at 10.2.0.3 level on Solaris and
> Windows.
>
> My question is how do you like ASMM?
>
> I am getting ready to test it and would like comments.
>
>
> Subject: How To Use Automatic Shared Memory Management (ASMM) In
> Oracle10g
> Doc ID: Note:295626.1 Type: BULLETIN
> Last Revision Date: 28-AUG-2007 Status: PUBLISHED
>

I used it but turned it off again. After a couple of weeks I had a shared pool of 1200MB and a buffer cache of 600MB, and the shared pool kept increasing. It was meant to be the other way around :-) And I couldn't change the code of the third-party applications.

Matthias Received on Thu Oct 11 2007 - 16:25:17 CDT