To maximize performance and accommodate many #users, a multiprocess #Oracle #database system uses background processes. Background processes are the processes running behind the scene and are meant to perform certain maintenance activities or to deal with abnormal conditions arising in the instance. Each background process is meant for a specific purpose and its role is well defined.
Background processes consolidate functions that would otherwise be handled by multiple database programs running for each user process. Background processes asynchronously perform I/O and monitor other Oracle database processes to provide increased parallelism for better performance and reliability.
00:00 SMONn
00:27 Instance Recovery
03:25 PMON
05:46 DBWRn
06:45 LGWR
07:44 Check Point Event
09:54 CKPT
10:52 ARCHn
Website: www.dbagenesis.com/
Facebook: / dbagenesis
Instagram: / dbagenesis
Twitter: / dbagenesis
30 июл 2024