Oracle Database Discussions

Hi,

I got a following error when I was adding new log file group. I searched and found the answer on form. There is 4M minimum size of a log file size in 11g R2.

My question is Why does a log file size depend on DB_BLOCK_SIZE? This parameter set for memory structure component that create in an instance while a log file is a operating system file that depend on OS version not DB_BLOCK_SIZE.

Thanks.

SQL> alter database add logfile group 4 'c:\app\asif\oradata\employee\redo04.log' size 1m;
alter database add logfile group 4 'c:\app\asif\oradata\employee\redo04.log' size 1m
*
ERROR at line 1:
ORA-00336: log file size 2048 blocks is less than minimum 8192 blocks

SQL> show parameter db_block_size

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_block_size                        integer     8192
SQL>