-
Database Times Out !! URGENT
Hello all..
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.?
thanks
ron
-
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 ?.
Thanks
ron
-
well you can set idle_timeout in profile, those session who dies like that their status become sniped in v$session
-
Thanks..
Is there a Table or view for the default Profile?....Like where i can see idle time, concurrent sessions ,...etc.
thanks
ron
-
Try this
Code:
select
resource_name, limit
from
dba_profiles
where profile = 'DEFAULT'
regards
Jim
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 ?....
Thanks again.
ron
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|