SQL> select sid, process, program from v$session s join v$bgprocess using (paddr) where s.status = 'ACTIVE' and rownum <20;
SID PROCESS PROGRAM
-----------------------------------------------------------------------
1 3248 ORACLE.EXE (DIA0)
2 3280 ORACLE.EXE (MMNL)
32 3252 ORACLE.EXE (MMAN)
63 3220 ORACLE.EXE (PMON)
64 3256 ORACLE.EXE (DBW0)
94 3224 ORACLE.EXE (PSP0)
95 3260 ORACLE.EXE (LGWR)
98 3408 ORACLE.EXE (QMNC)
125 3232 ORACLE.EXE (VKTM)
126 3264 ORACLE.EXE (CKPT)
157 3236 ORACLE.EXE (GEN0)
158 3268 ORACLE.EXE (SMON)
187 3240 ORACLE.EXE (DIAG)
188 3272 ORACLE.EXE (RECO)
190 5816 ORACLE.EXE (SMCO)
218 3244 ORACLE.EXE (DBRM)
219 3276 ORACLE.EXE (MMON)
222 4040 ORACLE.EXE (CJQ0)
18 rows selected.
Happy Learning....
No comments:
Post a Comment