How to kill a process running on oracle db server from putty?

Question

I created one sql file in PuTTY and I kept it on running using below command:

sqlplus username/pwd@SSAR05 @exec_lmn_DELETE.sql > exec_lmn_DELETE_17102018.log &

I didn't note down the SPID of this, but now I want to kill this process.

How to do this?

Answer 1

Try this:

ps -ef| grep "sqlplus"

This should give you result like below:

mayankp  30927 22295  0 Oct09 pts/22   00:00:02 /home/mayankp/anaconda2/bin/python /home/mayankp/anaconda2/bin/ipython

where 30927 is the process id. Kill it like:

kill -9 30927