Hi,
The behavious is related to the DB transaction behaviour. Here is the setup :
1. Oracle DB
2. Sun App. Server 8.1
There is an application running on App. Server 8.1 which is to update/insert a record in a table. What I did right now is.
1. Using sqlplus to update a record but not commit.
2. Using the application to update the same record.
The server behaviour is :
1. It starts to wait for the sqlplus to commit I guess
2. The application keeps waiting and displays server busy blue screen after 10 mins.
I tried to change the different timeout value(Transaction timeout, Retry timeout, Max Wait Timeout) into shorter interval, but the server still takes 10 mins to display server blue screen.
Please suggest how to shorten the 10 mins interval.
Thanks
Benson
[Message sent by forum member 'bensonfungjava' (bensonfungjava)]
http://forums.java.net/jive/thread.jspa?messageID=295340