aspose file tools*
The moose likes Other Java Products and Servers and the fly likes DB connection is very slow Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » Other Java Products and Servers
Bookmark "DB connection is very slow" Watch "DB connection is very slow" New topic
Author

DB connection is very slow

Reza Ravasizadeh
Ranch Hand

Joined: Jun 08, 2004
Posts: 177
We use SUN one App server 7 and Oracle 9i,
for our product.
We have a problem:
Application server and Oracle are not busy too much but it take a long time for JDBC operation(JDBC pool size on App server is also very big I think about 300) a guy from Test told me that Application server stay idle waiting for connection and you should check oracle if yes or not !!! then provide us solution.

They don't provide me enough info but I think I should:
1)I will see App server log and check Oracle Listener status with Oracle LSNCTRL(or something like that)to find DB situtation.

2) Looking for some monitoring toolm that let me know if the problem is Network or something between App server and DB (Our OS is sun Solaris), if you know some please tell me.

Thank you for your comment


Reza
Reza Ravasizadeh
Ranch Hand

Joined: Jun 08, 2004
Posts: 177
no comment ???
 
wood burning stoves
 
subject: DB connection is very slow