Home » RDBMS Server » Performance Tuning » Automatic Shared Memory Management (ASMM) !!
Automatic Shared Memory Management (ASMM) !! [message #177743] Fri, 16 June 2006 06:51 Go to next message
AlinaC
Messages: 45
Registered: November 2005
Location: India
Member

In Oracle10G ReL 2 if I implement Automatic Shared Memory Management (ASMM), it will dynamically allocate or de-allocate memory for db buffer chache, shared pool,large pool,java pool etc. But will it dynamically allocate space for Keep pool or will it be constant as per requirement, if so how do I determine and set the size of keep poll as I want to put small and frequently tables in keep pool to improve performance. ?

Regards,

Alina

Report message to a moderator

Re: Automatic Shared Memory Management (ASMM) !! [message #177818 is a reply to message #177743] Fri, 16 June 2006 13:08 Go to previous message
Frank Naude
Messages: 4581
Registered: April 1998
Senior Member
DB_KEEP_CACHE_SIZE is a manually sized component. So, you need to estimate you big it should be and set it yourself.

PS: Remember, the DB_KEEP_CACHE_SIZE value will be deducted from your SGA_TARGET parameter value.

Report message to a moderator

Previous Topic: More "SQL*Net message to/from client" than expected
Next Topic: Improving materialized view performance
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Nov 27 05:44:59 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.