Cpu Mem

How to check Oracle processes in Windows?

Is there a command in Windows as on UNIX PS command?

How to check Oracle processes on Windows. This burning issue for every Oracle DBA.

In UNIX has a command called "PS". Using PS command Oracle DBA can check all Type of processes which operate the system. Ps Command Is very useful to Administrating and monitoring Oracle on Unix / Linux Systems For any Oracle DBA.

But there is no command Available in Windows just like PS on UNIX! Says that Way to find running processes using the Windows Command line! Task Manager only option available Windows for Oracle DBA system. Using Task Manager can Check running processes in Windows. Task Manager He GUI tool. Sometimes it is very difficult to monitor Administrating Oracle on Windows for Oracle DBA use GUI.

Alternate command of PS on Windows (Great Tip for Oracle DBA):

No command is not True. Really! Windows has to follow as All running processes of the system. Using "tasklist" Oracle DBA command can able to trace all processes Runs on Windows, including Oracle, Sqlplus, exp, breast and others. Tasklist Order is an order very close to the PS. Through Tasklist Oracle DBA can can access the process identifiers, identifiers Run, CPU time, and modules of running processes Oracle on Windows.

Please check help Of Tasklist.

C:> tasklist /?

Tasklist [/ S system [/ U user [/ P [password]]]] [/ M [module] | / SVC | / V] [/ FI filter] [/ for format] [/ NH]

style = "; text-align: right; direction: ltr"> Description: A command line tool displays A list of application (s) and associated task (s) / Process (es) currently running on local or remote system.

Parameter list:

/ S system specifies the remote system to connect.

/ U [domain] user Specifies the context User under which to perform the command.

/ P [password] Specifies the password for the user context Given. Ask for input if omitted.

/ M [module] lists all tasks that have DLL modules of Requiring that match a given pattern name. If there Module is not specified, displays all modules loaded By any task.

/ Services shows SVC in the process.

/ V Specifies that the information Detailed display.

/ FI filter Displays a set Of tasks that match a given criteria specified By the filter.

/ Notes for Format the output format.

Valid values: "table", "list", "CSV". / NH S

Pecifies that "Title Column "No output should be displayed. Is valid only For "" table "CSV" formats.

/? Displays help / usage.

Filters: Filter Name Valid Operators Valid Value (s) ---- ----- -----

STATUS eq, ne RUNNING | not responding

IMAGENAME EQ, a picture ne

PID eq, ne, gt, lt, ge, le PID value

Session eq, ne, gt, lt, ge, le Session number

SESSIONNAME EQ, NE Session Name

CPUTIME eq, ne, gt, lt, ge, le CPU time in the format of HH: mm: ss. hh - hours, mm - minutes ss - seconds

MEMUSAGE eq, ne, gt, lt, ge, le Memory usage in KB

style = "; text-align: right; direction: ltr"> USERNAME EQ, a user name Jenna on [domain] user template

EQ services, where service ne

WINDOWTITLE EQ, ne window title

EQ modules, DLL name ne

Examples:

Tasklist

Tasklist / M

Tasklist / V

style = "; text-align: right; direction: ltr"> Tasklist / SVC

Tasklist / wbem M *

Tasklist / S system / list

Tasklist / System S / Domainusername U / for CSV / NH

Tasklist / S system / U username / P password / board / NH Tasklist / FI "USERNAME ne NT AUTHORITYSYSTEM" / FI "STATUS EQ ran"

Example:

C:> tasklist

Image Name PID Session Name Session # Mem Usage

========================= ====== ================ ======== ============

System Standby Recovery process 0 K 0 16

Oracle.exe 4 terminal 0 282.100 K

smss.exe 636 Console 0 420 K

Csrss.exe 692 Console 0 6496 K

Winlogon.exe 716 Console 0 1,336 K

Services.exe 760 Console 0 4020 K

lsass.exe 772 Console 0 7188 K

svchost.exe 956 Console 0 5568 K

Tasklist means using or Tasklist-V command we can monitor the processes Administor Our Oracle.

Now I never say You have orders not to PS for Windows!

Best,

Gitesh Trivedi

Intel P35 CPU/Memory Overclocking Guide