Hi Sharma,

If the user session which you are going to kill did lot of works and used a lot of resources (rollback, redo, ..) will take an enormous amount of time to kill that process from database by issuing 'Alter system kill session .....' command

The reason is that this command first marks the session for killing and is not killed untill all the resources and locks are released.

But if you use operating system command (kill -9 pid), it will directly kill the session without releasing the locks and resources. In this case PMON process is responsible to release the resources later on.

Both the cases, you are fine - no worries.


Thanks
Babu