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-16609: one or more resources have failed

1 Answers  


ORA-12497: maximum combined categories exceeds string

1 Answers  


ORA-02719: osnfop: fork failed

1 Answers  


LFI-01007: Line is too long; encountered in function string.

1 Answers  


LRM-00123: invalid character number found in the input file

1 Answers   BSNL, IBM,






ORA-06020: NETASY: initialisation failure

1 Answers  


ORA-31519: CDC subscription string already exists

1 Answers  


NNO-00314: error changing trace level from number to number, level change ignored

1 Answers  


ORA-29963: missing BINDING keyword

1 Answers  


ORA-22925: operation would exceed maximum size allowed for a LOB value

1 Answers  


ORA-39503: failed to notify CRS of a Startup/Shutdown event [number] (ignored)

1 Answers  


ORA-24381: error(s) in array DML

1 Answers  


Categories