环境:Aix 6.1+oracle 11g R2 RAC 版本:11.2.0.3
测试方式:weblogic 11g 压力测试查看数据库会话数是否实现负载均衡(rac1会话数多时候,rac2会话数能分担实现负载)
步骤:
第一台
fjseiora1:/home/oracle$sqlplus /nolog
SQL*Plus: Release 11.2.0.3.0 Production on Wed Jul 10 16:02:20 2013
Copyright (c) 1982, 2011, Oracle. All rights reserved.
SQL> conn / as sysdba
Connected.
SQL> show parameter instance_name
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
instance_name string orcl1
SQL> select count(*) from v$session;
COUNT(*)
----------
86
SQL> r
1* select count(*) from v$session
COUNT(*)
----------
103
SQL> r
1* select count(*) from v$session
COUNT(*)
----------
103
SQL> show parameter service
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
service_names string orcl
第二台:
fjseiora2:/home/oracle$sqlplus /nolog
SQL*Plus: Release 11.2.0.3.0 Production on Wed Jul 10 14:45:07 2013
Copyright (c) 1982, 2011, Oracle. All rights reserved.
SQL> conn / as sysdba
Connected.
SQL>
SQL>
SQL> show parameter services;
SQL> show parameter service
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
service_names string fjsei
SQL> select count(*) from v$session;
COUNT(*)
----------
56
SQL> select count(*) from v$session;
COUNT(*)
----------
56
weblogic上了压力之后,一直连接orcl1实例,不会连接orcl2实例,会话数差别太大,这样能实现负载均衡吗?
或者说有什么方法怎样测试能实现负载均衡?
收起