Set shared_pool when using ASMM and AMM

After the introduction of asmm from 10 Gb, compared with the previous manual adjustment of various memory components, this makes a huge step forward in automatic management. DBA only needs to define sga_target and sga_max_target. Other things are handled by Oracle itself.

The 11g introduces amm. You only need to define memory_target and memory_max_target. oracle automatically allocates components in pga and sga. Everything becomes simpler.

We need to pay special attention to the adjustments to the shared_pool. We know that shared _ pool is very important. In the automatically managed environment, other memory components may occupy the shared_pool space, when the shared_pool space is insufficient, various problems may occur. In severe cases, the database will be hang, which is also called memory bumps. It is worth mentioning that the size of various components can be defined in the environment of automatic memory management. At this time, the definition is to indicate the minimum value of a component. Therefore, it is recommended that you manually set a minimum value for shared_pool_size to ensure that the shared_pool is not too small and causes various problems. The initial size is set to (memory_target * 0.6) * 0.4. Observe for a period of time and make some modifications based on the actual situation.

A bug may occur when memory bumps occur. For details, refer to the mos documentation or set the _ memory_broker_stat_interval parameter to define the time for each resize operation (which may be adjusted or not adjusted ), the default value is 30 seconds. In v $ sga_resize_ops, the resize operation is performed.

In addition, db_recycle_cache_size and db_keep_cache_size must be set manually.

-------------------------------------- Split line --------------------------------------

Incomplete Oracle database recovery

Time-point-based Incomplete recovery for RMAN backup and recovery

In archive mode, the same backup of RMAN is used twice for Incomplete recovery.

RMAN full database [full recovery/Incomplete recovery]

CentOS 5.2x86 install Oracle 11g R2 notes

Install Oracle 11gR2 (x64) in CentOS 6.4)

Steps for installing Oracle 11gR2 in vmwarevm

-------------------------------------- Split line --------------------------------------