I have a procedure that gives below output.
SID is 155
SERIAL# is 5466
PROCESS is 1323
SQL_HASH_VALUE is 2701082490
TIME_REM_MIN is 3
TIME_START is 09-07-08 15:38:10
TIME_ELP_MIN is 2
And a unix 'ps' command that would give output as below.
$ ps -e -o pcpu -o pid -o user -o args |sort -r -k 1 |head -30
%CPU PID USER COMMAND
4.4 22404 oracle oracleosprod (DESCRIPTION=(LOCAL=NO)(SDU=8192))
What is the Relation Between These two (UNIX Process and SQL query), so that i can manually kill the undesired queries (from unix box, the kill -9 command) which raises the CPU utilization.
Please note that i only want to kill quries raising CPU utilisation, and not long running quries(which can be done from database). I also don't have DBA privilages on the DB, tht's why chosing to kill from unix OS level(which is the only way i know).