orakill without spid
Hello Everyone,
Customer is on 11.2.0.2 on Windows environment:
I cannot find a spid for the session, when I join v$session and v$process by addr and paddr I get no results for that sid. So, the question is how do I use orakill to kill a session if I can't find the spid? Is there another way to get the spid other than joining on addr and paddr?
Thanks
Customer is on 11.2.0.2 on Windows environment:
I cannot find a spid for the session, when I join v$session and v$process by addr and paddr I get no results for that sid. So, the question is how do I use orakill to kill a session if I can't find the spid? Is there another way to get the spid other than joining on addr and paddr?
Thanks
0