| Query time out happenning from a web application [message #62128] |
Mon, 28 June 2004 20:44  |
Shibaji Ghosh
Messages: 39
Registered: April 2002
|
Member |
|
|
Hello,
I am connecting to an Oracle instance from a web based application. After sometime I am witnessing a query time out from Oracle happenning. The connection is still there, but the querty is no longer executed.
Can anyone tell me what steps should I follow to diagnose the problem, apart from looking at the alert log file.
Thanks in advance,
Shibaji
|
|
|
|
| Re: Query time out happenning from a web application [message #62129 is a reply to message #62128] |
Mon, 28 June 2004 21:58  |
Anatol Ciolac
Messages: 113
Registered: December 2003
|
Senior Member |
|
|
|
You have not other choise. You MUST to look in the alert.log file,bdump directory, udump directory, to see if oracle stil keeps your session, to see if application return any error for detecting a cause of this enormous behavior. If there are any error in process of executing your query - you will find description of them in described sources(for resolving problem you must to find cause). When you will find a error - post them to this forum.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
