sga_max_size设置
来源:互联网 发布:淘宝网耳环 编辑:程序博客网 时间:2024/05/19 09:12
经查询发现X库的sga_max_size设置为1536M,很小:
SQL> show parameter sga
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
lock_sga boolean FALSE
pre_page_sga boolean FALSE
sga_max_size big integer 1536M
sga_target big integer 1536M
更改sga_max_size大小为物理内存(16G)的40%为6000M
SQL> alter system set sga_max_size=6000M scope=spfile;
System altered.
停掉两个节点的监听:
[oracle@linux1 ~]$ crs_stop ora.linux1.LISTENER_LINUX1.lsnr
[oracle@linux1 ~]$ crs_stop ora.linux2.LISTENER_LINUX2.lsnr
停库:
[oracle@linux1 ~]$ crs_stop ora.orcl.orcl1.inst
[oracle@linux1 ~]$ crs_stop ora.orcl.orcl2.inst
查询crs状态:
[oracle@linux1 ~]$ crs_stat -t
名称 类型 目标 状态 主机
------------------------------------------------------------
ora....SM1.asm application ONLINE ONLINE linux1
ora....X1.lsnr application ONLINE ONLINE linux1
ora.linux1.gsd application ONLINE ONLINE linux1
ora.linux1.ons application ONLINE ONLINE linux1
ora.linux1.vip application ONLINE ONLINE linux1
ora....SM2.asm application ONLINE ONLINE linux2
ora....X2.lsnr application ONLINE ONLINE linux2
ora.linux2.gsd application ONLINE ONLINE linux2
ora.linux2.ons application ONLINE ONLINE linux2
ora.linux2.vip application ONLINE ONLINE linux2
ora.orcl.db application OFFLINE OFFLINE
ora....l1.inst application OFFLINE OFFLINE
ora....l2.inst application OFFLINE OFFLINE
启动数据库:
[oracle@linux1 ~]$ crs_start ora.orcl.orcl2.inst
Attempting to start `ora.orcl.orcl2.inst` on member `linux2`
Start of `ora.orcl.orcl2.inst` on member `linux2` succeeded.
[oracle@linux1 ~]$ crs_start ora.orcl.orcl1.inst
Attempting to start `ora.orcl.orcl1.inst` on member `linux1`
Start of `ora.orcl.orcl1.inst` on member `linux1` succeeded.
[oracle@linux1 ~]$ crs_stat -t
名称 类型 目标 状态 主机
------------------------------------------------------------
ora....SM1.asm application ONLINE ONLINE linux1
ora....X1.lsnr application ONLINE ONLINE linux1
ora.linux1.gsd application ONLINE ONLINE linux1
ora.linux1.ons application ONLINE ONLINE linux1
ora.linux1.vip application ONLINE ONLINE linux1
ora....SM2.asm application ONLINE ONLINE linux2
ora....X2.lsnr application ONLINE ONLINE linux2
ora.linux2.gsd application ONLINE ONLINE linux2
ora.linux2.ons application ONLINE ONLINE linux2
ora.linux2.vip application ONLINE ONLINE linux2
ora.orcl.db application ONLINE ONLINE linux1
ora....l1.inst application ONLINE ONLINE linux1
ora....l2.inst application ONLINE ONLINE linux2
更改sga_target大小为6000M
分别在两个节点更改:(注意:不能在一个节点更改所有sga_target的大小)
LINUX1:
SQL> alter system set sga_target=6000M sid='orcl1';
System altered.
LINUX2:
SQL> alter system set sga_target=6000M sid='orcl2';
System altered.
sga_max_size和sga_target更改完毕。
- sga_max_size设置
- Oracle10G的Sga_max_size和sga_target应该如何设置
- sga_max_size设置过大导致ORALCE无法启动ORA-27100解决办法
- ora-00844和ora-00851错误,大致是指SGA_MAX_SIZE设置过大
- ora-00844和ora-00851错误,大致是指SGA_MAX_SIZE设置过大
- SGA_MAX_SIZE决定_ksm_granule_size
- 关于sga_max_size的测试
- SGA_MAX_SIZE与SGA_TARGET
- SGA_MAX_SIZE与SGA_TARGET
- SGA_MAX_SIZE与SGA_TARGET
- SGA_MAX_SIZE与SGA_TARGET
- SGA_MAX_SIZE与SGA_TARGET 区别
- SGA_MAX_SIZE与SGA_TARGET
- SGA_MAX_SIZE与SGA_TARGET
- SGA_MAX_SIZE与SGA_TARGET
- SGA_MAX_SIZE与SGA_TARGET
- SGA_TARGET与SGA_MAX_SIZE关系
- SGA_MAX_SIZE与SGA_TARGET
- web.config解析
- iPhone、iPhone4、iPad 程序启动画面的总结
- C#多线程与异步调用
- java synchronized理解
- 第二天:创建一个View试试
- sga_max_size设置
- 写给自己的忠告:
- Mac os下时间戳转换
- 【仿聚美系列】Gallery定时、 循环 、滚动 、加点 显示
- Android实现数据存储技术
- Git常用命令解说
- 16大跨平台游戏引擎
- 第三天:那么TreeViewer怎么实现?
- 从线程返回数据的两种方法