IDLE_TIME not considered in version 9.0.2

[mor]

We're currently deploying version 9.0.2 in our organisation and some users have noticed that the idle_time configuration of their Oracle users are not taking effect anymore. Sometimes they forget to disconnect before leaving for the day and when they get back the next morning their connection is still working. That didn't use to be the case with version 8.0.4. Is there a particular configuration I need to get the behavior of version 8.0.4?

Thank you!

 

[Marco Kalter]

By default PL/SQL Developer will do nothing, so the idle_time limit should be effective. Things you might want to check:

1. Is the "Check Connection" preference (Tools > Preferences > Oracle / Connection) enabled? This can cause the symptoms you described.
2. Are there really any sessions active in the database when you come back the next day? Maybe PL/SQL Developer simply re-establishes the connection that was timed out.

 

[mor]

I disabled the "Check Connection" preference and my connections got snipped after the idle_time expired.

Sometimes the connnection is reestablished without my asking. I guess this is one of the enhancement of version 9.0.3 (Editing when disconnected could implicitly connect).

I will try updating to the last version.

Thank you!