Saturday, July 11, 2015

Standby MRP crashing due to ORA-00379: no free buffers available in buffer pool DEFAULT for block size 16K


Cause : 
SQL> show parameter 16k

NAME                                 TYPE
------------------------------------ --------------------------------
VALUE
------------------------------
db_16k_cache_size                    big integer
0                                                                                        <<<<<<<<<<< Not set value
SQL>



Solution :
1.)
SQL> alter system set db_16k_cache_size=512M scope=SPFILE;

System altered.


Note: value of this parameter must in multiple of 16k.


2.)Restart DB


>>>> Note : To take effect of this parameter value, DB restart is required.



No comments:

Post a Comment