Forums | Aggregator | Books | Industry News | Firefox Plugins | Social | Links

Comments

Automatic Memory Management (AMM) in Oracle Database 11g Release 1 - Oracle 11g takes the next step down the road to making manual memory management a thing of the past.



Aman.... said...

Hi sir,
Very good article.Can you please some more information in it about how Memory Target works?
Regards
Aman....

Tim... said...

Hi.

You set it and leave Oracle to do the work. Apart from the normal monitoring you would expect, and maybe using the advisor, I don't see what else there is to say.

If you want to know about internals you might want to start by reading the links I've just added to the article.

Cheers

Tim...

Aman.... said...

Hi sir,
Thanks a ton sir.I shall read them.
Regards
Aman....

Dave H said...

In the article, you stated that you should set both MEMORY_TARGET to your required value, as well as setting PGA_AGGREGATE_TARGET to zero.


-- Set the dynamic parameters. Assuming Oracle has full control.
ALTER SYSTEM SET MEMORY_TARGET=5G SCOPE=SPFILE;
ALTER SYSTEM SET PGA_AGGREGATE_TARGET=0 SCOPE=SPFILE;
ALTER SYSTEM SET SGA_TARGET=0 SCOPE=SPFILE;


However we tripped over a little issue with that today, since setting PGA_AGGREGATE_TARGET=0 seems to disable PGA AMM altogether. See here for details:


http://download.oracle.com/docs/cd/B28359_01/server.111/b28274/memory.htm#i49320


You should probably try instead:


alter system reset PGA_AGGREGATE_TARGET scope=spfile;


Not tested this yet, but we suspect that this is our issue.

Hope this is useful to someone.

Regards,

Dave.


Trung Phan said...

Thanks for your advice.

It helps me to fix the issue.

Rgds, ... Trung
Prepared Statement Error: Table './oraclebasecms/cms_page_comment_uuids' is marked as crashed and should be repaired