Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

killing idle oracle processes 1

Status
Not open for further replies.

smacattack

Technical User
Jun 25, 2001
102
GB
Can anyone tell be how to kill off idle processes within oracle. This will need to show how to kill not only the thread but the unix process also so nothing is left.
I can identify the sid and how long its been idle, but how to i cleanly kill off all processes for that particular user.
 
SELECT sid, serial#
FROM v$session
WHERE username = 'YOUR_IDLE_USER';

This gives you the sid and serial# you need for:

ALTER SYSTEM KILL SESSION 'the_sid, the_serial#';

 
tHIS WILL LEAVE A UNIX PROCESS FLOATING ABOUT UNTIL PMON CLEARS UP THESE DEAD PROCESSES.
IS THERE ANYWAY OF KILLING THE ORACLE SID'S AND THE UNIX PROCESSES TOGETHER FOR A FULL CLEAR OUT!
 
From the query in the earlier post:

SELECT sid, serial#
FROM v$session
WHERE username = 'YOUR_IDLE_USER';

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top