Why am I getting the ORA-00381 error when initializing the parameter?
An Oracle user asks why they are getting the ORA-00381 error when initializing the parameter.
DB_BLOCK_BUFFERS, BUFFER_POOL_KEEP, and BUFFER_POOL_RECYCLE
Continue Reading This Article
Enjoy this article as well as all of our content, including E-Guides, news, tips and more.
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).
Dig Deeper on Oracle database administration
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.
Meet all of our Oracle Database / Applications experts
View all Oracle Database / Applications questions and answers
Start the conversation
0 comments