How To Check Oracle Processes In Windows Using Command Line?

-
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 !!!

Comments

Post a Comment

Popular posts from this blog

-
What cloud computing really means The next big trend sounds nebulous, but it's not so fuzzy when you view the value proposition from the perspective of IT professionals By Eric Knorr, Galen Gruman | InfoWorld a metaphor for the Internet, "the cloud" is a familiar cliché, but when combined with "computing," the meaning gets bigger and fuzzier. Some analysts and vendors define cloud computing narrowly as an updated version of utility computing: basically virtual servers available over the Internet. Others go very broad, arguing anything you consume outside the firewall is "in the cloud," including conventional outsourcing. [ Get the no-nonsense explanations and advice you need to take real advantage of cloud computing in InfoWorld editors' 21-page Cloud Computing Deep Dive PDF special report, then go deeper in our Server Virtualization Deep Dive. | Stay up on the cloud with InfoWorld's Cloud Computing Report newsletter. ] Cloud computing comes in
Read more

Top 20 iPhone Productivity Apps for Organized and Lazy

-
Image
Productivity can mean a lot of different things to different people. To some, it means easier note taking. To others, it's a virtual public assistant. To still others, it means keeping track of billing hours. When it comes down to it, though, productivity apps are those applications that will make it easier for you to get things done – at home and at work. And there are tons of apps out there, so finding ones that actually do what you need or want can be a bit difficult. So here are 20 iPhone productivity apps to keep you on track. To-do lists and notes • Evernote There are lots of apps that allow you to take notes and organize them and do all sorts of nifty things with them. But if you want to access that note from, say, your father's computer because you're not at home and your iPhone ran out of power, you better have e-mailed it to yourself. Or have Evernote, which allows you to skip the e-mail part of the process but gives you access to your notes, lis
Read more

Get Your Freebies From Sites Like PZs Freebies

-
As more and more companies are faced with competition from other companies in terms of similar goods and services offered, it is no surprise that more and more companies offer great freebies for consumers to avail of. Because of this, a lot of major websites have been collecting freebies information and make a freebies listing of where, when and how you can avail of great freebies from different companies and businesses. Websites like PZs freebies, thefreesite.com, or freebielist.com are just a few websites that offer good complete listings of freebies available to people in different regions from different businesses and companies. PZs freebies, for instance, is a great freebies look-up page that can give you updated information on where you can avail of the next great freebies. It also allows the user to search its database of freebies depending on which products and companies you want to search. Look-up sites like PZs are great ways of finding where you can get your next
Read more