1.用户进程数（修改process=300，重启库后查询）满足300个并发会话
SQL> alter system set processes=300 scope=spfile;
System altered.
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
Total System Global Area 830930944 bytes
Fixed Size 2257800 bytes
Variable Size 591400056 bytes
Database Buffers 230686720 bytes
Redo Buffers 6586368 bytes
Database mounted.
Database opened.
SQL> show parameter process;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
aq_tm_processes integer 1
cell_offload_processing boolean TRUE
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
processor_group_name string
2.诊断目录位置 (diagnostic_dest)在/u01/app/oracle。
SQL> show parameter diagnostic_dest;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
diagnostic_dest string /u01/app/oracle
3.关闭内存自动管理，设置SGA,PGA分别自动管理，SGA=500,PGA=200
SQL> alter system set sga_target=500M scope=spfile;
System altered.
SQL>alter system set pga_aggregate_target=200 scope=spfile;
System altered.
SQL> alter system set memory_target=0 scope=spfile;
System altered.
4.修改参数db_domain为us.oracle.cn
SQL> show parameter domain
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_domain string
SQL> alter system set db_domain='us.oracle.cn' scope=spfile;
System altered.
5.90分钟内，避免出现ORA-01555错误
SQL> show parameter undo
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
undo_management string AUTO
undo_retention integer 900
undo_tablespace string UNDOTBS1
SQL> alter system set undo_retention = 5400;
System altered.
SQL> show parameter undo;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
undo_management string AUTO
undo_retention integer 5400
undo_tablespace string UNDOTBS1
6.开启审计，OS
SQL> show parameter audit_trail
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
audit_trail string DB
SQL> alter system set audit_trail = os scope=spfile;
System altered.