How to check Oracle processes in windows using command line

by Gitesh Trivedi.
Share
|
Homepage | Submit your article | Contact | TOS
More articles on databases  

You are here: Categories » Computers and technology » Databases

Is there any command in Windows like ps command in Unix?

How to check Oracle processes in windows. This is burning problem for every Oracle DBA.

In unix there is command called "ps". Using ps command Oracle DBA can check all type of processes which are running in system. Ps command is very useful to administrating and monitoring oracle in unix/linux systems for all Oracle DBA.

But 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 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 GUI tool. Sometimes it is very difficult to monitoring and administrating Oracle on windows systems for Oracle DBA using 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 closer 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.

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"

Example:

C:\>tasklist

Image Name PID Session Name Session# Mem Usage

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

System Idle Process 0 Console 0 16 K

oracle.exe 4 Console 0 282,100 K

smss.exe 636 Console 0 420 K

csrss.exe 692 Console 0 6,496 K

winlogon.exe 716 Console 0 1,336 K

services.exe 760 Console 0 4,020 K

lsass.exe 772 Console 0 7,188 K

svchost.exe 956 Console 0 5,568 K

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

Now never tell that you don't have ps command for windows !!!

All the best,

Gitesh Trivedi

About The Author: Gitesh Trivedi is an Expert Oracle DBA and working in Dbametrix. He has excellent 12 years experience. You can reach him on site http://www.dbametrix.com offers Remote DBA support and Offshore Oracle DBA support. All copyright reserved by @Dbametrix. contact mailto:info@dbametrix.com or at http://www.dbametrix.com/service.html

Share
Leave a comment or ask a question
Total comments: 0

Databases Disclaimer

  • The e-articles directory is not responsible for any and all copyright infringements by writers and authors. If you suspect the information contained by this page for any copyright infringements, please contact us to investigate the issue
Basic Terms of Structured Query Language (SQL) - The first questions to ask are what is SQL and how do you use it with databases? SQL has three main roles: 1. Creating a database and defining its structure 2. Querying the d (more...)
Extracting and Transforming Data in SQL Server 2000 - SQL Server 2000 has several components that support the import and export of data. Data Transformation Services (DTS) is used to import and export data between like OLE DB (more...)
Introduction to SQL - SQL is an acronym for Structured Query Language and is the standard language for interaction with databases. SQL is both an ISO (International Organization for Standardization) and ANSI (Americ (more...)
What Is a Database - A database is simply an organized collection of information. It allows many different types of data to be stored and retrieved in a highly efficient manner. Information within a database (more...)
Installing MySQL Server - Installing MySQL is relatively painless. First, you need the installation program for MySQL, which is available on the companion CD. You can also download the latest version from (more...)
Basic SQL syntax: Creating and Modifying tables and databases - This tutorial shows basic syntax and commands and of the SQL language. Creating and Dropping Databases First, let's see what databases already exist in the MySQL server. We (more...)
Joining SQL Tables - When accessing information within database tables, we may sometimes need to look at data from two or more different tables, as we saw in the previous example. There is another useful way to acc (more...)
Relational SQL Databases - Think of a database that related the players in a game to one another (for example, to determine who was a friend of each player and who was an enemy of each player). First let's create (more...)
SQL Data Import Methods - This article presents the most common ways of importing data to MySQL. Importing from a Text File To create a text file that contains several records to be added to ou (more...)
SQL Data Manipulation: Select Insert Delete and Modify SQL data - This tutoriald focuses on how to add, modify, and remove data from tables in the database using SQL Data Manipulation Language. Without this knowledge, we would not really have any use for a (more...)
 
free content
    Copyright © 2006 - 2012 e-articles.info.
The texts, articles and tutorials in the directory are property of their respective owners and authors.