任务：修改参数
--1)关闭内存自动管理，设置SGA,PGA分别自动管理，SGA=500,PGA=200
SYS@ENMOEDU>alter system set sga_target=500M scope=spfile;
System altered.
SYS@ENMOEDU>alter system set pga_aggregate_target=200M scope=spfile;
System altered.
SYS@ENMOEDU>alter system set memory_target=0 scope=spfile;
System altered.
SYS@ENMOEDU>
--2)修改参数db_domain为us.oracle.cn
SYS@ENMOEDU>show parameter domain
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_domain string
SYS@ENMOEDU>
SYS@ENMOEDU>alter system set db_domain='us.oracle.cn' scope=spfile;
System altered.
SYS@ENMOEDU>
--3)满足300个并发会话
SYS@ENMOEDU>show parameter processes
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
aq_tm_processes integer 1
db_writer_processes integer 1
gcs_server_processes integer 0
global_txn_processes integer 1
job_queue_processes integer 1000
log_archive_max_processes integer 4
processes integer 150
SYS@ENMOEDU>
SYS@ENMOEDU>show parameter sessions
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
java_max_sessionspace_size integer 0
java_soft_sessionspace_limit integer 0
license_max_sessions integer 0
license_sessions_warning integer 0
sessions integer 247
shared_server_sessions integer
SYS@ENMOEDU>
SYS@ENMOEDU>alter system set processes=300 scope=spfile;
System altered.
SYS@ENMOEDU>
--4)90分钟内，避免出现ORA-01555错误
SYS@ENMOEDU>show parameter undo
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
undo_management string AUTO
undo_retention integer 900
undo_tablespace string UNDOTBS1
SYS@ENMOEDU>
SYS@ENMOEDU>
SYS@ENMOEDU>select 90*60 from dual;
90*60
----------
5400
SYS@ENMOEDU>alter system set undo_retention=5400;
System altered.
SYS@ENMOEDU>show parameter undo
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
undo_management string AUTO
undo_retention integer 5400
undo_tablespace string UNDOTBS1
SYS@ENMOEDU>
--5)开启审计，OS
SYS@ENMOEDU>show parameter audit_trail
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
audit_trail string DB
SYS@ENMOEDU>
SYS@ENMOEDU>alter system set audit_trail=os scope=spfile;
System altered.
SYS@ENMOEDU>
--重启，验证参数
SYS@ENMOEDU>
SYS@ENMOEDU>shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SYS@ENMOEDU>
SYS@ENMOEDU>startup
ORACLE instance started.
Total System Global Area 521936896 bytes
Fixed Size 2254824 bytes
Variable Size 251660312 bytes
Database Buffers 264241152 bytes
Redo Buffers 3780608 bytes
Database mounted.
Database opened.
SYS@ENMOEDU>
SYS@ENMOEDU>
SYS@ENMOEDU>show parameter target
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
archive_lag_target integer 0
db_flashback_retention_target integer 1440
fast_start_io_target integer 0
fast_start_mttr_target integer 0
memory_max_target big integer 0
memory_target big integer 0
parallel_servers_target integer 16
pga_aggregate_target big integer 200M
sga_target big integer 500M
SYS@ENMOEDU>
SYS@ENMOEDU>show parameter domain
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_domain string us.oracle.cn
SYS@ENMOEDU>
SYS@ENMOEDU>show parameter processes
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
aq_tm_processes integer 1
db_writer_processes integer 1
gcs_server_processes integer 0
global_txn_processes integer 1
job_queue_processes integer 1000
log_archive_max_processes integer 4
processes integer 300
SYS@ENMOEDU>show parameter sessions
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
java_max_sessionspace_size integer 0
java_soft_sessionspace_limit integer 0
license_max_sessions integer 0
license_sessions_warning integer 0
sessions integer 472
shared_server_sessions integer
SYS@ENMOEDU>
SYS@ENMOEDU>
SYS@ENMOEDU>show parameter audit
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
audit_file_dest string /u01/app/oracle/admin/ENMOEDU/
adump
audit_sys_operations boolean FALSE
audit_syslog_level string
audit_trail string OS
SYS@ENMOEDU>
--1)关闭内存自动管理，设置SGA,PGA分别自动管理，SGA=500,PGA=200
SYS@ENMOEDU>alter system set sga_target=500M scope=spfile;
System altered.
SYS@ENMOEDU>alter system set pga_aggregate_target=200M scope=spfile;
System altered.
SYS@ENMOEDU>alter system set memory_target=0 scope=spfile;
System altered.
SYS@ENMOEDU>
--2)修改参数db_domain为us.oracle.cn
SYS@ENMOEDU>show parameter domain
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_domain string
SYS@ENMOEDU>
SYS@ENMOEDU>alter system set db_domain='us.oracle.cn' scope=spfile;
System altered.
SYS@ENMOEDU>
--3)满足300个并发会话
SYS@ENMOEDU>show parameter processes
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
aq_tm_processes integer 1
db_writer_processes integer 1
gcs_server_processes integer 0
global_txn_processes integer 1
job_queue_processes integer 1000
log_archive_max_processes integer 4
processes integer 150
SYS@ENMOEDU>
SYS@ENMOEDU>show parameter sessions
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
java_max_sessionspace_size integer 0
java_soft_sessionspace_limit integer 0
license_max_sessions integer 0
license_sessions_warning integer 0
sessions integer 247
shared_server_sessions integer
SYS@ENMOEDU>
SYS@ENMOEDU>alter system set processes=300 scope=spfile;
System altered.
SYS@ENMOEDU>
--4)90分钟内，避免出现ORA-01555错误
SYS@ENMOEDU>show parameter undo
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
undo_management string AUTO
undo_retention integer 900
undo_tablespace string UNDOTBS1
SYS@ENMOEDU>
SYS@ENMOEDU>
SYS@ENMOEDU>select 90*60 from dual;
90*60
----------
5400
SYS@ENMOEDU>alter system set undo_retention=5400;
System altered.
SYS@ENMOEDU>show parameter undo
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
undo_management string AUTO
undo_retention integer 5400
undo_tablespace string UNDOTBS1
SYS@ENMOEDU>
--5)开启审计，OS
SYS@ENMOEDU>show parameter audit_trail
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
audit_trail string DB
SYS@ENMOEDU>
SYS@ENMOEDU>alter system set audit_trail=os scope=spfile;
System altered.
SYS@ENMOEDU>
--重启，验证参数
SYS@ENMOEDU>
SYS@ENMOEDU>shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SYS@ENMOEDU>
SYS@ENMOEDU>startup
ORACLE instance started.
Total System Global Area 521936896 bytes
Fixed Size 2254824 bytes
Variable Size 251660312 bytes
Database Buffers 264241152 bytes
Redo Buffers 3780608 bytes
Database mounted.
Database opened.
SYS@ENMOEDU>
SYS@ENMOEDU>
SYS@ENMOEDU>show parameter target
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
archive_lag_target integer 0
db_flashback_retention_target integer 1440
fast_start_io_target integer 0
fast_start_mttr_target integer 0
memory_max_target big integer 0
memory_target big integer 0
parallel_servers_target integer 16
pga_aggregate_target big integer 200M
sga_target big integer 500M
SYS@ENMOEDU>
SYS@ENMOEDU>show parameter domain
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_domain string us.oracle.cn
SYS@ENMOEDU>
SYS@ENMOEDU>show parameter processes
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
aq_tm_processes integer 1
db_writer_processes integer 1
gcs_server_processes integer 0
global_txn_processes integer 1
job_queue_processes integer 1000
log_archive_max_processes integer 4
processes integer 300
SYS@ENMOEDU>show parameter sessions
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
java_max_sessionspace_size integer 0
java_soft_sessionspace_limit integer 0
license_max_sessions integer 0
license_sessions_warning integer 0
sessions integer 472
shared_server_sessions integer
SYS@ENMOEDU>
SYS@ENMOEDU>
SYS@ENMOEDU>show parameter audit
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
audit_file_dest string /u01/app/oracle/admin/ENMOEDU/
adump
audit_sys_operations boolean FALSE
audit_syslog_level string
audit_trail string OS
SYS@ENMOEDU>
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/31400681/viewspace-2130615/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
