Leggi le modifiche e gli avvenimenti più recenti su
Accedi al tuo account o registrati come nuovo autore. Inizia subito a inviare i tuoi articoli!
Cerca nel nostro database per gli articoli.
Iscriviti per ricevere gli articoli inviati tramite e-mail direttamente al tuo account di posta elettronica. È possibile scegliere più categorie.
Guarda i nostri nuovi articoli presentati da nostri autori.
Visualizza i nostri articoli più votati valutati dai nostri visitatori.
Si prega di notare che questo NON è il gestore dell'ARTICOLO
Aggiungi una nuova EZINE, o gestisci la tua presentazione EZINE.
Aggiungi fresco, contenuti web gratuiti per il tuo sito come gli articoli più recenti, strumenti web, e citazioni con un unico pezzo di codice!
Shovon Joarder has been working as Freelance Marketing Project Manager for over four years. He also.. Di più
Is there any command in Windows like ps command in Unix? by Gitesh Trivedi
Is there any command in Windows like ps command in Unix? by GITESH TRIVEDI
Articolo pubblicato: 11/16/2009
Visualizzazioni articolo: 7034
How to check Oracle processes in windows?
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 /?
/SVC
/V /FI filter /FO format /NH
Descrizione: 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" e "CSV" formats.
/? Displays this help/usage.
STATUS eq, ne RUNNING
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 /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:
========================= ====== ================ ======== ============
4 Console 0 282,100 Okay
636 Console 0 420 Okay
692 Console 0 6,496 Okay
716 Console 0 1,336 Okay
760 Console 0 4,020 Okay
772 Console 0 7,188 Okay
956 Console 0 5,568 Okay
Means using tasklist or tasklist -v command we can manage and administor 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
Ricrea il profilo interessato? Ricrea il profilo interessato? Ricrea il profilo interessato!
Ricrea il profilo interessato
12/17/09 - 1:51:00 SONO - Shodhan Bhatnagar
Very good tip. It is working. Wonderful sharing. How many article have been written by you? Provide me everyone. Once again thanks for sharing such great resource.
Saluti, Shodhan
12/05/09 - 2:45:48 SONO - Mark Robbins
Another tool worth looking at is psList from Sysinternals (now part of Microsoft).
It is very powerful. -gb/sysinternals/
It comes with a number of other related tools that can be found here: -gb/sysinternals/
in combination they can be setup to remotely monitor servers
12/04/09 - 12:58:48 SONO - Aseem
Kool man. gud 1
Everyone:
This question is most-usually asked by Oracle DBA familiar with Unix who are being asked to perform work on a Windows platform as well. Please remember one key difference between Unix and Windows: - In Unix, Oracle translates sessions into processes. - In Windows, Oracle translates sessions into threads.
The only processes you'll see on a Windows box from running is one process per database under the context of the single service account. Anything you do to that process will affect all sessions associated with it.
12/01/09 - 10:25:40 SONO - Stella eastwood
I am appreciating great tip for Oracle dba on windows. It is very useful for remote dba work and remote dba support service in specially for windows using command line tasks. Thanks for same. Kindly provide us more great and excellent tips such like this. Have a nice day.
12/01/09 - 10:20:18 SONO - Olice Gare
Superb and thanks for sharing with afford. Pl. keep it up.
11/28/09 - 9:54:31 SONO - Greg Smith
Ciao,
Wonderful and very good technique has been shown for Oracle dba on windows. I am very appreciating.
Saluti, Greg
11/25/09 - 12:26:18 pomeridiano - Rohit Sharma
Superb and very useful tip. Do you have another tips for same on windows for Oracle DBA? Kindly provide me same. I am giving full rating for this article.Thanks for sharing same.
11/21/09 - 1:16:18 pomeridiano - Gary Merrin
Great article and found very useful in routine tasks. Keep it up. Kindly provide me your contact details.
11/17/09 - 9:51:08 SONO - Bharat Rathod
Excellent article. Very useful tips for every Oracle DBA whose working on remotely on windows. Thanks a very much to provide such kind of great article for knowledge sharing.
Submit your comments and they will be posted here.
Ricrea il profilo interessato
Ricrea il profilo interessato:
Ricrea il profilo interessato:
Ricrea il profilo interessato. Questo è solo per scopi amministrativi.
Commenti:
Joanna Morgan ha una grande passione per fare soldi online da casa e ama viaggiare per il w... Di più
Copyright © 2020, Tutti i diritti riservati.
C'è qualche comando in Windows come il comando Ps in Unix
