Any background process doesn't defined as mandatory are called as optional background process. These Oracle 12C Background Process are more definite for tasks and features. For instance, Oracle Automatic Storage Management or Oracle Streams Advanced Queuing are supported under background processes are only accessible when these components are permissive and contain the following stages.
- Flashback information archiver process
- Archiver processes
- Space Management Coordinator process
- Work Queue processes
It performs archives on actual rows of tracked tables into Flashback Data Archives. When a transaction contains data manipulation language on a tracked table commits. This process stores the pre-image of the rows into the flashback data archive and in the current rows it stores the meta data information.
After a redo log switch occurs, it copy online redo log files to offline storage. This process can also collect,transmit it to standby database destinations and transaction redo data. Archived redo log files processes exist only when the database is in automatic archiving or in archive log mode.
Space Management Coordinator process
The different space administration related tasks facilitate the execution under the Space management coordinator process,Like space recovery and proactive space portion.SMCO progressively generate slave processes to actualize the work.
To run clients job in Oracle Database it utilizes work queue, frequently in group mode. A vocation is a client-characterized task planned to run one or more times. For instance, job queue to plan a long-running update in the background. The job queue processes endeavor to run the job at the following occurrence of the interval.