How to calculate and setup log_buffer parameter for oracle 11gR2 database
856156Jan 24 2012 — edited Jan 25 2012I am seeking advice from gurus for log_buffer parameter setting. My database is 11gR2 and database server is Linux x86 64 bite. I am using Flashback and data guard as well as automatic memory management. My SGA_MAX_SIZE 10G
SGA_TARGET 6G. How to calculate log_buffer? Log_buffer is manual setting and is not in automatic memory management pool. Log_buffer is decided by granule_size and SGA_TARGET. My granule_size is 16777216 (bytes). Please advise the steps how to do calculation. I need to consider Flashback and data guard factors for the database. Thank you in advance.