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.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 16:36

ORA-00825：如果设置了SGA_TARGET或MEMORY_TARGET，则无法设置DB_BLOCK_BUFFERS,
.原因： SGA_TARGET或MEMORY_TARGET设置为DB_BLOCK_BUFFERS设置。,
.操作：不要设置SGA_TARGET，MEMORY_TARGET或使用新的缓存参数，并且不要使用旧的缓存参数DB_BLOCK_BUFFERS。,
.

aiaiDBA

13718043309

010-86462881

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

1 个回答

相似问题