Monitoring Legacy Connection Load Balancing
Query the LOAD_BALANCE_POLICY column of the V_CATALOG.DATABASES to determine the state of native connection load balancing on your server:
=> SELECT LOAD_BALANCE_POLICY FROM V_CATALOG.DATABASES; LOAD_BALANCE_POLICY --------------------- roundrobin (1 row)
Determining to Which Node a Client Has Connected
A client can determine the node to which is has connected by querying the NODE_NAME column of the V_MONITOR.CURRENT_SESSION table:
=> SELECT NODE_NAME FROM V_MONITOR.CURRENT_SESSION; NODE_NAME ------------------ v_vmart_node0002 (1 row)
Concept Information
About Native Connection Load Balancing
Related Tasks
Enabling and Disabling Classic Connection Load Balancing
Enabling Native Connection Load Balancing in ODBC
Enabling Native Connection Load Balancing in JDBC
Enabling Native Connection Load Balancing in ADO.NET
Reference Materials