Oracle DBA monitors Oracle processes on Unix using ps command. It is a rumour that there is no alternate command available in windows for checking oracle processes on windows. This technical tip helps Oracle DBA for monitoring Oracle processes on windows using the command line. Burning problem of Oracle DBA is how to check Oracle process in Windows while GUI not available. In Unix, it is very easy for administrating using ps command. Is there any alternate available in Windows?
How to check Oracle processes in windows. This is a burning problem for every Oracle DBA. You can always get remote DBA services so the manage it for you like Dbametrix.
In Unix, there is a command called “ps“. Using ps command Oracle DBA can check all type of processes which are running in the system. Ps command is very useful to administrating and monitoring Oracle in Unix/Linux systems for all Oracle DBA.
But unfortunately, there is no command available in windows just like ps in Unix! Means there is no way to find out running processes in windows system using the command line! Only task manager option is available in windows system for Oracle DBA. Using task manager we can check running processes in windows system. Task manager is a GUI tool. Sometimes it is very difficult to monitoring and administrating Oracle on windows systems for Oracle DBA using the GUI tool.
Alternate of ps command in windows (Great tip for Oracle DBA):
No, it is not TRUE. Really !!! Windows has own command to trace all running processes in the system. Using “tasklist” command Oracle DBA can able to trace all running processes in windows including Oracle, Sqlplus, exp, imp and others. Tasklist command is very close to ps command. Using tasklist command Oracle DBA can able to access process ids, session ids, CPU time, and modules of running processes in Oracle on Windows.