Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SQLNET.ORA: sqlnet.expire_time=1 : Enabling Session Timeouts at DB level

503629May 18 2006 — edited May 18 2006

We are running 2 Oracle 9.2 database instances on an Linux Server. In the process of implementing Session Timeouts - I have made the following changes to SQLNET.ora file

SQLNET.EXPIRE_TIME = 1

I have restarted the database and also the listener. Now I have established connection to the database using SQLPLUS client. After executing a query, I stay idle for say 90 seconds. After this time, When I execute a query from the same client, I was expecting to see ORACLE ERROR indicating the session has timed out.

But, it is not happening. Any other configuration parameters needs to be set to make this happen ?

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 15 2006

Added on May 18 2006

#general-database-discussions

3 comments

1,138 views