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
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 /SVC TASKLIST /M wbem*
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 !!!
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