DBCA库安装后sql语句优化

SQL plus下运行：

alter system set deferred_segment_creation=false scope=spfile;
alter system set event= '10949 trace name context forever, level 1' scope=spfile;
alter system set remote_dependencies_mode='SIGNATURE';
alter system set "_serial_direct_read"=never;

alter system set "_partition_large_extents"=false;
alter system set filesystemio_options=asynch scope=spfile;
alter system set "_enable_NUMA_optimization"=false scope=spfile;
alter system set "_gc_policy_time"=0 scope=spfile;
alter system set open_cursors=5000 scope=spfile;
alter system set session_cached_cursors=2000 scope=spfile;
alter system set open_links=150 scope=spfile;
alter system set open_links_per_instance=150 scope=spfile;

alter system set control_file_record_keep_time=45 scope=spfile;
alter profile default limit password_life_time unlimited;
alter profile default limit failed_login_attempts unlimited;
--密码过期及登录10次锁定限制更改

--关闭sql优化顾问
begin
dbms_auto_task_admin.disable
(
client_name => 'sql tuning advisor',
operation => null,
window_name => null
);
end;
/

col action_time for a35
col comments for a25
select action_time,id,comments from dba_registry_history;

@?/rdbms/admin/catbundle.sql psu apply