FINDING PID PROCESS ID USING VIEWS

through SQL*Plus via the following query :

SYS@prod SQL>select b.name bkpr , s.Username spid, p.pid
2 from V$BGPROCESS b, V$SESSION s, V$PROCESS p
3 where p.Addr = b.Paddr(+)
4 and p.Addr = s.Paddr
5 /

BKPR  SPID                                  PID
----- ------------------------------ ----------
PMON                                          2
PSP0                                             3
MMAN                                         4
DBW0                                           5
ARC0                                          17
ARC1                                          18
ARC2                                          19
LGWR                                          6
CKPT                                           7
RVWR                                        16
SMON                                           8

BKPR  SPID                                  PID
----- ------------------------------ ----------
RECO                                          9
CJQ0                                         10
QMNC                                       20
MMON                                      11
MMNL                                       12
                                            28
                                            26
                                            21
                                            27
                                            23
                                            25

BKPR  SPID                                  PID
----- ------------------------------ ----------
                                           22
SYS                                    15
                                           24
                                           29

26 rows selected.

using os linux command in SQL*Plus
(if it is linux os)
ps -ef | grep oracle
or
ps -ef | grep database_name

SYS@prod SQL>!ps -ef | grep prod
oracle    7636     1  0 12:26 ?        00:00:00 ora_pmon_prod
oracle    7638     1  0 12:26 ?        00:00:00 ora_psp0_prod
oracle    7640     1  0 12:26 ?        00:00:00 ora_mman_prod
oracle    7642     1  0 12:26 ?        00:00:00 ora_dbw0_prod
oracle    7644     1  0 12:26 ?        00:00:00 ora_lgwr_prod
oracle    7646     1  0 12:26 ?        00:00:00 ora_ckpt_prod
oracle    7648     1  0 12:26 ?        00:00:00 ora_smon_prod
oracle    7650     1  0 12:26 ?        00:00:00 ora_reco_prod
oracle    7652     1  0 12:26 ?        00:00:00 ora_cjq0_prod
oracle    7654     1  0 12:26 ?        00:00:00 ora_mmon_prod
oracle    7656     1  0 12:26 ?        00:00:00 ora_mmnl_prod
oracle    7658     1  0 12:26 ?        00:00:00 ora_d000_prod
oracle    7660     1  0 12:26 ?        00:00:00 ora_s000_prod
oracle    7663     1  0 12:26 ?        00:00:00 ora_rvwr_prod
oracle    7664  7633  0 12:26 ?        00:00:00 oracleprod (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
oracle    7666     1  0 12:26 ?        00:00:00 ora_arc0_prod
oracle    7668     1  0 12:26 ?        00:00:00 ora_arc1_prod
oracle    7672     1  0 12:26 ?        00:00:00 ora_qmnc_prod
oracle    7688     1  0 12:26 ?        00:00:00 ora_q000_prod
oracle    7690     1  0 12:26 ?        00:00:00 ora_q001_prod
oracle    8049     1  3 13:42 ?        00:00:00 ora_j000_prod
oracle    8050  7633  1 13:42 pts/1    00:00:00 -bin/tcsh -c ps -ef | grep prod
oracle    8063  8050  0 13:42 pts/1    00:00:00 grep prod

Thank you,

How to know process ID or PID on windows

Process Identifier or Process ID or PID is the unique ID of a process running on the system. With PID we can uniquely identify a process and can know about their characteristics.

On unix based system like linux, solaris, HP-UX with "ps" command we can easily identify each type of process and their PID. We can also grep the output for filtering. But for Windows operating system such as Windows 95, Windows 98, Windows 2000, Windows XP, Windows Vista, Windows Server 2003, Windows Server 2008 and Windows 7 there is no such utility or command.

In windows through GUI we can still see the process ID or PID of a process. This is sometime very essential to track a culprit process. It can be seen from Task Manager. To get Task Manager right click on empty area in the task bar and then you can select Task Manger. You can also get Task Manager window by clicking CTRL+ALT+DEL.

After opening task manager you will see there is no process ID or PID there by default. But you can see Processes tab there. Whenever you click on processes tab, process information is shown. By default option is Image Name(Process Name), User Name(the user under whom process is running), CPU(percentage of CPU usage) and Mem Usage(Total how many KB is allocated to the process).

To get Process ID,
- Click Processes tab.
- Click on View menu, then click on Select Columns.
- In the "Select Columns" or "Select Process Page Columns" dialog, check the checkbox for PID (Process Identifier), and click OK.

You will see PID is shown and you can easily track each process identifier.

thank you,