Re: Automatic Shared Memory Management

On Feb 10, 9:20 am, "mrow..._at_gmail.com" <mrow..._at_gmail.com> wrote:
> Hello,
>
> I write an essay about Automatic Shared Memory Management in Oracle
> 10g
> and I'm looking more information about it. I've found
> some white papers on oracle's site, but I think it's
> not enough for me. I was wondering what is the algorithm that
> monitors the distribution of memory and changes it as needed.
> Does ASMM takes the advantage of Oracle's snapshots and performance
> views?
>
> A lot of thanks
> Adam

I do not Oracle has published or ever will publish the actual detailed algorithm behind ASMM. Doing so would be of little benefit to the average database user though the low level details might be of benefit to the competition.

Oracle does provide views that allow a DBA to see what ASMM actions are currently in process and what ASMM activities have been done in the past, etc...: v$sga_current_resize_ops and v$sga_dynamic_components.

If you list the metalink notes you have read then board readers can compare the list to any the reader may have recorded or copied and may also recommend third-party articles on the subject that may be of use to you.

HTH -- Mark D Powell -- Received on Sun Feb 10 2008 - 12:07:59 CST