Archive for the ‘oracle on windows’ Category

How to check Oracle processes in windows

November 11, 2009

Hi Oracle DBA friends,

Today’s Tip for Oracle on windows.

How to check Oracle processes in windows. In unix there is command called “ps“. Using ps command we can check all type of processes which are running in system. Ps command is very usefull to administrating and monitoring oracle in unix/linux systems.

But there is no command in windows just like ps in unix. Means there is no way to find out running processes in windows system. There is only task manager available in windows system. Using task manager we can check running processes in windows system. It is very difficult to monitoring and administrating Oracle on windows systems for Oracle DBA.

Alternate of ps command:

No it is not TRUE. Windows has own command to trace all running processes in the system. Using “tasklist” command we can trace all running processes in windows including oracle,sqlplus,exp,imp and others. Tasklist command is very closer to ps command.

Please check help of tasklist command.

C:\>tasklist /?

TASKLIST [/S system [/U username [/P [password]]]] [/M [module] | /SVC | /V] [/FI filter] [/FO format] [/NH]

Description: This command line tool displays a list of application(s) and associated task(s)/process(es) currently running on either a local or remote system.

Parameter List:

/S system Specifies the remote system to connect to.

/U [domain\]user Specifies the user context under which the command should execute.

/P [password] Specifies the password for the given user context. Prompts for input if omitted.

/M [module] Lists all tasks that have DLL modules loaded in them that match the given pattern name. If the module name is not specified, displays all modules loaded by each task.

/SVC Displays services in each process.

/V Specifies that the verbose information is to be displayed.

/FI filter Displays a set of tasks that match a given criteria specified by the filter.

/FO format Specifies the output format.

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

pecifies that the “Column Header” should not be displayed in the output. Valid only for “TABLE” and “CSV” formats.

/? Displays this help/usage.

Filters: Filter Name Valid Operators Valid Value(s) ———– ————— ————–

STATUS eq, ne RUNNING | NOT RESPONDING

IMAGENAME eq, ne Image name

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

USERNAME eq, ne User name in [domain\]user format

SERVICES eq, ne Service name

WINDOWTITLE eq, ne Window title

MODULES eq, ne DLL name

Examples:

TASKLIST

TASKLIST /M

TASKLIST /V

TASKLIST /SVC

TASKLIST /M wbem*

TASKLIST /S system /FO LIST

TASKLIST /S system /U domain\username /FO CSV /NH

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

Means using tasklist or tasklist -v command we can monitor and administor our oracle processes.

Now never tell that you haven’t ps command for windows !!!

All the best,

Gitesh Trivedi

Remote database monitoring