Steps to kill Database Process from Unix OS

1.      Identify the sid of the session using v$session view and where clause like user_name, program and machine etc.

Sql> select sid from v$session where {clause};

2. Get spid corresponding to sid using below query.

Sql > select p.spid,s.username,s.process from v$process p, v$session s where p.addr=s.paddr and s.sid={sid};

3. Use p.spid value from above query to kill session from OS level using:

$ kill -9 p.spid

4. Crosscheck in next one minute this session will not be there in v$sessions view.

No comments:

Post a Comment