1、关闭审计日志
alter system set audit_trail=none scope=spfile;
查看审计日志状态,已关闭
SQL> show parameter audit_trail
NAME TYPE VALUE
audit_trail string NONE
2、关闭trace日志
alter system set trace_enabled=false;
3、修改统计信息收集时间
select dbms_stats.get_stats_history_retention from dual;
begin
dbms_stats.alter_stats_history_retention(7);
end;
4、修改快照保存时间
exec dbms_workload_repository.modify_baseline_window_size(2);
5、修改最大连接数
alter system set processes = 3000 scope = spfile;
select value from v$parameter where name ='processes';