If you can logon as root or as the oracle user you can kill those processes. Assuming killing them is actually a good idea, which you should check on FIRST:
ps -eaf|grep oracleTRLV | \
while read one pid restofline
do
kill -9 $pid
done
Is there a possibility to insert into the program a conditional kill? Let me explain:
1) The result of ps -eaf|grep oracleTRLV is:
oracle 17528 1 0 07:58:07 ? 0:01 oracleTRLV (LOCAL=NO)
oracle 18432 1 0 08:16:57 ? 0:00 oracleTRLV (LOCAL=NO)
oracle 18596 1 0 08:22:52 ? 0:00 oracleTRLV (LOCAL=NO)
2) If now is 8:00 AM can I kill just the processes that have a 7:00 AM (or earlier)?
3) Can you guys recommend a programming book? I assume that this is Shell programming? sorry I'm a .net programmer:(
#!/bin/ksh
ps -eaf|grep oracleTRLV | \
while read one pid dummy1 dummy2 time restofline
do
hour=${time%"${time#??}"}
current_hour=`date +%H`
if [ $hour -lt $current_hour ] # this is a very basic time comparison you can elaborate a more sophistaced one
then
kill -9 $pid
fi
done
2) I was told that "vxfsd" is the program/process that suppose to clean automatically old processes in HP-Unix. Is this true?
The reason I'm asking is because after I reboot the server I can see my processes being cleaned/killed; however, after a day or so this "cleaning" doesn't work anymore. Any ideas?