Session Kill

From: <lyxx09_at_gmail.com>
Date: Sat, 06 Oct 2007 05:53:52 -0700
Message-ID: <1191675232.261492.207910@50g2000hsm.googlegroups.com>

Hi All,

9.2.x

I am trying to find the diff. between killing the sessions explicitly by issuing "alter system ..'
and get them killed by setting the profile.

One session which was SNIPED because of profile setting released all the locks as well.

So, if session leaves in v$session then what is diff. in killing them through script/job as still they would be in v$session in this case also in KILLED state.

Regards.
Lyxx Received on Sat Oct 06 2007 - 07:53:52 CDT