- Process Monitor is an Oracle background process created when you start a database instance.
- The process will free up resources if a user process fails.
- It normally wakes up every 3 seconds to perform its housekeeping activities.
- Pmon must always be running else the instance terminates.
- To speed up the housekeeping the PMON can be manually wokeup as below:
SQL> oradebug wakeup 2
Assuming, PMON as process 2 here.
System Monitor(SMON)
- Performs instance recovery, cleans up after dirty shutdowns and coalesces adjacent free extents into larger free extents and also monitors temporary segments.
- Wakes up every 5 miuntes to perform activities.
- In a non-failed instance can also perform failed instance recovery for other failed RAC instances.
- In case of tablespace offline errors or any as such, the transactions are eventually recovered by SMON when taablespace or file is brought back online.
- To check if the SMON process is running:
oracle 31144 1 0 11:10 ? 00:00:00 ora_smon_orcl
Archiver's Process (ARCH)- Created when you start an instance in ARCHIVE LOG MODE.
- Writes filled redo logs to the archive log locations.
- An instance can have upto 10 ARCn processes (ARC0 to ARC9).
- The LGWR starts a new ARCn whenever current number of processes is insufficient. The alert file keeps a track of these.
- The parameter used is: LOG_ARCHIVE_MAX_PROCESSES.
Created when you start the instance.
Writes the redo log buffers to the on-line redo log files.
If these files are mirrored, all the members of the group will be written out simultaneously.
LGWR writes:
A commit record when a user process commits a transaction.
Redo log buffers
Every three seconds
When the redo log buffer is one-third full.
When a DBWn process writes modified buffers to disk, if necessary.
Graton Hotel Casino & Spa - Mapyro
ReplyDeleteGraton 전주 출장샵 Hotel 정읍 출장안마 Casino & 광양 출장안마 Spa. 1090 N. Highland St. (3121 N. Highland St., St. Louis. Directions). (270) 357-3577 or 영주 출장마사지 www.gratoncasino.com. 사천 출장안마