script in killing list fo unwanted sessions

[Trng]

i All,

i want a script in killing list fo unwanted sessions ..my requiremnet is

1-ps -ef | grep LOCAL=NO | wc -l is showing 1000 and machine is running slowly .i want to kill all the process listed above .how to make a simple scipt to kill these process one by one ....

2-how to kill pty/tty sessions which is not showing any process id in finger/who/w command


rgds,trng

[Kenan Erdey · Accepted solution]

Hi,

for first one i can write it from my mind :)

ps -ef | grep "LOCAL=NO" | grep -v grep | awk '{print $2}' | xargs kill

[Kenan Erdey]

for 2. do you mean you want to kill idle sessions in which no process spawned?

[Raynald Boucher]

That looks suspiciously like killing a bunch of oracle connections.

You should be carefull with that unless you don't care about unhappy users / customers.

Maybe, you should further investigate the origin, the status and the actions theses processes perform before starting a mass kill. Investigate the V$SESSION view in oracle for more info.