Oracle 22.214.171.124 on Windows 2003 Server. We are experiencing problems with the database connectivity from the production web servers for the last 2-3 weeks. We are using Oracle RAC and there are 2 database servers. The load seems to shift until most of the connections are going to the same Oracle node i.e. second node. We are using Windows load balancing and all microsoft drivers on the web servers. Does anybody have any idea what might cause this?
Server side load balancing can also be used to balance the number of connections to each instance. Session count balancing is method used when you set a listener parameter, prefer_least_loaded_node_listener-name=off.
If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.
This post first appeared at Oracleinaction (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself).
I will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…