Oracle: Timeout idle or dead sessions

Lately in a project we had a lot of problems with idle database sessions. It turns out that the DBA did not configure any timeout for the oracle database for idle or dead sessions.

This is done with the PMON process, and via SQL*Net, by the sqlnet_expire_time parameter.

SQL*Net

In your sqlnet.ora file add the setting
        sqlnet_expire_time=2
which will poll the SQL*Net client every two minutes and disconnect the session if there is no activity.
For PMON you can buy the according Oracle DBA scripts from Burleson’s website:
http://www.dba-oracle.com/oracle_scripts.htm

Reference [1]: http://www.dba-oracle.com/t_timeout_dead_or_idle_oracle_sessions.htm

Reference [2]: http://docs.oracle.com/cd/B19306_01/network.102/b14213/sqlnet.htm

Related Posts

Postgres: Copy a database

simple

November 17, 2012

Databases, Postgres

No Comment

For backup and development reasons a copy of a postgres database on the same system is often used. This is not a big problem and can be done directly as a SQL statement: [crayon-5adbdfb271ef0017692061/] in your favorite console (psql, pgadmin, etc). There is one thing to remember, if you do a template copy this can […]

Read More

Postgres: Remote copy a database between two machines using ssh

Sometimes it might be useful to copy a postgres database between two systems. This is not a big hazel and can be done with a simple one-liner (Port 22): [crayon-5adbdfb272222204114474/] and even if your ssh connection uses a different port (1234) you are good to go: [crayon-5adbdfb272228324157228/]

Read More

Leave a Reply