Home / Oracle DBA / ASMM (AUTOMATIC SHARED MEMORY MANAGEMENT)

ASMM (AUTOMATIC SHARED MEMORY MANAGEMENT)

ASMM (AUTOMATIC SHARED MEMORY MANAGEMENT)

  1. In 9i, SGA has been made dynamic i.e. sizes of SGA components can be changed without shutting down the database. (not possible in 8i)
  1. Many times DBA’s faced problem in calculating correct memory sizes which lead to performance problems in instance level and DBA’s are more involved in handling instance tuning issues. To avoid this, oracle 10g introduced ASMM.
  1. The following memory components are automatically sized when using ASMM
    1. Shared pool
    2. database buffer cache
    3. large pool
    4. java pool
    5. stream pool
Note: LOG_BUFFER will not be automatically sized in any version. It’s a static parameter.
  1. Using ASMM, we can define total memory to SGA and oracle will decide how much to distribute to all caches. This is possible by setting SGA_TARGET parameter. (new in 10g)
Note: to enabled ASMM, we should define STATISTICS_LEVEL = TYPICAL (default) or ALL. To know more about ASMM.
  1. Maximum size for SGA is defined by SGA_MAX_SIZE. Depends on transactions load, SGA size will vary from SGA_TARGET to SGA_MAX_SIZE.
  2. It’s been observed that individual parameters are also defined in some 10g databases which means, those values will act as min values and SGA_TARGET value will act as medium and SGA_MAX_SIZE as max value.
  3. Oracle 10g introduced new background process MMAN in order to manage the memory for SGA components.
Note: Memory allocation to both SGA and PGA has been made automated in 11g using MEMORY_TARGET and MEMORY_MAX_TARGET parameters.
Note: SGA size is not at all dependent on database size and will be calculated based on the transactions hitting the database.
ASMM
Read More:
COMPONENTS OF ORACLE DATABASE ARCHITECTURE
LOGICAL STRUCTURES OF DATABASE
PHASES OF SQL EXECUTION
DON’T MISS OUT!
Subscribe To Newsletter
Be the first to get latest updates and exclusive content straight to your email inbox.
Stay Updated
Give it a try, you can unsubscribe anytime.

Check Also

Oracle 10g to 11g Enhancements (Difference between Oracle 10g and 11g)

Difference between Oracle 10g and 11g 1- Enhanced Automatic Memory Management System Oracle 9i automated …

Leave a Reply

Your email address will not be published. Required fields are marked *

DON’T MISS OUT!
Subscribe To Newsletter
Be the first to get latest updates and exclusive content straight to your email inbox.
Stay Updated
Give it a try, you can unsubscribe anytime.
close-link
GET OUR LATEST CONTENT IN YOUR INBOX

SUBSCRIBE 
Your information will never be shared
close-link
Enquiry
Submit
close-link
Sign-up for exclusive content. Be the first to hear about DBA Centre Blogs.
Subscribe