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

最新推荐文章于 2022-09-23 15:07:41 发布

haiross

最新推荐文章于 2022-09-23 15:07:41 发布

阅读量4.6k

点赞数

分类专栏： Oracle数据库入门须知事 Oracle数据库基本管理 oracle常用工具文章标签： oracle进程线程 thread migration windows

Oracle数据库基本管理同时被 3 个专栏收录

337 篇文章

订阅专栏

Oracle数据库入门须知事

32 篇文章

订阅专栏

oracle常用工具

14 篇文章

订阅专栏

本文介绍如何使用Oracle Administration Assistant for Windows工具查看Oracle数据库进程线程信息，并提供了详细的步骤指导，包括如何通过工具查看线程详情及如何终止指定线程。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

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

From the Start menu, select Programs, then select Oracle - HOME_NAME, then select Configuration and Migration Tools and then select Administration Assistant for Windows.
Right-click the SID, where SID is a specific instance name, such asorcl.
Choose Process Information.

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.