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@uac.com.my> wrote in message
news:4047dfd9$1_2@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
>
>
>