Originally posted by dba_admin
1. If on Unix, how do I know which process belong to which user. I need to be able to identify, say, the process of "SCOTT" and then kill -9 xxx.

2. If this is on NT, does this work?
1. Check SPID column in V$PROCESS to get Unix process ID.

2. NT Task manager doesn't breakdown the information to thread level.

Sanjay