v$pgastat | ...and Oracle answers for all

Automatic memory management

25/03/2018 2 Comments

Starting with the Oracle database 11g version, there is an useful and Oracle recommended option to manage automatically the memory. When you modify some parameters of the instance, it can be implemented easily.

With this option, you just have to analyze the memory size that you want to establish and Oracle will administer its structures automatically. Its name is Automatic Memory Management (AMM). Read more of this post

Filed under Database Tagged with amm, asmm, automatic memory management, automatic shared memory managemet, lock_sga, memory_max_target, memory_target, pfile, pga, sga_max_size, sga_target, spfile, v$memory_dynamic_components, v$memory_target_advice, v$parameter, v$pgastat, v$sgainfo, v$sga_target_advice

…and Oracle answers for all

Automatic memory management

Hits

Help documentation

Oracle gurus

Suscribe to OrAnswer

…and Oracle answers for all

Automatic memory management

Share this:

Hits

Help documentation

Oracle gurus

Suscribe to OrAnswer