Database Reference
In-Depth Information
PADDR NAME DESCRIPTION
-------- ---- ----------------------------------------------------------------
32AF0E64 CJQ0 Job Queue Coordinator
32AEF8B4 QMNC AQ Coordinator
32AEE304 MMNL Manageability Monitor Process 2
32AED82C MMON Manageability Monitor Process
32AECD54 RECO distributed recovery
32AEC27C SMON System Monitor Process
32AEB7A4 CKPT checkpoint
32AEACCC LGWR Redo etc.
32AEA1F4 DBW0 db writer process 0
32AE971C MMAN Memory Manager
32AE8C44 DIA0 diagnosibility process 0
32AE816C PSP0 process spawner 0
32AE7694 DBRM DataBase Resource Manager
32AE6BBC DIAG diagnosibility process
32AE60E4 GEN0 generic0
32AE560C VKTM Virtual Keeper of TiMe process
32AE4B34 PMON process cleanup
17 rows selected.
Using the same init.ora , only replacing MEMORY_TARGET with SGA_TARGET and PGA_AGGREGATE_TARGET , in
Oracle 10 g Release 2, you might only see 12:
ops$tkyte@ORA10GR2> select paddr, name, description
2 from v$bgprocess
3 where paddr <> '00'
4 order by paddr desc
5 /
PADDR NAME DESCRIPTION
-------- ---- ----------------------------------------------------------------
23D27AC4 CJQ0 Job Queue Coordinator
23D27508 QMNC AQ Coordinator
23D26990 MMNL Manageability Monitor Process 2
23D263D4 MMON Manageability Monitor Process
23D25E18 RECO distributed recovery
23D2585C SMON System Monitor Process
23D252A0 CKPT checkpoint
23D24CE4 LGWR Redo etc.
23D24728 DBW0 db writer process 0
23D2416C MMAN Memory Manager
23D23BB0 PSP0 process spawner 0
23D235F4 PMON process cleanup
12 rows selected.
Note that you may not see all of these processes when you start your instance, but the majority of them will be
present. You will only see ARCn (the archiver) if you are in ARCHIVELOG mode and have enabled automatic archiving.
You will only see the LMD0 , LCKn , LMON , and LMSn (more details on those processes shortly) processes if you are running
Oracle RAC, a configuration of Oracle that allows many instances on different machines in a cluster to mount and
open the same physical database.
Search WWH ::




Custom Search