- Create at least two ASM disk groups.
- Use external redundancy, leaving the RAID functionality to the storage array.
- Place the online files into the first disk group.
- Place backup files and Flashback Area into the second disk group.
–If using the Flashback Area, be aware that a mirror copy of the online redo logs is placed in this area by default.
- Present multiple LUNs, as needed, to each of the ASM disk groups.
- Consider changing the _asm_ausize to 8 MB for DSS-like workloads.
- If one ASM to one db instance, use shared ORACLE_HOME.
- IF one ASM to many db isntances, use separate ORACLE_HOME
- The recommended SGA parameter sizes for ASM are as follows:
‧ shared_pool_size = 128M
‧ large_pool = 12M
‧ db_cache_size = 64M
h71028.www7.hp.com/.../4AA0-9728ENW_ASM_EVA_Best_Practices_White_Paper_final%20121806.pdf

Post a Comment