hi connection url is: <connection-url>jdbc:oracle:thin:@(DESCRIPTION = (LOAD_BALANCE=on) (ADDRESS=(PROTOCOL=TCP) (HOST = kopsdb1_vip.yurticikargo.com.tr) (PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = kopsdb2_vip.yurticikargo.com.tr)(PORT = 1521)) (CONNECT_DATA= (SERVER = DEDICATED) (SERVICE_NAME = KOPS)))</connection-url>
we use oracle10g rack system and try to do load balancing. so i think its application server problem. because lots of sql statement execute in system and some of then slower in application server. same sql statement execute in pl/sql and jdeveloper faster than application server. these sql staments contains more than joins and hints (for index) View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3895991#3895991 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3895991 ------------------------------------------------------- SF.Net email is sponsored by: Tame your development challenges with Apache's Geronimo App Server. Download it for free - -and be entered to win a 42" plasma tv or your very own Sony(tm)PSP. Click here to play: http://sourceforge.net/geronimo.php _______________________________________________ JBoss-user mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/jboss-user
