SQL> alter system set aq_tm_processes=10 scope=both; 指定队列监视进程个数,默认值为0,最大值为10 SQL> alter system set open_cursors=500 scope=both; 开启游标数 SQL> alter system set open_links=255 scope=spfile; 单个session连接数 SQL> alter system set session_cached_cursors=300 scope=spfile; 单个session可以缓存多少coursor SQL> alter system set log_archive_dest_1='location=/arch/*****' scope=both; 修改归档目录 SQL> shutdown immediate SQL> startup mount SQL> alter database archivelog ; 修改归档模式 SQL> alter database open; SQL> alter system set fast_start_mttr_target=900 scope=both; 数据库恢复秒数 SQL> alter system set db_flashback_retention_target=10080 scope=both; 闪回时间7天 SQL> alter system set undo_retention=10800 scope=both; 回滚时间3小时 SQL>alter system set "_optim_peek_user_binds"=false scope=spfile; 绑定变量窥测 SQL>alter system set "_optimizer_extended_cursor_sharing_rel"=none scope=spfile; SQL>alter system set "_optimizer_extended_cursor_sharing"=none scope=spfile; SQL>alter system set "_optimizer_adaptive_cursor_sharing"=false scope=spfile; SQL>alter system set "_in_memory_undo"=FALSE scope=spfile; SQL>alter system set "_gc_policy_time"=0 scope=spfile; SQL>alter system set "_memory_imm_mode_without_autosga"=FALSE scope=both; SQL>alter system set "_b_tree_bitmap_plans"=FALSE scope=spfile; 隐含参数,建议修改 SQL>alter system set db_securefile='NEVER' scope=spfile; 安全文件 SQL>alter system set deferred_segment_creation=FALSE scope=spfile; 段延迟创建,只读表空间建表 SQL>alter system set memory_target=0 scope=spfile; SQL>alter system set memory_max_target=0 scope=spfile;取消自动内存管理 SQL> shutdown immediate SQL> startup mount SQL> alter database flashback on; 开启闪回(后期生产可以关闭) SQL> alter database open; SQL> alter system switch logfile; SQL> alter database add supplemental log data;开启附加日志 SQL>手动修改system、sysaux、users、undtbs、temp表空间大小 SQL>手动修改sga、pga大小 SQL>手动修改redo日志组数量和大小 SQL>参数processes,job_queue_processes等根据需要进行修改 |
|