Database Reference
In-Depth Information
SYS@ORA12CR1> !cat /tmp/pfile
...
*.compatible='12.1.0.1'
*.control_files='/u01/dbfile/ORA12CR1/control01.ctl','/u02/dbfile/ORA12CR1/control02.ctl'
*.db_block_size=8192
*.db_name='ORA12CR1'
*.memory_target=500M
*.undo_tablespace='UNDOTBS1'
In Oracle 12 c Release 1, you would have about 22 background processes started up:
EODA@ORA12CR1> select paddr, name, description
2 from v$bgprocess
3 where paddr <> '00'
4 order by paddr desc
5 /
PADDR NAME DESCRIPTION
---------------- ----- ----------------------------------------------------------------
000000007F188558 VKRM Virtual sKeduler for Resource Manager
000000007F17FA58 CJQ0 Job Queue Coordinator
000000007F17E8F8 AQPC AQ Process Coord
000000007F17D798 FBDA Flashback Data Archiver Process
000000007F17C638 SMCO Space Manager Process
000000007F17A378 TMON Transport Monitor
000000007F175DF8 MMNL Manageability Monitor Process 2
000000007F174C98 LREG Listener Registration
000000007F173B38 RECO distributed recovery
000000007F1729D8 SMON System Monitor Process
000000007F16F5B8 CKPT checkpoint
000000007F16E458 LGWR Redo etc.
000000007F16D2F8 DBW0 db writer process 0
000000007F16C198 DIA0 diagnosibility process 0
000000007F16B038 DBRM DataBase Resource Manager
000000007F169ED8 DIAG diagnosibility process
000000007F168D78 MMON Manageability Monitor Process
000000007F167C18 MMAN Memory Manager
000000007F166AB8 GEN0 generic0
000000007F165958 VKTM Virtual Keeper of TiMe process
000000007F1647F8 PSP0 process spawner 0
000000007F163698 PMON process cleanup
22 rows selected.
In Oracle 11 g Release 2, with that same init.ora file, you would have about 17 background processes started up:
ops$tkyte@ORA11GR2> select paddr, name, description
2 from v$bgprocess
3 where paddr <> '00'
4 order by paddr desc
5 /
Search WWH ::




Custom Search