Re: Session Kill

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: Sat, 06 Oct 2007 10:31:37 -0700
Message-ID: <1191691897.330611.18780@y42g2000hsy.googlegroups.com>

On Oct 6, 10:15 am, "Michel Cadot" <micadot{at}altern{dot}org> wrote:
> <lyx..._at_gmail.com> a écrit dans le message de news: 1191675232.261492.207..._at_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
> |
>
> What is the difference of being out of gas because
> you drove 400 miles or because someone emptied
> your tank?
>
> Regards
> Michel Cadot

In other words locks are released whenever a session exists clearnly or is killed. PMON cleans up after sessions that crash.

HTH -- Mark D Powell -- Received on Sat Oct 06 2007 - 12:31:37 CDT