init.ora 기본 파라미터 변경 for 11gr2 on aix

show parameter job_queue_processes;

show parameter commit_write;

show parameter  processes;

alter system set job_queue_processes=0 scope=both;

alter system set commit_write='batch,nowait' scope=both;

alter system set processes=400 scope=spfile;

-------------- 

show parameter  parallel_max_servers;
show parameter  open_cursors ;
show parameter  log_checkpoints_to_alert ;

show parameter log_checkpoint_timeout;

#show parameter  dml_locks;

alter system set parallel_max_servers=16 scope=both;

alter system set open_cursors=2000 scope=both;

#alter system set log_checkpoints_to_alert=TRUE scope=spfile;

alter system set log_checkpoint_timeout=0 scope=both; 

#alter system set dml_locks=100 scope=spfile;