select status from v$session ....
what is sniped status?
thanks in advance.
Sniped means idle_time (in user profile) is exceeded by the session.
Status of the session: ACTIVE (currently executing SQL), INACTIVE, KILLED (marked to be killed), CACHED (temporarily cached for use by Oracle*XA), SNIPED (session inactive, waiting on the client)
Click Here to Expand Forum to Full Width