Oracle DBA, How To, Error, Cause and Action

ORA-00825: cannot set DB_BLOCK_BUFFERS if SGA_TARGET or MEMORY_TARGET is set

ORA-00825: cannot set DB_BLOCK_BUFFERS if SGA_TARGET or MEMORY_TARGET is set


Cause:


SGA_TARGET or MEMORY_TARGET set with DB_BLOCK_BUFFERS set.



Action:


Do not set SGA_TARGET, MEMORY_TARGET or use new cache parameters, and do not use DB_BLOCK_BUFFERS which is an old cache parameter.

No comments:

Post a Comment

Thanks for your comment.

Subscribe to: Post Comments (Atom)