Re:Killing an user from the user

[Yong Feei Shun]

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

[Mark D Powell]

Re: Killing an user from the user

"Yong Feei Shun" <yong_feei_shun @uac.com.mywrot e in message news:<4047e081$ 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

How did you kill the user session? At the OS level or via alter
system kill session?

There is a very good chance that Oracle is rolling the user activity
back. See the following article for how to follow a rollback.

Is there a way to detect processes that are rolling back, and can I
figure out how long it will take ?

http://www.jlcomp.demon.co.uk/faq/rolling_back.html

Re-post with more information if the article does not apply/help.

By the way, when a newsgroup has sub-groups you should generally post
to one of the sub-groups and not in the group.

HTH -- Mark D Powell --