1.  

   
   

   如何檢視windows下的Oracle程式

   
   

由於Windows是單程式多執行緒。因此Oracle一啟動，在工作管理員那裡只能看到有一個oracle.exe的程式。想要檢視Oracle的各個程式（在linux上是這麼叫吧），如PMON、SMON、DBWR、LGWR、CKPT等，如何去檢視呢？

這裡找到一部分英文文件，如果英語不好的話就看圖片吧，我把圖片擷取下來了,如果圖片看不懂的話那你也太笨了點吧⊙﹏⊙，，，，玩笑：

To view information on Oracle Database threads using Oracle Administration Assistant for Windows, you must either enable Windows native authentication for the database or run utilityocfgutil.exe with argumentsusername and password. The utility stores the username and password in the following registry location:

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\OracleOraConfig

When Windows native authentication is not enabled, Oracle Remote Configuration Agent retrieves the username and password from this registry key to log in to the database.

To view information on Oracle Database threads using Oracle Administration Assistant for Windows(下面是說明該工具存放的路徑):

From the Start menu, select Programs, then select Oracle - HOME_NAME, then select Configuration and Migration Tools and then select Administration Assistant for Windows.

 

首先開啟 Administration Assistant for Windows 這個工具：

 

Right-click the SID, where SID is a specific instance name, such asorcl.

Choose Process Information.

 

這裡大家就可以看見Oracle的程式名稱了

 

The Process Information dialog appears, listing name, type, user, thread ID, and CPU usage for each Oracle Database thread.

To terminate a thread, select it and click Kill Thread.

 

當然 Oracle還有其它的一些效能工具如下圖，大家有空研究研究