Re: Automatic Shared Memory Management needs Diagnostics Pack license?

Please check the following article:

http://www.oracleadvice.com/10g/10g_autosharedmemory.htm

"... Automatic Shared Memory Management
This is an important enhancement of Oracle10g and expands on the ability to dynamically resize SGA components. By allowing Oracle to automatically adjust how much shared memory is allocated to each SGA structure, you can make optimal use of buffer cache memory and at the same time decrease the likelihood of shared pool related ORA-04031 errors.
..."

This is an Oracle 10g feature, any ideas if I need the Diagnostics Package license?
Thanks!
Ana

Mark D Powell wrote:

> Ana Ribeiro wrote:
> > Hi all,
> > If I use the Oracle 10g feature "Automatic Shared Memory Management" I
> > need to buy the Diagnostics Pack license?
> >
> > Just to test, I used the ASMM in a test environment (enabling and
> > disabling ASMM) and I could not find any row in the
> > dba_feature_usage_statistics showing that I used this feature. There is
> > no "SGA/Memory Advisor" row in this view! In fact, there is a "Dynamic
> > SGA" row in this view, but this feature was used 1 month ago, the
> > LAST_USAGE_DATE column is not the current date... (My database version
> > is Oracle 10.1.0.2.0)
> >
> > Does it mean I can use the ASMM feature even without having the
> > Diagnostics Pack license?
> >
> > Many thanks in advance for the help!
> > Ana
>
> What features do you consider to be "Automatic Shared Memory
> Management?" Are you actually referring to an EM screen rather than
> the feature?
>
> The Oracle rdbms feature related to automatically managing the Shared
> Pool where it re-assigns memory to the buffer cache, shared pool,
> etc... are not related to the AWR feature and were included with the db
> starting with version 9
>
> -- Mark D Powell --
Received on Fri Sep 29 2006 - 08:33:46 CDT