本帖最后由 -Bill 于 2014-11-27 09:15 编辑
环境:AIX 6.1+oracle 11.2.0.4.0 双节点RAC
今天发现两个节点的进程数量不一样,一节点很多,二节点很少,且活动的会话一直在一节点,二节点只有一两个活动会话(还是用PL/SQL连接上去的),如下:
select inst_id 实例编号,
instance_name 实例名,
host_name 主机名,
version 版本,
status 状态,
(select count(*) from gv$process where inst_id = A.inst_id) 进程数,
(select count(*)
from gv$session
where inst_id = A.inst_id
and username = 'CJCL'
and status = 'ACTIVE') 活动会话数
from gv$instance Aorder by inst_id;
QQ截图20141126113054.jpg (10.06 KB, 下载次数: 8)
2014-11-26 11:30 上传
我查看了下crs 都处于正常状态:
[grid@ora6b:/home/grid]#>crsctl stat res -t
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA.dg
ONLINE ONLINE ora5b
ONLINE ONLINE ora6b
ora.FRA.dg
ONLINE ONLINE ora5b
ONLINE ONLINE ora6b
ora.LISTENER.lsnr
ONLINE ONLINE ora5b
ONLINE ONLINE ora6b
ora.OCRVOTE.dg
ONLINE ONLINE ora5b
ONLINE ONLINE ora6b
ora.asm
ONLINE ONLINE ora5b Started
ONLINE ONLINE ora6b Started
ora.gsd
OFFLINE OFFLINE ora5b
OFFLINE OFFLINE ora6b
ora.net1.network
ONLINE ONLINE ora5b
ONLINE ONLINE ora6b
ora.ons
ONLINE ONLINE ora5b
ONLINE ONLINE ora6b
ora.registry.acfs
ONLINE ONLINE ora5b
ONLINE ONLINE ora6b
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE ora6b
ora.cvu
1 ONLINE ONLINE ora6b
ora.oc4j
1 ONLINE ONLINE ora5b
ora.ora5b.vip
1 ONLINE ONLINE ora5b
ora.ora6b.vip
1 ONLINE ONLINE ora6b
ora.qyyg.db
1 ONLINE ONLINE ora6b Open
2 ONLINE ONLINE ora5b Open
ora.scan1.vip
1 ONLINE ONLINE ora6b
[grid@ora6b:/home/grid]#>
但就是不知道是什么原因导致这两个节点的负载不均衡,请有经验的兄台指教一下!!!