Has anyone come across the PL/SQL connectionresetting every 3 minutes if unused?
If so, how do you resolve this or troubleshoot this.
Check whether you are using a Oracle profile with idle_time set to around 3 minutes.
In bit technical, Oracle PMON process is responsible for handling this periodically.
A session would continue to show as idle even after the idle_time specified in that user's profile.
When the user attempts use the session (may be a new transaction) after the idle_time has expired, Oracle will disconnect the user by terminating the session.
If modifying the db profile parameter is not an option, in PLSQL Developer, you can use the Check Connection functionality which regularly pings the database (in every 60 second intervals as I remember) to get rid of your disconnection issue.
Hope this helps!
@nabalk Thank you for your reply, our users are currently set to the DEFAULT profile and IDLE_TIME is set to UNLIMITED.
Unfortunately, we are not using PL/SQL Developer at the moment this has been requested. Just awaiting confirmation.
@johnw66 It is better to use the system parameter “Max idle time until automatic client logoff”, instead of the idle session timeout parameter in “oracle profile”, since it doesn’t work properly.
To perform this functionality, you can navigate to the System Parameters window and there is a System parameter under Security category called “Max idle time until automatic client logoff (in minutes)”
The timeout value would be a system parameter (where value null or 0 means no timeout). A positive value means that after X minutes of idling (measured from last input on Windows) the client will present a dialog telling the user that it has been timed out and then restart (forcing the user to re-login).
1. Try setting the value for x minute for System Parameter called Max idle time until automatic client logoff (in minutes)
2. Restart the application and then see if the client times out after being idle for x minute
Please follow below thread: Auto log-out from IFS client when a user is inactive for X minutes | IFS Community
Already have an account? Login
No account yet? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.
We use 3 different kinds of cookies. You can choose which cookies you want to accept. We need basic cookies to make this site work, therefore these are the minimum you can select. Learn more about our cookies.