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

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: 4579
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.
Previous Topic: More "SQL*Net message to/from client" than expected
Next Topic: Improving materialized view performance
Goto Forum:
  


Current Time: Thu Mar 28 20:20:40 CDT 2024