Kill Many* Jobs

When I want to shutdown the oracle database. I must kill many session client who connect to the database and running in background Os...

bash> ps -ef|grep -i local=no
oracle 19027     1  0   Sep 07 ?        0:01 oracleSERVER (LOCAL=NO)
oracle 25918     1  0   Sep 07 ?        0:03 oracleSERVER (LOCAL=NO)
oracle 16403     1  0   Sep 07 ?        0:00 oracleSERVER (LOCAL=NO)
oracle 18858     1  0   Sep 06 ?        0:01 oracleSERVER (LOCAL=NO)
oracle  7836     1  0   Sep 07 ?        0:02 oracleSERVER (LOCAL=NO)
oracle  9021     1  0   Sep 07 ?        0:00 oracleSERVER (LOCAL=NO)
oracle 27940     1  0   Sep 06 ?        0:00 oracleSERVER (LOCAL=NO)
oracle 25505     1  0   Sep 07 ?        0:01 oracleSERVER (LOCAL=NO)
oracle  2427     1  0   Sep 07 ?        0:00 oracleSERVER  (LOCAL=NO)
oracle 26640     1  0   Sep 06 ?        0:01 oracleSERVER (LOCAL=NO)
oracle 15440     1  0 19:23:09 ?        0:01 oracleSERVER (LOCAL=NO)
oracle 16712     1  0   Sep 07 ?        0:00 oracleSERVER (LOCAL=NO)
oracle 11544     1  0   Sep 06 ?        0:00 oracleSERVER (LOCAL=NO)
oracle  1411     1  0   Sep 07 ?        0:01 oracleSERVER (LOCAL=NO)
oracle 18909     1  0   Sep 06 ?        0:00 oracleSERVER (LOCAL=NO)
oracle 15607     1  0   Sep 06 ?        0:01 oracleSERVER (LOCAL=NO)
oracle  2873     1  0   Sep 06 ?        0:01 oracleSERVER (LOCAL=NO)
oracle 21197     1  0 17:36:49 ?        0:00 oracleSERVER (LOCAL=NO)
oracle 22318     1  0   Sep 06 ?        0:02 oracleSERVER (LOCAL=NO)

Show this the trick (when Nobody give up..:D)

bash> ps -ef|grep LOCAL|awk '{print $2'}|xargs kill -9

Tada..

Printed from: http://sysinfo.bascomp.org/2007/09/kill-many-jobs/ .
© 2010.

2 Comments   »

RSS feed for comments on this post

Leave a Reply