Saturday 7 January 2012

ORA-00381: cannot use both new and old parameters for buffer cache size specification

ORA-00381: cannot use both new and old parameters for buffer cache size specification

Cause: User specified one or more of { db_cache_size , db_recycle_cache_size, db_ keep_cache_size, db_nk_cache_size (where n is one of 2,4,8,16,32), db_cache_ advice } AND one or more of { db_block_buffers, buffer_pool_keep , buffer_pool_ recycle }. This is illegal.

Action: Use EITHER the old (pre-Oracle_8.2) parameters OR the new ones. Don t specify both. If old size parameters are specified in the parameter file, you may want to replace them with new parameters since the new parameters can be modified dynamically and allow you to configure additional caches for additional block sizes. Cache advisory can only be enabled with the new cache parameters.

No comments:

Post a Comment