副问题[/!--empirenews.page--]
概述
在 Oracle 11g 安装并建库后,必要举办一些调解,使数据库可以或许不变、高效地运行。花了一段时刻清算了以下的参数配置类型,仅供参考。
一、建库参数配置
1、历程及会话数(默认150)
- --查察历程及会话数
- show parameter process;
- show parameter sessions;
- --修改造程及会话数
- alter system set processes=1200 scope=spfile;
- alter system set sessions=1325 scope=spfile;
参考:sessions = 1.1 * processes + 5
2、游标数
- --查察游标数
- show parameter open_cursors;
- --查察当前打开的游标数量
- select count(*) from v$open_cursor;
- --修改最大游标数
- alter system set open_cursors=1000 scope=both
3、字符集(提议建库时就配置好)
- --查询数据库处事端的字符集:NLS_LANG = language_territory.charset
- select * from nls_database_parameters;
- --常见处事器参数配置
- export NLS_LANG=AMERICAN_AMERICA.UTF8
- export NLS_LANG=AMERICAN_AMERICA.AL32UTF8
4、sga pga巨细
oltp体系参考(要配置好,防备内存发抖): sga=内存*80%*80% pga=内存*80%*20%
- show parameter memory;
- show parameter sga;
- show parameter pga;
- --假如要防备高并发环境下的内存发抖,思量牢靠内存
- alter system set memory_target=4096m scope=spfile;
- alter system set memory_max_target=4096m scope=spfile;
- alter system set sga_target=3027m scope=spfile;
- alter system set sga_max_size=3027m scope=spfile;
- alter system set pga_aggregate_target=3027m scope=spfile;
- alter system set pga_aggregate_target=1024m scope=spfile;
5、节制文件
声名:节制文件默认2个,提议增进一个在差异位置
- show parameter control;
- alter system set control_files="/oracle/redolog/RFDB/controlfile/o1_mf_gjrb59v8_.ctl","/u01/app/oracle/product/11.2.0/db_1/dbs/control02.ctl" scope=spfile;
- shutdown immediate;
- !cp /oracle/redolog/RFDB/controlfile/o1_mf_gjrb59v8_.ctl /u01/app/oracle/product/11.2.0/db_1/dbs/control02.ctl
- startup;
- show parameter control;
6、redo日记
redo 默认50M, 改成100M或更大,详细按照天天发生redo的量来配置
- --查察相干配置
- select member from v$logfile;
- select group#,members,bytes/1024/1024,status from v$log;
- --增进日记组
- alter database add logfile group 4 ('/home/u01/app/oracle/oradata/nwppdb/redo04.log') size 100M;
- alter database add logfile group 5 ('/home/u01/app/oracle/oradata/nwppdb/redo05.log') size 100M;
- alter database add logfile group 6 ('/home/u01/app/oracle/oradata/nwppdb/redo06.log') size 100M;
- --redo每组默认3组每组一个成员,提议每组两个成员以上
- alter database add logfile member '/home/u01/app/oracle/oradata/nwppdb/redo04_2.log' to group 4;
- alter database add logfile member '/home/u01/app/oracle/oradata/nwppdb/redo05_2.log' to group 5;
- alter database add logfile member '/home/u01/app/oracle/oradata/nwppdb/redo06_2.log' to group 6;
- --切换
- alter system switch logfile;
- --删除之前小的日记组
- alter database drop logfile group 1;
- alter database drop logfile group 2;
- alter database drop logfile group 3;
(编辑:河北网)
【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容!
|