tag:blogger.com,1999:blog-755542794415995865.post2954083967536633095..comments2023-09-23T07:13:10.004-07:00Comments on DB Optimizer: stopping long running queries (UNIX vs Windows)Kyle Haileyhttp://www.blogger.com/profile/13586511268045480856noreply@blogger.comBlogger1125tag:blogger.com,1999:blog-755542794415995865.post-50896530936780235912010-03-08T11:47:26.134-08:002010-03-08T11:47:26.134-08:00You should read oracle docs. Killing the process o...You should read oracle docs. Killing the process or thread running a query is really the last option. In Windows you can kill a thread running a query using the mmc plug in installed with Oracle. Connect to the database instance, right click and one of the menu items gives you access to the Oracle threads. Here you can terminate them.<br />But you should use ALTER SYSTEM KILL SESSION. An application can call OciBreak() to interrupt a statememt.<br />If your client terminates and the query is not killed, check your sqlnet parameters. Probably timeouts are set to 0 and the server doesn't check if the client is still alive until the result is ready.LDShttps://www.blogger.com/profile/04633789460476801953noreply@blogger.com