Thursday , June 13 2024

Automatic Killing of Sniped Sessions


When you set the resource_limit parameter to true in the database and set the idle_time parameter in the profiles to a value other than unlimited, the database will kill any sessions that are idle for the time specified by idle_time.

These sessions will be seen as “SNIPED” in “v$session” view. The processes of these sessions need to be killed at the operating system level. In Linux environments, SNIPED sessions can be killed with the following script.

You can create a shell script file named “” and if you import the following script into this file, you can kill sniped sessions.


About dbtut

We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.

Leave a Reply

Your email address will not be published. Required fields are marked *