5 Replies Latest reply: Nov 9, 2012 1:54 AM by LANCERIQUE RSS

    Connections not evenly distributed across nodes

    LANCERIQUE
      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.