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..

Answer / guest

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.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-19334: Invalid column specification for CREATE_DBURI operator

1 Answers  


NNL-00410: Average response time: string

1 Answers  


ORA-24048: cannot create QUEUE_TABLE, user does not have access to AQ object types

1 Answers  


ORA-16703: cannot set the property while the database is enabled

1 Answers  


ORA-07456: cannot set RESOURCE_MANAGER_PLAN when database is closed

1 Answers  


ORA-07601: spguno: $GETJPIW failure

1 Answers  


ORA-30477: The input select_clause is incorrectly specified

1 Answers  


NID-00422: Change of database ID failed during validation - database is intact.

1 Answers  


ORA-03214: File Size specified is smaller than minimum required

1 Answers  


RMAN-06504: PROXY option with multiple backup copies is not supported

1 Answers  


RMAN-08113: including current SPFILE in backupset

1 Answers  


ORA-38749: A media recovery has been started.

1 Answers  


Categories