Sessions with Status as KILLED or SNIPED in V$SESSION
(Doc ID 2471227.1)
Last updated on JANUARY 29, 2020
Applies to:Oracle Database - Enterprise Edition - Version 10.2.0.4 and later
Information in this document applies to any platform.
On : 10.2.0.4 version or above
Sessions with Status as KILLED or SNIPED are found in huge numbers in V$SESSION
There are several hundred sessions in v$session dynamic performance view with a status of KILLED or SNIPED. These sessions are not getting cleaned up by pmon and causing max processes to be reached in database. Is it possible that they are being killed by resource limit for IDLE_TIME? In the past, these sessions were marked as SNIPED and eventually cleaned up by pmon.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document