Oracle|window
How to Kill a single Oracle thread in a Windows 2000 environment
Source: http://metalink.oracle.com
Key word: Oracle Thread Kill
Description: This article describes the use of Orakill tools in Windows environments
Body:
Have you ever experienced anything like this? A user process that consumes resources for a long time without releasing it causes the Oracle process to consume a large amount of the system's resources, and the oralce system becomes less efficient. If you simply turn off the restart Oracle instance, it will definitely affect all users. Is there a way to just kill the problem user process without shutting down the entire Oralce instance? The answer is yes, using ORALCE to provide a tool called Orakill.
As you all know, Windows 2000 is a threaded operating system, not a process-based operating system like UNIX or Linux. The entire Oracle background process, user processes, etc., in Windows 2000 environments, are included in ORACLE.EXE, a separate system process, and can be seen by looking at ' Task Manager '-' process '. If you are not using the MTS multithreaded server model, if you kill ORACLE.EXE this process, it will cause the entire Oracle instance to close, as with the Shutdown Abort command.
Since Windows did not mention a tool designed to kill a single thread, Oracle began with Oracle7.3.3.6 by providing a tool ――orakill that is used to force the kill of a thread in a Windows environment based on a character interface.
The use of Orakill is as follows:
DOS prompt: >orakill sid thread
Description: SID number of SIDS Oracle
Thread ID number of threads Oracle
In the Sql*plus tool, you can query the Oracle thread number
It is important to note that if you kill an Oracle core background thread (DBWR, LGWR, Smon or Pmon), it will cause the Oracle instance to shut down. The way to check Oracle's core background threads is as follows:
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.