| user session is being timed out - no error are recorded [message #392178] |
Mon, 16 March 2009 18:37  |
kumar.joy
Messages: 69
Registered: August 2007
Location: morrisville
|
Member |
|
|
Experts,
i am having one problem. one of my user are complaining that their
is getting timed out after 20 min.
i did see at the database level by running addm report. i checked alert.log, sqlnet.log file if any errors are reporting
i have checked user profile. here the values for parameters are
idle_time = 30
connect_time=default.
i ask my app/web server admin, weather they can able to any error in app/web server log.
some more factors i have observed that db is requesting some memory in sga(db_cache_size). will it cause any connection timed out errors.
i am not able to pinpoint the cause for this error. can any one guide me to trace this problem.
i was able to see one posting in oraforum " session timed out after 30 min". i did not find solution for this problem.
|
|
|
|
|
|
| Re: user session is being timed out - no error are recorded [message #392180 is a reply to message #392178] |
Mon, 16 March 2009 19:00  |
kumar.joy
Messages: 69
Registered: August 2007
Location: morrisville
|
Member |
|
|
Swan,
Thanks for Quick reply. i did a mistake. i have posted this question in wrong forum. it should be in " Server Administration"
i have done one more mistake, i did not properly formatted the values,i have mentioned in the earlier mail. my apologies for that. next time i will format my posts. apart form this if i did any mistakes, please let know. i will correct myself.
Connect Time (Minutes) DEFAULT
Idle Time (Minutes) 30
|
|
|
|
| Re: user session is being timed out - no error are recorded [message #392181 is a reply to message #392180] |
Mon, 16 March 2009 19:13 |
ThomasG
Messages: 3212
Registered: April 2005
Location: Heilbronn, Germany
|
Senior Member |
|
|
One other mistake is not enough information.
- WHAT is timing out.
- What is the exact error message
- What software is the web server running
- What language is the application written in
- What OS is the whole thing running on.
- How are the users accessing the whole thing.
Without that information, all that we can tell you is that "there is a timeout somewhere"
|
|
|
|
| Re: user session is being timed out - no error are recorded [message #392182 is a reply to message #392181] |
Mon, 16 March 2009 19:28 |
kumar.joy
Messages: 69
Registered: August 2007
Location: morrisville
|
Member |
|
|
let me explain the case.
our clients will connect the database by using web application. we have created user database user account. by using the DATABASE user
account and web application he will logged in to my DATABASE and he will perform DML operation like select,insert,update
- WHAT is timing out?.
--> client session got disconnecting.
- What is the exact error message?
--> this is the problem. i did not see any errors.
i ask my user to post error messages if they have any.
but i am not getting any answers from them.
- What software is the web server running?
--> ibm http server
--> application server : websphere
- What language is the application written in ?
--> java
- What OS is the whole thing running on.
--> Linux As4
- How are the users accessing the whole thing ?
they use web application and database user account to access the data.
[Updated on: Tue, 17 March 2009 00:11] by Moderator Report message to a moderator |
|
|
|
| Re: user session is being timed out - no error are recorded [message #392242 is a reply to message #392182] |
Tue, 17 March 2009 02:41 |
ThomasG
Messages: 3212
Registered: April 2005
Location: Heilbronn, Germany
|
Senior Member |
|
|
So basically at the moment 2 things come to mind:
- There might be a HTTP timeout between the webserver and the client.
- There might be a Database query timeout set in the Java application.
So you will basically have to wait for the exact error message from the user.
|
|
|
|
|
|
| Re: user session is being timed out - no error are recorded [message #392354 is a reply to message #392178] |
Tue, 17 March 2009 11:30 |
 |
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
|
Senior Member |
|
|
>one of my user are complaining that their is getting timed out after 20 min.
Only 1 user complaining about timeout?
How many other users are working OK?
What is this 1 user doing different than other users who do not time out?
Is this 1 user always doing same operation/function when timeout occurs?
Can this 1 user reproduce timeout at will?
Is this user running a query which takes more than 20 minutes to complete?
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
