alter system set audit_trail=NONE scope=spfile sid='*';
1
ALTER SYSTEM SET undo_retention=259200 SCOPE=BOTH sid='*';
2
ALTER TABLESPACE temp ADD tempfile SIZE 30G;
3
ALTER TABLESPACE temp ADD tempfile SIZE 30G;
4
ALTER TABLESPACE temp ADD tempfile SIZE 30G;
5
alter system set deferred_segment_creation=false scope=spfile sid='*';
6
alter system set enable_ddl_logging=true scope=both sid='*';
7
ALTER DATABASE ADD LOGFILE GROUP 4 SIZE 200M;
8
ALTER DATABASE ADD LOGFILE GROUP 5 SIZE 200M;
9
ALTER DATABASE ADD LOGFILE GROUP 6 SIZE 200M;
10
ALTER DATABASE ADD LOGFILE GROUP 7 SIZE 200M;
11
ALTER DATABASE ADD LOGFILE GROUP 8 SIZE 200M;
12
ALTER DATABASE ADD LOGFILE GROUP 9 SIZE 200M;
13
ALTER DATABASE ADD LOGFILE GROUP 10 SIZE 200M;
14
alter system set "_undo_autotune"=false scope=spfile sid='*';
15
alter profile DEFAULT limit PASSWORD_GRACE_TIME UNLIMITED;
16
alter profile DEFAULT limit PASSWORD_LIFE_TIME UNLIMITED;
17
alter profile DEFAULT limit PASSWORD_LOCK_TIME UNLIMITED;
18
alter profile DEFAULT limit FAILED_LOGIN_ATTEMPTS UNLIMITED;
19
20
alter system set processes=10000 scope=spfile sid='*';
21
alter system set db_files=2000 scope=spfile sid='*';
22
alter system set control_file_record_keep_time=31 scope=spfile sid='*';
23
alter system set open_cursors=3000 scope=spfile sid='*';
24
alter system set session_cached_cursors=300 scope=spfile sid='*';
25
ALTER SYSTEM SET SGA_TARGET=80G SCOPE=SPFILE;
26
ALTER SYSTEM SET SGA_MAX_SIZE=80G SCOPE=SPFILE;
27
ALTER SYSTEM SET PGA_AGGREGATE_TARGET=15G SCOPE=SPFILE;
28
29
alter TABLESPACE undotbs1 add DATAFILE SIZE 30G;
30
alter TABLESPACE undotbs1 add DATAFILE SIZE 30G;
31
alter TABLESPACE undotbs1 add DATAFILE SIZE 30G;
32
评论