Path: text.usenetserver.com!out02b.usenetserver.com!news.usenetserver.com!in02.usenetserver.com!news.usenetserver.com!postnews.google.com!n20g2000hsh.googlegroups.com!not-for-mail From: Mark D Powell Newsgroups: comp.databases.oracle.server Subject: Re: Automatic Shared Memory Management Date: Sun, 10 Feb 2008 10:07:59 -0800 (PST) Organization: http://groups.google.com Lines: 31 Message-ID: <4ace74f5-e8ba-44e1-9b63-0f3fd82d7fa9@n20g2000hsh.googlegroups.com> References: NNTP-Posting-Host: 69.245.99.253 Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Trace: posting.google.com 1202666879 19396 127.0.0.1 (10 Feb 2008 18:07:59 GMT) X-Complaints-To: groups-abuse@google.com NNTP-Posting-Date: Sun, 10 Feb 2008 18:07:59 +0000 (UTC) Complaints-To: groups-abuse@google.com Injection-Info: n20g2000hsh.googlegroups.com; posting-host=69.245.99.253; posting-account=qJFqbQkAAACYQSLN0-cvP6ydkRfuOu6u User-Agent: G2/1.0 X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 1.0.3705; .NET CLR 1.1.4322; .NET CLR 2.0.50727),gzip(gfe),gzip(gfe) Xref: usenetserver.com comp.databases.oracle.server:441358 X-Received-Date: Sun, 10 Feb 2008 13:08:00 EST (text.usenetserver.com) On Feb 10, 9:20 am, "mrow...@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 --