Can there be any command in Home windows like ps command in Unix

How you can check Oracle processes in home windows?

How you can check Oracle processes in home windows. This really is burning problem for each Oracle DBA.

In unix there’s command known as “ps”. Using ps command Oracle DBA can check all kind of processes that are running in system. Ps command is extremely helpful to managing and monitoring oracle in unix/linux systems for those Oracle DBA.

But there’s no command obtainable in home windows much like ps in unix! Means there’s not a way to discover running processes in home windows system using command line! Only task manager option will come in home windows system for Oracle DBA. Using task manager we are able to check running processes in home windows system. Task manager is GUI tool. It is sometimes tough to monitoring and managing Oracle on home windows systems for Oracle DBA using GUI tool.

Alternate of ps command in home windows (Great tip for Oracle DBA):

No it’s not TRUE. Really !!! Home windows has own command to follow all running processes within the system. Using “tasklist” command Oracle DBA can in a position to trace all running processes in home windows including oracle,sqlplus,exp,imp yet others. Tasklist command is extremely nearer to ps command. Using tasklist command Oracle DBA can in a position to access process ids, session ids, cpu time, and modules of running processes in Oracle on Home windows.

Book assistance of tasklist command.

C:>tasklist /? TASKLIST [/S system [/U username [/P [password]]]] [/M [module] e]


/V] [/FI filter] [/FO format] [/NH]

Description: This command line tool shows a listing of application(s) and connected task(s)/process(es) presently running on whether local or remote system.

Parameter List: /S system Identifies the remote system for connecting to.

/U [domain]user Identifies the consumer context to which the command should execute.

/P [password] Identifies the password for that given user context. Prompts for input if overlooked.

/M [module] Lists all tasks which have DLL modules loaded inside them that match the given pattern title. When the module title isn’t specified, shows all modules loaded by each task.

/SVC Shows services in every process.

/V Identifies the verbose information will be displayed.

/FI filter Shows some tasks that match confirmed criteria per the filter.

/FO format Identifies the output format.

Valid values: “TABLE”, “LIST”, “CSV”. /NH S

pecifies the “Column Header” shouldn’t be displayed within the output. Valid just for “TABLE” and “CSV” formats.

/? Shows this help/usage.


Filter Title Valid Operators Valid Value(s) —- —– —– STATUS eq, ne RUNNING

NOT Reacting

IMAGENAME eq, ne Image title

PID eq, ne, gt, lt, general electric, le PID value

SESSION eq, ne, gt, lt, general electric, le Session number

SESSIONNAME eq, ne Session title

CPUTIME eq, ne, gt, lt, general electric, le CPU amount of time in the format of hh:mm:ss. hh – hrs, mm – minutes, ss – seconds

MEMUSAGE eq, ne, gt, lt, general electric, le Memory usage in KB

USERNAME eq, ne User title in [domain]user format

SERVICES eq, ne Service title

WINDOWTITLE eq, ne Window title

MODULES eq, ne DLL title

Good examples: TASKLIST




TASKLIST /S system /FO LIST TASKLIST /S system /U domainusername /FO CSV /NH

TASKLIST /S system /U username /P password /FO TABLE /NH TASKLIST /FI “USERNAME ne NT AUTHORITYSYSTEM” /FI “STATUS eq running”


C:>tasklist Image Title PID Session Title Session# Mem Usage

========================= ====== ================ ======== ============ System Idle Process Console 16 K

oracle.exe 4 Console 282,100 K smss.exe 636 Console 420 K

csrss.exe 692 Console 6,496 K winlogon.exe 716 Console 1,336 K

services.exe 760 Console 4,020 K lsass.exe 772 Console 7,188 K

svchost.exe 956 Console 5,568 K

Means using tasklist or tasklist -v command we are able to manage and administor our oracle processes.

Now never tell you don’t have ps command for home windows !!!

Best wishes,

Gitesh Trivedi

About The Writer: Gitesh Trivedi is experienced Oracle DBA and dealing in Dbametrix. He’s excellent 12 years experience. You are able to achieve him on-site

offers Remote DBA support and Offshore Oracle DBA support. All copyright reserved by @Dbametrix. Contact mailto: or at

Leave a comment

Your email address will not be published. Required fields are marked *