Useful Oracle management tool for Windows Assistant

In Windows, if a large amount of SQL data is executed, kill it in the middle, and sometimes leave a dead thread, causing the object to be locked. Generally, we use orakill to handle this problem, see my previous blog articles. However, this session cannot be completely killed using orakill many times recently. It is recorded in V $ process, but the error message "no" is returned when orakill Sid thread.

In this case, you need to use this tool. After opening the tool, right-click the database instance and choose "thread information ...", Find the dead thread and click terminate to delete it immediately.

Script query statement

Select spid, osuser, S. Program from
V $ PROCESS p, V $ session s where P. ADDR = S. paddr