Assuming you don't use the Oracle Multi-Threaded Server option (MTS) and
every process(Unix) or thread(Windows) is spawned on behalf of only 1 Oracle
session, then on NT use orakill to kill the problem thread and on Unix just
issue a kill command on the problem process .
--
"Ganesh Raja" <ganesh.raja_at_nospam.logicacmg.com> wrote in message
news:newscache$kx33uh$ooc$1_at_animal.logica.co.uk...
> The Session will rollback all the active transaction once u kill the
> sessions.
>
> HTH
>
> --
> Cheers,
> Ganesh Raja
> ==============================================
> Live to learn ... Forget ... and Learn Again
> ==============================================
>
>
> "Yong Feei Shun" <yong_feei_shun_at_uac.com.my> wrote in message
> news:4047dfd9$1_2_at_news.tm.net.my...
> > Dear all,
> >
> > I am having a question here. hope you guys could help.
> Whenever
> > i kill a user, i cant kill the oracle statement there, eventhough the
user
> > had been killed. What should be the problem? Does this mean that at the
> > background that session still running? I encountered system slow down
> > problem recently and cause me to kill the user whoever using the
sesssion.
> > Please help. Thanks
> >
> >
> >
> > Rgrds
> > Feei Shun
> >
> >
> >
>
Received on Thu Mar 04 2004 - 23:25:27 CST
