11gr2簡單安裝後的一些引數調整

selectshen發表於2015-08-04
--修改密碼有效期及遮蔽密碼延遲驗證
alter profile default limit password_life_time unlimited;
ALTER SYSTEM SET EVENT = '28401 TRACE NAME CONTEXT FOREVER, LEVEL 1' SCOPE = SPFILE;

--修改控制檔案中保留歸檔記錄和備份記錄的天數
alter system set control_file_record_keep_time=15;

--修改單個會話開啟和快取遊標的數量,之後再根據實際情況調整
alter system set session_cached_cursors=300 scope=spfile;
alter system set open_cursors=1000;

--修改redo log的成員數及大小,大小之後再根據實際情況調整
--select * from v$log;
--alter system switch logfile;
--alter system checkpoint;
ALTER DATABASE DROP LOGFILE GROUP 1;
ALTER DATABASE ADD LOGFILE  GROUP 1 '/u02/oradata/orcl/redo01a.log' SIZE 512 M ;
ALTER DATABASE ADD LOGFILE MEMBER   '/u03/oradata/orcl/redo01b.log'  TO GROUP 1 ;
ALTER DATABASE DROP LOGFILE GROUP 2;
ALTER DATABASE ADD LOGFILE  GROUP 2 '/u02/oradata/orcl/redo02a.log' SIZE 512 M ;
ALTER DATABASE ADD LOGFILE MEMBER   '/u03/oradata/orcl/redo02b.log'  TO GROUP 2 ;
ALTER DATABASE DROP LOGFILE GROUP 3;
ALTER DATABASE ADD LOGFILE  GROUP 3 '/u02/oradata/orcl/redo03a.log' SIZE 512 M ;
ALTER DATABASE ADD LOGFILE MEMBER   '/u03/oradata/orcl/redo03b.log'  TO GROUP 3 ;

--修改控制檔案的路徑
alter system set control_files='/u02/oradata/orcl/control01.ctl','/u03/oradata/orcl/control02.ctl' scope=spfile;

--修改系統預設的scheduler window時間,根據實際情況調整
begin
  sys.dbms_scheduler.set_attribute(name => 'SYS.FRIDAY_WINDOW', attribute => 'repeat_interval', value => 'Freq=daily;ByDay=THU;ByHour=04;ByMinute=0;BySecond=0');
  sys.dbms_scheduler.set_attribute(name => 'SYS.MONDAY_WINDOW', attribute => 'repeat_interval', value => 'Freq=daily;ByDay=THU;ByHour=04;ByMinute=0;BySecond=0');
  sys.dbms_scheduler.set_attribute(name => 'SYS.SATURDAY_WINDOW', attribute => 'repeat_interval', value => 'Freq=daily;ByDay=THU;ByHour=04;ByMinute=0;BySecond=0');
  sys.dbms_scheduler.set_attribute(name => 'SYS.SUNDAY_WINDOW', attribute => 'repeat_interval', value => 'Freq=daily;ByDay=THU;ByHour=04;ByMinute=0;BySecond=0');
  sys.dbms_scheduler.set_attribute(name => 'SYS.THURSDAY_WINDOW', attribute => 'repeat_interval', value => 'Freq=daily;ByDay=THU;ByHour=04;ByMinute=0;BySecond=0');
  sys.dbms_scheduler.set_attribute(name => 'SYS.TUESDAY_WINDOW', attribute => 'repeat_interval', value => 'Freq=daily;ByDay=THU;ByHour=04;ByMinute=0;BySecond=0');
  sys.dbms_scheduler.set_attribute(name => 'SYS.WEDNESDAY_WINDOW', attribute => 'repeat_interval', value => 'Freq=daily;ByDay=THU;ByHour=04;ByMinute=0;BySecond=0');
end;

--修改awr採集頻率及保留時間
begin
  dbms_workload_repository.modify_snapshot_settings(interval => 30,retention => 60*24*60);
end;


來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/28539951/viewspace-1761859/，如需轉載，請註明出處，否則將追究法律責任。

相關文章