Ask the Expert

Why am I getting the ORA-00381 error when initializing the parameter?

I am initializing the parameter db_keep_cache_sizing. After modifying the value while restarting my database, an error is occurring: ORA-00381: cannot use both new and old parameters for buffer cache size specification. Why am I getting this error?

    Requires Free Membership to View

The old parameters to size the buffer cache are:

DB_BLOCK_BUFFERS, BUFFER_POOL_KEEP, and BUFFER_POOL_RECYCLE

The new parameters to size the buffer cache components are:

DB_CACHE_SIZE, DB_KEEP_CACHE_SIZE, and DB_RECYCLE_CACHE_SIZE

You cannot mix and match these parameters. I would bet that you set DB_KEEP_CACHE_SIZE and also have DB_BLOCK_BUFFERS set. As the ORA-381 error states, you cannot use the old parameters with the new ones. So, change DB_BLOCK_BUFFERS to DB_CACHE_SIZE (but keep in mind that the old parm denotes the number of blocks, and the new parm denotes the number of bytes, so you will have to perform some conversion here).

This was first published in May 2008

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: