Oracle Timeout

what is Oracle Timeout ?
How does it work?
Who is Participating?
eraceroConnect With a Mentor Commented:
The oracle timeout isn't a paramter, it's a concept. It is known as "Dead Connection Detection" and it's a SQLNet functionality.
Once a new connection is established (to the listener) SQLNet read the sqlnet.ora file ant it set a time interval acording to the parameter SQLNET.EXPIRE_TIME (this value is in minutes). When the time expires, SQLNet server sends a "probe packet" to the client; if the client is already there, the "probe packet" is answered and SQLNet resets the timer. If not, SQLNet will free the connection.
By default this value is 0.

Hope this help.
a timeout is an sqlNet parameter that tells oracle to disconect you when an specifed ammount of time idle or inactive time is reached
savvygAuthor Commented:
how and where do u set this parameter?

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.