Home » SQL & PL/SQL » SQL & PL/SQL » user session is being timed out - no error are recorded (10.2.0.3)
user session is being timed out - no error are recorded [message #392178] Mon, 16 March 2009 18:37 Go to next message
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 #392179 is a reply to message #392178] Mon, 16 March 2009 18:44 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/

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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
ThomasG
Messages: 3189
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
ThomasG
Messages: 3189
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 #392353 is a reply to message #392242] Tue, 17 March 2009 11:25 Go to previous messageGo to next message
kumar.joy
Messages: 69
Registered: August 2007
Location: morrisville
Member
Thomas,

Thanks for reply, and some important information. is there any other areas we need to look as a DBA point of view.
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 Go to previous message
BlackSwan
Messages: 25050
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?
Previous Topic: comma separated values
Next Topic: Error while compliling the code
Goto Forum:
  


Current Time: Sat Dec 10 08:52:02 CST 2016

Total time taken to generate the page: 0.09182 seconds