Question

PL/SQL session is resetting every 3 minutes if unused

  • 7 April 2021
  • 3 replies
  • 88 views

Userlevel 5
Badge +16

Has anyone come across the PL/SQL connectionresetting every 3 minutes if unused?

If so, how do you resolve this or troubleshoot this.

 

Thank you. 


3 replies

Userlevel 3
Badge +3

@johnw66  
 

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!

Userlevel 5
Badge +16

@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.

 

 

Userlevel 3
Badge +5

@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

Reply