Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Session Kill

Re: Session Kill

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Sat, 6 Oct 2007 16:15:56 +0200
Message-ID: <4707989b$0$9503$426a74cc@news.free.fr>

<lyxx09_at_gmail.com> a écrit dans le message de news: 1191675232.261492.207910_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 Received on Sat Oct 06 2007 - 09:15:56 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US