ORA-00824: cannot set SGA_TARGET or MEMORY_TARGET

玉面飞龙

最初由 itpub.com.cn 发布
[B]show parameter db_cache_size
if you set db_cache_size>0 then you can't set memory_target or sga_target [/B]

SQL> startup pfile=initTEST.ora
ORA-32006: USER_DUMP_DEST initialization parameter has been deprecated
ORA-32006: LOG_ARCHIVE_START initialization parameter has been deprecated
ORA-32006: SQL_TRACE initialization parameter has been deprecated
ORA-00824: cannot set SGA_TARGET or MEMORY_TARGET due to existing internal settings, see alert log for more information
ORA-01078: failure in processing system parameters


oracle@sles9:/export/home/oracle/products/11106/dbs> tail initTEST.ora
sql_trace=FALSE
statistics_level=basic
undo_management='AUTO'
undo_retention=4000
undo_tablespace='UNDOTBS1'
MEMORY_MAX_TARGET = 150M
  MEMORY_TARGET = 150M
SGA_TARGET =0
PGA_AGGREGATE_TARGET = 0
  db_cache_size =0
oracle@sles9:/export/home/oracle/products/11106/dbs>

itpub.com.cn

最初由 玉面飞龙 发布
[B]

SQL> startup pfile=initTEST.ora
ORA-32006: USER_DUMP_DEST initialization parameter has been deprecated
ORA-32006: LOG_ARCHIVE_START initialization parameter has been deprecated
ORA-32006: SQL_TRACE initialization parameter has been deprecated
ORA-00824: cannot set SGA_TARGET or MEMORY_TARGET due to existing internal settings, see alert log for more information
ORA-01078: failure in processing system parameters


oracle@sles9:/export/home/oracle/products/11106/dbs> tail initTEST.ora
sql_trace=FALSE
statistics_level=basic
undo_management='AUTO'
undo_retention=4000
undo_tablespace='UNDOTBS1'
MEMORY_MAX_TARGET = 150M
  MEMORY_TARGET = 150M
SGA_TARGET =0
PGA_AGGREGATE_TARGET = 0
  db_cache_size =0
oracle@sles9:/export/home/oracle/products/11106/dbs> [/B]

db_block_buffers呢？
db_block_buffers>0 ?