Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

How to use PsList to view information such as threads of Oracle on Windows

2025-04-03 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Servers >

Share

Shulou(Shulou.com)06/01 Report--

This article mainly introduces "how to use PsList to view Oracle threads on Windows". In daily operation, I believe many people have doubts about how to use PsList to view Oracle threads on Windows. Xiaobian consulted all kinds of materials and sorted out simple and easy-to-use operation methods. I hope it will be helpful for you to answer the questions of "how to use PsList to view Oracle threads on Windows". Next, please follow the editor to study!

1. As of today, the latest version available is PsList v1.28. The download address is as follows.

Http://technet.microsoft.com/en-us/sysinternals/bb896682.aspx

two。 Decompress it

3. To facilitate direct use in CMD, the methods are as follows

1) the first way is to modify the environment variable and add a point to the directory containing the pslist.exe command

2) the second method is to copy all the extracted files to the system directory of windows

For my native XP operating system, the corresponding system directory is as follows:

Cd / > SystemRoot%/system32

C:/WINDOWS/system32 >

4. Use PsList without parameters to view information about Oracle processes started locally

From the Thd column, you can see that the oracle process contains 22 threads

CRV / > pslist oracle

Pslist v1.28-Sysinternals PsList

Copyright? 2000-2004 Mark Russinovich

Sysinternals

Process information for HOUSWLT:

Name Pid Pri Thd Hnd Priv CPU Time Elapsed Time

Oracle 7408 8 22 427 259884 0:00:03.515 0:04:39.077

5. Use the-d parameter to further view the corresponding thread details in the XP system

Displays the basic information for each thread in detail. Compared to the information obtained by using the "ps-ef | grep oracle" command on linux or UNIX, the specific thread name information is not displayed here, only the thread ID value (the Tid column).

Cvv / > pslist-d oracle

Pslist v1.28-Sysinternals PsList

Copyright? 2000-2004 Mark Russinovich

Sysinternals

Thread detail for HOUSWLT:

Oracle 7408:

Tid Pri Cswtch State User Time Kernel Time Elapsed Time

6464 9 94 Wait:Executive 0:00:00.000 0:00:00.031 0:04:44.812

7776 9 84 Wait:UserReq 0:00:00.000 0:00:00.000 0:04:44.687

5268 9 14 Wait:UserReq 0:00:00.000 0:00:00.000 0:04:44.671

2804 8 226 Wait:UserReq 0:00:00.031 0:00:00.015 0:04:41.624

7152 8 302 Wait:UserReq 0:00:00.015 0:00:00.000 0:04:41.624

7156 8 193 Wait:UserReq 0:00:00.000 0:00:00.000 0:04:41.577

4024 8 231 Wait:UserReq 0:00:00.000 0:00:00.031 0:04:41.577

8124 9 609 Wait:UserReq 0:00:00.031 0:00:00.031 0:04:41.562

6844 9 514 Wait:UserReq 0:00:00.046 0:00:00.046 0:04:41.562

7116 8 768 Wait:UserReq 0:00:00.140 0:00:00.046 0:04:41.562

4772 8 36 Wait:UserReq 0:00:00.000 0:00:00.015 0:04:41.546

4156 9 339 Wait:UserReq 0:00:00.125 0:00:00.000 0:04:41.546

620 8 1217 Wait:UserReq 0:00:00.437 0:00:00.046 0:04:41.546

5960 8 473 Wait:UserReq 0:00:00.015 0:00:00.000 0:04:41.546

4340 10 3 Wait:Queue 0:00:00.000 0:00:00.000 0:04:41.484

5040 8 275 Wait:UserReq 0:00:00.015 0:00:00.015 0:04:36.984

5020 9 181 Wait:UserReq 0:00:00.000 0:00:00.015 0:04:36.984

6832 9 66 Wait:UserReq 0:00:00.000 0:00:00.000 0:04:34.718

4332 9 49 Wait:UserReq 0:00:00.000 0:00:00.015 0:04:31.968

6964 9 38 Wait:UserReq 0:00:00.015 0:00:00.000 0:04:21.968

8008 8 44 Wait:UserReq 0:00:00.000 0:00:00.015 0:04:16.968

160 8 80 Wait:UserReq 0:00:00.000 0:00:00.031 0:00:09.750

6. Use the-m parameter to see how the oracle process is using memory

Cvv / > pslist-m oracle

Pslist v1.28-Sysinternals PsList

Copyright? 2000-2004 Mark Russinovich

Sysinternals

Process memory detail for HOUSWLT:

Name Pid VM WS Priv Priv competes for Faults NonP Page

Oracle 7408 372588 150508 254412 269920 52531 16 207

7. For more information on the parameters, please see [attached] below.

8.OK, since then I have added a command-line tool that can view Windows process information.

BTW, there are some other gadgets in this package

For example, pskill can kill unwanted processes, similar to the kill-9 command on UNIX

There are also psinfo commands to display Windows system information, etc., if you are interested, you can also skillfully use it.

[attached] use the pslist-help command to display the usage guide of the pslist command, the content description is very clear

CJV / > pslist-help

Pslist v1.28-Sysinternals PsList

Copyright? 2000-2004 Mark Russinovich

Sysinternals

Usage: pslist [- d] [- m] [- x] [- t] [- s [n] [- rn] [/ / computer [- u username] [- p password] [name | pid]

-d Show thread detail.

-m Show memory detail.

-x Show processes, memory information and threads.

-t Show process tree.

S [n] Run in task-manager mode, for optional seconds specified.

Press Escape to abort.

-r n Task-manager mode refresh rate in seconds (default is 1).

/ / computer Specifies remote computer.

-u Optional user name for remote login.

-p Optional password for remote login. If you don't present

On the command line pslist will prompt you for it if necessary.

Name Show information about processes that begin with the name

Specified.

-e Exact match the process name.

Pid Show information about specified process.

All memory values are displayed in KB.

Abbreviation key:

Pri Priority

Thd Number of Threads

Hnd Number of Handles

VM Virtual Memory

WS Working Set

Priv Private Virtual Memory

Priv competes for Private Virtual Memory Peak

Faults Page Faults

NonP Non-Paged Pool

Page Paged Pool

Cswtch Context Switches

At this point, the study on "how to use PsList to view information such as Oracle threads on Windows" is over. I hope to be able to solve your doubts. The collocation of theory and practice can better help you learn, go and try it! If you want to continue to learn more related knowledge, please continue to follow the website, the editor will continue to work hard to bring you more practical articles!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.

Views: 0

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

Servers

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report