| killed session still in v$session but not in v$process [message #318221] |
Tue, 06 May 2008 02:48  |
lokeshonline
Messages: 29
Registered: April 2006 |
Junior Member |
|
|
I killed two sessions through OEM after that I killed through SQL session. These two session are still being shown if I query v$session but not shown if I see in OEM. Also if I query select sid,serial#,status from v$session where paddr not in (select addr from v$process) it shows me these two sessions with status KILLED. Ideally the above query should not show any record as for every session in v$session there should be an OS process with a recrod in v$process.
I have seen alert log but there is no error.
Please help why these two sessions are there without any corresponding record in v$process and what should I do to kill them properly.
|
|
|
| Re: killed session still in v$session but not in v$process [message #318233 is a reply to message #318221 ] |
Tue, 06 May 2008 03:16  |
Michel Cadot
Messages: 15238
Registered: March 2007
Location: Nanterre, France, http://... |
Senior Member |
|
|
You just have to wait that PMON cleans up the sessions.
You can't do anything more.
Regards
Michel
|
|
|
| Re: killed session still in v$session but not in v$process [message #318242 is a reply to message #318221 ] |
Tue, 06 May 2008 03:54 |
msmallya
Messages: 28
Registered: March 2008
Location: AHMEDABAD, GUJARAT |
Junior Member |
|
|
Try killing OS process - on Linux/Solaris
kill -9 pid (pid= spid from v$process)
Regards,
MSMallya
|
|
|
| Re: killed session still in v$session but not in v$process [message #318244 is a reply to message #318242 ] |
Tue, 06 May 2008 03:57 |
Michel Cadot
Messages: 15238
Registered: March 2007
Location: Nanterre, France, http://... |
Senior Member |
|
|
You didn't read the topic.
1/ Process already no more existed. There is nothing in v$process
2/ Your command does not remove the session which is the purpose of the topic
Regards
Michel
|
|
|
| Re: killed session still in v$session but not in v$process [message #318246 is a reply to message #318244 ] |
Tue, 06 May 2008 04:01 |
msmallya
Messages: 28
Registered: March 2008
Location: AHMEDABAD, GUJARAT |
Junior Member |
|
|
Yes there are no info available in v$process once you kill the session.
But my suggestion for - in future whenver killing the session, one can note down the "SPID" inorder to kill OS process, if required.
MSMallya
|
|
|
]
Members
Search
Help
Register
Login
Home
