Connections not evenly distributed across nodes
Hi Gurus,
I have a 2 node RAC 11gr2 setup RHEL 6.2. Session counts on both nodes are of a huge difference. Not sure whether load balancing is happening or not. Please let me know how to enable the same.
Configuration
1) We are not using SCAN feature.
2) Clients are using TNS names connecting through service name i.e. REMCORP
SQL> show parameter remote_listener
NAME TYPE VALUE
------------------------------------ -------------------------------- ------------------------------
remote_listener string LISTENER_REMCORP
3) SQL> SELECT inst_id, count(*) "DB Sessions" FROM gv$session
WHERE type = 'USER' GROUP BY inst_id; 2
INST_ID DB Sessions
---------- -----------
1 5
2 106
Regards,
Nikhil Mehta.