People often ask in DBA interview what are the oracle background process and describe then
There are many type of oracle background processes each performing specified job but oracle
require five background process
1. System Monitor (SMON)
Perform instance recovery when instance crash, this process also manage space that is used during sorting
2. Process Monitor (PMON)
Process monitor cleans up failed user database connections.
3. Database Writer (DBwn*)
Write modified database blocks from SGA buffer cache to datafiles on disk(n means it can be more then one 20 max)
4. Log Writer (LGWR)
Write transactions recovery information from Redo log Buffer to online Redo Log Files
5. Checkpoint (CKPT)
Updates the database files following a checkpoint eve
1 comment:
Wow this is such a nice for new comers using Oracle, your article gives how oracle background process works which is such a very nice thing, thank you so much.
Arthur Lawrence provides Oracle Consulting and Oracle Services in USA.
Post a Comment