LinuxQuestions.org
Review your favorite Linux distribution.
Go Back   LinuxQuestions.org > Forums > Other *NIX Forums > AIX
User Name
Password
AIX This forum is for the discussion of IBM AIX.
eserver and other IBM related questions are also on topic.

Notices

Reply
 
Search this Thread
Old 07-10-2012, 02:46 AM   #1
shipon_97
Member
 
Registered: Oct 2005
Location: Bangladesh
Posts: 447

Rep: Reputation: 30
Killing oracle user process from OS directly !


I am using Oracle 10g on AIX 6.1 . I want to kill the oracle session who are already INACTIVE for the last 25 minutes.
For this reason I run the below query :

select 'kill -9 '||spid " " from v$process where addr in(
select paddr from v$session where program like 'frm%'and status='INACTIVE'and last_call_et>1500
and username not in('ABABILFE','ABABILID','ICT_ARIF','INCHEQS','AIBLIT','AUTOCLEARING'));

The output will come like below :

kill -9 167547
kill -9 182974

Now here I need to run the 'kill' command manually .

But I want to run the above two procedures using One script in Linux/AIx environment . so that I can kill the user process
from the OS directly .

Would any experts will help me regarding this issue .. ..

Waiting for kind reply ... ...
 
Old 07-10-2012, 04:26 AM   #2
cliffordw
Member
 
Registered: Jan 2012
Location: South Africa
Posts: 278

Rep: Reputation: 118Reputation: 118
Hi there,

Firstly I must say that killing Oracle processes in this way is probably not the best approach to take. Secondly, if you must kill these (or any other) processes from the OS, it's always best to try "kill -15" first, to give the process a chance to handle the request gracefully. "kill -9" should only be used in extreme cases, after trying "kill -15".

If you must kill processes in this way, you could run your SQL query via sqlplus in a script, and either redirect the output to a new script, pipe the output to a loop and run the commands one by one, or put xargs to work.

Using the xargs approach, try these steps:
* It's probably easiest to put the SQL into a separate file, say staleprocesses.sql.
* Change the query to select on the PID, without prepending the "kill -9".
* You'll need to set some options to not show unnecessary information, which I'm afraid I can't help you with - haven't used sqlplus in years.
* Run the query as follows, and check that it outputs ONLY the process ids:
Code:
sqlplus username/password @staleprocesses.sql
* Once this works, run the following to actually kill the processes:
Code:
sqlplus username/password @staleprocesses.sql | xrags kill -9
I hope this helps to get you going on a solution.
 
Old 07-11-2012, 12:49 PM   #3
crabboy
Moderator
 
Registered: Feb 2001
Location: Atlanta, GA
Distribution: Slackware
Posts: 1,823

Rep: Reputation: 120Reputation: 120
Any reason you can't use the alter command within Oracle?

ALTER SYSTEM KILL SESSION #
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
killng parent process without killing child process (Linux C programming) lettuce84@naver.com Linux - Newbie 1 03-10-2011 04:18 AM
Killing More than one process ruud Programming 11 04-27-2010 06:30 AM
LXer: Is Oracle Quietly Killing OpenOffice? LXer Syndicated Linux News 1 04-14-2010 03:10 AM
Killing a process by its name rabeea Linux - Networking 3 03-17-2005 05:30 AM
Really Killing a Process! lazlow69 Linux - Newbie 14 05-10-2003 10:31 PM


All times are GMT -5. The time now is 10:00 PM.

Main Menu
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration