在windows里查看oracle进程线程信息

在windows里查看oracle进程线程信息

2010-09-16        Viewing Threads

         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 arguments username 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(下面是说明该工具存放的路径):

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

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

3. Choose Process Information.

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

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