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 “kill_sniped_session.sh” and if you import the following script into this file, you can kill sniped sessions.
sqlplus / as sysdba <<EOF
select p.spid from v\$process p,v\$session s
for x in `cat $tmpfile | grep "^"`
kill -9 $x