Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Session Kill
<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
![]() |
![]() |