Database Times Out !! URGENT
Sun 5.8/ Oracle 9.2
Our application servers make multi connections to the database and keeps these connections open. Everything works fine until I come back a day later, then some of the connections to the database are invalid and I get socket errors. Not all connections have this problem, only about 25% of them.
Is there a timeout value?
Any one has any ideas.?
if you dont post any ORA-error then it's quite hard to help
Sorry about that...
Since it happens only if idle overnight....Let me see if i can reporduce that error again..
In the meantime, Is there soem kind of Database time outs for connections that are idle for a long time ?.
Where can i set this ?.
well you can set idle_timeout in profile, those session who dies like that their status become sniped in v$session
Is there a Table or view for the default Profile?....Like where i can see idle time, concurrent sessions ,...etc.
where profile = 'DEFAULT'
Oracle Certified Professional
"Build your reputation by helping other people build theirs."
"Sarcasm may be the lowest form of wit but its still funny"
Click HERE to vist my website!
Hello all again...
where do we find out if there are any errors in the DB about lost
connections?...Can we see them in alert log file ?....
Click Here to Expand Forum to Full Width