Oracle DBA FAQ

Oracle RAC interview questions, Oracle Dataguard, ASM, CRS, Oracle wait events, Performance Tuning

    What are the new New Background Processes for Oracle 11G



    What are the new New Background Processes for Oracle 11G

    Post  David on Sun Nov 21, 2010 6:53 am

    The following are the new database background process in 11G that you could be running depending upon the features being used.

    • DBRM (database resource manager) process is responsible for setting resource plans and other resource manager related tasks.

    • DIA0 (diagnosability process 0) (only 0 is currently being used) is responsible for hang detection and deadlock resolution.

    • EMNC (event monitor coordinator) is the background server process used for database event management and notifications.

    • FBDA (flashback data archiver process) archives the historical rows of tracked tables into flashback data archives. Tracked tables are tables which are enabled for flashback archive. When a transaction containing DML on a tracked table commits, this process stores the pre-image of the rows into the flashback archive. It also keeps metadata on the current rows.
      FBDA is also responsible for automatically managing the flashback data archive for space, organization, and retention and keeps track of how far the archiving of tracked transactions has occurred.

    • GTX0-j (global transaction) processes provide transparent support for XA global transactions in an Oracle RAC environment. The database autotunes the number of these processes based on the workload of XA global transactions. Global transaction processes are only seen in an Oracle RAC environment

    • GMON maintains disk membership in ASM disk groups.

    • KATE performs proxy I/O to an ASM metafile when a disk goes offline.

    • MARK marks ASM allocation units as stale following a missed write to an offline disk.

    • SMCO (space management coordinator) process coordinates the execution of various space management related tasks, such as proactive space allocation and space reclamation. It dynamically spawns slave processes (Wnnn) to implement the task.

    • VKTM (virtual keeper of time) is responsible for providing a wall-clock time (updated every second) and reference-time counter (updated every 20 ms and available only when running at elevated priority

      Current date/time is Mon Dec 17, 2018 1:38 am