{"id":1081,"date":"2018-07-25T20:02:46","date_gmt":"2018-07-25T20:02:46","guid":{"rendered":"http:\/\/dbtut.com\/?p=1081"},"modified":"2020-01-02T08:37:19","modified_gmt":"2020-01-02T08:37:19","slug":"oracle-background-processes","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2018\/07\/25\/oracle-background-processes\/","title":{"rendered":"Oracle Background Processes"},"content":{"rendered":"

The most important two components of Oracle Instance are SGA and Background Processes. Each Oracle Database process on the operating system is responsible for one task. Each process runs in harmony with the other process.<\/span><\/p>\n

Background Processes are actively running as long as the Oracle Instance is running.<\/span><\/p>\n

If you are working on unix and linux systems, each process is separate and each has different tasks.<\/p>\n

On Windows, there is only one process called oracle.exe, and all processes are executed through this process.<\/p>\n

Some background processes can be found below.<\/p>\n

Before you read this article, I suggest you read the article “Oracle Memory Components(SGA and PGA)<\/a>” to understand some of the concepts and content I use on the article.<\/p>\n

How To Find Background Running Process in Linux<\/h3>\n

Running background processes can be seen as follows.<\/p>\n

-bash-3.2$ ps -ef | grep ora_\noracle     913   884  0 16:06 pts\/1    00:00:00 grep ora_\noracle   31003     1  0 13:03 ?        00:00:00 ora_pmon_ONURDB\noracle   31007     1  0 13:03 ?        00:00:00 ora_psp0_ONURDB\noracle   31011     1  0 13:03 ?        00:00:04 ora_vktm_ONURDB\noracle   31017     1  0 13:03 ?        00:00:00 ora_gen0_ONURDB\noracle   31021     1  0 13:03 ?        00:00:00 ora_diag_ONURDB\noracle   31025     1  0 13:03 ?        00:00:00 ora_dbrm_ONURDB\noracle   31029     1  0 13:03 ?        00:00:03 ora_dia0_ONURDB\noracle   31033     1  0 13:03 ?        00:00:00 ora_mman_ONURDB\noracle   31037     1  0 13:03 ?        00:00:00 ora_dbw0_ONURDB\noracle   31041     1  0 13:03 ?        00:00:00 ora_lgwr_ONURDB\noracle   31045     1  0 13:03 ?        00:00:01 ora_ckpt_ONURDB\noracle   31049     1  0 13:03 ?        00:00:00 ora_smon_ONURDB\noracle   31053     1  0 13:03 ?        00:00:00 ora_reco_ONURDB\noracle   31057     1  0 13:03 ?        00:00:01 ora_mmon_ONURDB\noracle   31061     1  0 13:03 ?        00:00:02 ora_mmnl_ONURDB\noracle   31065     1  0 13:03 ?        00:00:00 ora_d000_ONURDB\noracle   31069     1  0 13:03 ?        00:00:00 ora_s000_ONURDB\noracle   31087     1  0 13:03 ?        00:00:00 ora_arc0_ONURDB\noracle   31091     1  0 13:03 ?        00:00:00 ora_arc1_ONURDB\noracle   31095     1  0 13:03 ?        00:00:00 ora_arc2_ONURDB\noracle   31099     1  0 13:03 ?        00:00:00 ora_arc3_ONURDB\noracle   31103     1  0 13:03 ?        00:00:00 ora_qmnc_ONURDB\noracle   31131     1  0 13:03 ?        00:00:01 ora_cjq0_ONURDB\noracle   31143     1  0 13:03 ?        00:00:00 ora_q000_ONURDB\noracle   31147     1  0 13:03 ?        00:00:00 ora_q001_ONURDB\noracle   31200     1  0 13:08 ?        00:00:00 ora_smco_ONURDB\noracle   31745     1  0 13:58 ?        00:00:00 ora_w000_ONURDB<\/pre>\n
Or it can be seen by querying v$process view.<\/p>\n
SQL> desc v$process;\nName                                      Null?    Type\n ----------------------------------------- -------- ----------------------------\n ADDR                                               RAW(8)\n PID                                                NUMBER\n SPID                                               VARCHAR2(24)\n PNAME                                              VARCHAR2(5)\n USERNAME                                           VARCHAR2(15)\n SERIAL#                                            NUMBER\n TERMINAL                                           VARCHAR2(30)\n PROGRAM                                            VARCHAR2(48)\n TRACEID                                            VARCHAR2(255)\n TRACEFILE                                          VARCHAR2(513)\n BACKGROUND                                         VARCHAR2(1)\n LATCHWAIT                                          VARCHAR2(16)\n LATCHSPIN                                          VARCHAR2(16)\n PGA_USED_MEM                                       NUMBER\n PGA_ALLOC_MEM                                      NUMBER\n PGA_FREEABLE_MEM                                   NUMBER\n PGA_MAX_MEM                                        NUMBER\n\nSQL> SELECT PID, USERNAME, PROGRAM FROM V$PROCESS;\n\n       PID USERNAME        PROGRAM\n---------- --------------- ------------------------------------------------\n         1                 PSEUDO\n         2 oracle          oracle@DBONUR (PMON)\n         3 oracle          oracle@DBONUR (PSP0)\n         4 oracle          oracle@DBONUR (VKTM)\n         5 oracle          oracle@DBONUR (GEN0)\n         6 oracle          oracle@DBONUR (DIAG)\n         7 oracle          oracle@DBONUR (DBRM)\n         8 oracle          oracle@DBONUR (DIA0)\n         9 oracle          oracle@DBONUR (MMAN)\n        10 oracle          oracle@DBONUR (DBW0)\n        11 oracle          oracle@DBONUR (LGWR)\n\n       PID USERNAME        PROGRAM\n---------- --------------- ------------------------------------------------\n        12 oracle          oracle@DBONUR (CKPT)\n        13 oracle          oracle@DBONUR (SMON)\n        14 oracle          oracle@DBONUR (RECO)\n        15 oracle          oracle@DBONUR (MMON)\n        16 oracle          oracle@DBONUR (MMNL)\n        17 oracle          oracle@DBONUR (D000)\n        18 oracle          oracle@DBONUR (S000)\n        19 oracle          oracle@DBONUR (SMCO)\n        20 oracle          oracle@DBONUR (ARC0)\n        21 oracle          oracle@DBONUR (ARC1)\n        22 oracle          oracle@DBONUR (ARC2)\n\n       PID USERNAME        PROGRAM\n---------- --------------- ------------------------------------------------\n        23 oracle          oracle@DBONUR (ARC3)\n        24 oracle          oracle@DBONUR (QMNC)\n        25 oracle          oracle@DBONUR (W000)\n        26 oracle          oracle@DBONUR (Q000)\n        27 oracle          oracle@DBONUR (Q001)\n        28 oracle          oracle@DBONUR (CJQ0)\n        29 oracle          oracle@DBONUR (TNS V1-V3)\n        33 oracle          oracle@DBONUR (TNS V1-V3)\n\n30 rows selected.\n<\/pre>\n
Oracle Background Processes<\/h2>\n
SMON(The System Monitor)<\/h3>\n
SMON’s main task is to mount and open the database. When doing this, it finds and validates ControlFile.<\/p>\n
It then finds all the data and log files with the information in the ControlFile, validates it, and finally opens the database. After the database is opened, SMON has some tasks. For example, clears the empty spaces in the datafile. And if necessary, perform the recover operation at the start of the instance.<\/p>\n
Its responsible for Instance recovery. If the database is suddenly shut down in some way, it recovers Instance using Online Redo Log files in NOMOUNT step when the database is restarted. It makes the database consistent. It is also responsible for cleaning up “Temporary Segments”. In addition, suddenly terminated “Transactions” are recovered by SMON.<\/p>\n
If the SMON process is killed on Linux, Instance will close suddenly.<\/p>\n
-bash-3.2$ ps -ef | grep smon | grep -v grep\noracle    1087     1  0 16:17 ?        00:00:00 ora_smon_ONURDB\n-bash-3.2$ kill -9 1087\n-bash-3.2$ sqlplus \/ as sysdba\n\nSQL*Plus: Release 11.2.0.4.0 Production on Tue Jun 23 16:22:27 2015\n\nCopyright (c) 1982, 2013, Oracle.  All rights reserved.\n\nConnected to an idle instance.\n\nSQL>\n<\/pre>\n
PMON(The Process Monitor):<\/h3>\n
A user session is a user processes that connect to server processes. Server processes start when the user session starts and ends when the session ends. If the user session is not properly shut down, PMON follows this process, closes the relevant server processes and returns the PGA memory it allocates. If there is an uncommitted transaction, it rolls back.<\/p>\n
So, it is responsible for clearing the server processes of failed and suddenly terminated user processes, releasing the resources used by those processes and returning them to the operating system.<\/p>\n
DBWn(Database Writer):<\/h3>\n
Sessions do not write directly to disk (update, insert, delete). First it is written in the Database Buffer Cache.<\/p>\n
Database Writer is responsible for transfering dirty(changed data blocks by DML) data blocks in the Database Buffer Cache to the Physical Data Files. In addition, if you want to read data and if the data is not in the Database Buffer Cache, it is responsible for transfering data to Database Buffer Cache from the Physical Data Files.<\/p>\n
There can be more than one Database Writer in an instance. The maximum number is 20. Therefore, there is an “n” at the end of the name. By default, there is a Database Writer for every 8 CPUs.<\/p>\n
The Database Writer does not write all of the dirty data in the buffer (the records that have changed since reading the disk) waiting to be written.<\/p>\n
When dbwr writes to data files<\/h4>\n
    \n
  1. When there is no free buffer in the Database Buffer Cache, a server process should first find a free buffer when it wants to throw a block into the Database Buffer Cache. If it does not find any free buffers or if it takes too much time to find the free buffer, it sends a message to the Database Writer to write a portion of the dirty buffer (writes starting from the longest unused time) to disk.<\/li>\n
  2. If there are too many Dirty Buffers, the Database Writer is triggered even if there is no other reason.<\/li>\n
  3. DBWn is triggered every 3 seconds even if the problems in the above two items do not occur.<\/li>\n
  4. If a tablespace is set to OFFLINE,<\/li>\n
  5. If a tablespace is set to read-only.<\/li>\n
  6. If a table is dropped,<\/li>\n
  7. If a table is truncated,<\/li>\n
  8. If a tablespace is set to BACKUP mode,<\/li>\n
  9. If a Checkpoint operation is performed,<\/li>\n
  10. In any of the above mentioned items, the entire dirty buffer do not written to the disk(only one part is written). If checkpoint process occurs, all dirty buffers are written directly to disk. This is a costly process. When Checkpoint operation is performed, CPU usage and disk I\/O increases.<\/li>\n<\/ol>\n
    To change the number of Database Writer, we need to set the DB_WRITER_PROCESS parameter.<\/p>\n
    SQL> show parameter db_writer\n\nNAME                                 TYPE        VALUE\n------------------------------------ ----------- ------------------------------\ndb_writer_processes                  integer     1\n<\/pre>\n
    LGWR(The Log Writer)<\/h3>\n
    LGWR is responsible for writing the blocks in the Redo Log Buffer to the Online Redo Log file on the Physical disk. Every transaction that occurs in the database is stored in the Redo Log Buffer. Unlike the DBW (n) process, LGWR (n) is a hardworking process.<\/span><\/p>\n
    There is a Redo Log Buffer area in the SGA<\/span> f<\/span>or the Redo Log Files.<\/span><\/p>\n
    Processes are not written directly to the redo log file. The data that needs to be transferred to disk is stored in the redo log buffer first.<\/p>\n
    However, in order to ensure that the changes are not lost, the data in the redo log buffer is also written to the redo log on disk almost in real time.<\/p>\n
    LGWR writes the data in the Redo Log Buffer to the Redo Log in the disk.<\/p>\n
    If a commit operation is performed, LGWR writes the redo log in the “redo log buffer” in real time.<\/p>\n
    Because the COMMITTED data must be guaranteed.<\/p>\n
    When lgwr writes to redo log files<\/h4>\n
      \n
    • In each commit transaction,<\/li>\n
    • When 1\/3 of the Redo Log buffer area is full,<\/li>\n
    • When a 1 MB redo occurs,<\/li>\n
    • Every 3 seconds,<\/li>\n
    • When the online Redo Log file is switched<\/li>\n<\/ul>\n
      CKPT(The Checkpoint Process)<\/h3>\n
      CKPT is the process that performs Checkpoint. If the database is shut down for any reason, the instance will be recovered by SMON using Online Redo Log Files when opening the instance. This recovery process directly affects the recovery time of the database. The task of the Checkpoint process is to minimize this time.<\/span><\/p>\n
      In Oracle 8 and earlier, <\/span>Checkpoint was performed at regular intervals to ensure that the database can perform a quick recovery in case of instance failure.<\/span><\/p>\n
      The checkpoint process writes to the dirty buffer disk.<\/p>\n
      Thus, when the recovery process is performed after the crash, the process of writing the records in the redo log to the data files is minimized and the recovery time of the database becomes shorter.<\/p>\n
      This will open the database faster. The CKPT process triggers Checkpoint regularly.<\/p>\n
      After 8i, incremental checkpoint introduced. With the incremental checkpoint, the CKPT p<\/span>rocess instructs the DBW<\/span>n<\/span> to write a partial dirty buffer. <\/span>Thus, the interval between DBWn and LGWR is not allowed. Since the difference between DBWn and LGWR does not increase much, the recovery time is shortened. Therefore, the incremental checkpoint makes the recovery time shorter.<\/p>\n
      However, Incremental Checkpoint reduces performance. Because,<\/span> DBWn will write the dirty buffer more frequently to the disk.<\/span><\/p>\n
      With the incremental checkpoint, the current state of the checkpoint (the point at which recovery starts after the crash) is known as the redo byte address (RBA) and is stored in the control file. After each incremental checkpoint operation, this point in the control file is updated.<\/p>\n
      Full Checkpoint is only executed when the Checkpoint command is executed or when the database is properly shut down.<\/p>\n
      So, checkpoint process; checks and updates the headings of the data files. There are a number of disadvantages to whether checkpoint is frequent or rare;<\/p>\n
      Advantages or Disadvantages of Checkpoint Frequency<\/h4>\n
        \n
      • If checkpoints occur frequently, files on the physical disk will be updated frequently, causing database slowness.<\/li>\n
      • If checkpoint occurs rare, in case of a sudden shutdown, the database recovery time will be take longer.<\/li>\n<\/ul>\n
        MMON(The Manageability Monitor)<\/h3>\n
        The MMON process introduced with 10g for self-monitoring and tuning purposes.<\/p>\n
        M<\/span>any statistics about performance and activity are collected. These statistics are accumulated in the SGA. <\/span>The MMON process writes these statistics in the SGA to the Data Dictionary each time. So we can perform performance tuning and reporting using these statistics in Data Dictionary. By default, these statistical data are stored in the dictionary for 8 days.<\/p>\n
        MMON runs the Automatic Database Diagnostic Monitor (ADDM) to perform analysis and performance recommendations on this aggregate data.<\/p>\n
        MMON periodically checks the instance and database within the statistics collection period and reports if there is an alert.<\/p>\n
        These alerts can be configured by the DBA.<\/p>\n
        MMNL(The Manageability Monitor Light)<\/h3>\n
        MMNL is the assistant of MMON.<\/p>\n
        If the area used to aggregate statistics in the SGA expires before the MMON passes these statistics to the Data Dictionary, then MMNL will do this instead of MMON.<\/p>\n
        MMAN(The Memory Manager)<\/h3>\n
        The MMAN process instroduced with 10g. Its responsible for <\/span>Automatic Memory Management operations.<\/span><\/p>\n
        With 10g, it can automatically adjust the memory in the SGA.<\/p>\n
        With 11g, <\/span>it can automatically adjust the<\/span> memory for both SGA and PGA.<\/span><\/p>\n
        For the moment I think it would be useful to automatically manage the memory in the SGA, but I think the PGA should be set manually.<\/p>\n
        ARCn(The Archiver)<\/h3>\n
        It is a background process that is enable if the database is being used in archivelog mode.<\/p>\n
        Its responsible for copying redo log files to archive log files. This way LGWR can start to rewrite the redo log files.<\/p>\n
        If a standby database is used, it also manages the process of sending redo records from the primary database to the standby database.<\/p>\n
        The ARCn service should be properly monitored using the alert system. If archiving fails, the database will hang.<\/p>\n
        RECO(The Recoverer Process)<\/h3>\n
        Two phase commit occurs in Distributed Transaction.<\/p>\n
        So imagine that you update both a local table and a remote table in a transaction. In the first phase of the commit, the LGWR of each database flushes the redo log buffer to the redo log files. In the second phase, these transactions are marked as committed in the redo log files. If any of these processes fail, the RECO process rolls back the transaction in all databases. In this way, the consistency of the data is guaranteed.<\/p>\n
        Conclusion<\/h3>\n
        There are many background processes for many operations in Oracle, such as running jobs, managing deadlocks, and so on.<\/p>\n
        In this article I listed most important background processes from my point of view.<\/p>\n
        List Oracle Processes<\/h3>\n
        You can see other processes with the following query.<\/p>\n
        select program from v$process order by program;<\/pre>\n\n
        <\/div>\n
        <\/path><\/svg><\/i> \"Loading\"<\/p>\n
        <\/div>\n","protected":false},"excerpt":{"rendered":"
        The most important two components of Oracle Instance are SGA and Background Processes. Each Oracle Database process on the operating system is responsible for one task. Each process runs in harmony with the other process. Background Processes are actively running as long as the Oracle Instance is running. If you are working on unix and …<\/p>\n
        <\/div>\n
        <\/path><\/svg><\/i> \"Loading\"<\/p>\n
        <\/div>\n","protected":false},"author":1,"featured_media":14553,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[4],"tags":[1195,7224,1184,1187,1194,1193,1198,1197,1204,1076,1205,1185,7252,7262,7216,1203,1087,7225,1186,1189,1188,1190,1196,1192,1191,1179,1038,468,1206,1202,1182,1181,1183,1201,1200,1044,1036,1210,1208,1199,1207,1209,1180,7259,7250,7229,7241,7260,7238,7234,7253,7235,7236,7249,7256,7257,7237,7248,7240,7233,7226,7255,7232,7244,7251,7261,7242,7231,7243,7258,7227,7245,7254,7247,7246],"class_list":["post-1081","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-oracle","tag-addm","tag-advantages-or-disadvantages-of-checkpoint-frequency","tag-arcn","tag-arcnthe-archiver","tag-automatic-database-diagnostic-monitor","tag-automatic-database-diagnostic-monitoraddm","tag-ckpt","tag-ckptthe-checkpoint-process","tag-database-writer","tag-dbwn","tag-dbwndatabase-writer","tag-distributed-transaction","tag-how-many-lgwr-processes-are-there-in-oracle","tag-how-many-oracle-processes-are-running","tag-how-to-find-background-running-process-in-linux","tag-incremental-checkpoint","tag-lgwr","tag-list-oracle-processes","tag-marked-as-committed-in-the-redo-log","tag-mman","tag-mmanthe-memory-manager","tag-mmnl","tag-mmnlthe-manageability-monitor-light","tag-mmon","tag-mmonthe-manageability-monitor","tag-oracle-background-processes","tag-pga","tag-pmon","tag-pmonthe-process-monitor","tag-rba","tag-reco","tag-reco-process","tag-recothe-recoverer-process","tag-redo-byte-address","tag-redo-byte-addressrba","tag-redo-log-buffer","tag-sga","tag-smon","tag-smonthe-system-monitor","tag-the-checkpoint-process","tag-the-process-monitor","tag-the-system-monitor","tag-vprocess","tag-what-happens-when-checkpoint-occurs-in-oracle","tag-what-is-arch-process-in-oracle","tag-what-is-archivelog-mode-in-oracle","tag-what-is-arcn-in-oracle","tag-what-is-background-process-in-oracle","tag-what-is-checkpoint-in-oracle","tag-what-is-ckpt-in-oracle","tag-what-is-ckpt-process-in-oracle","tag-what-is-dbwn-in-oracle","tag-what-is-dbwr-in-oracle","tag-what-is-dbwr-process-in-oracle","tag-what-is-dirty-buffer-in-oracle","tag-what-is-instance-recovery-in-oracle","tag-what-is-lgwr-in-oracle","tag-what-is-lgwr-process-in-oracle","tag-what-is-mman-in-oracle","tag-what-is-mmon-in-oracle","tag-what-is-mmon-process-in-oracle","tag-what-is-mmon","tag-what-is-pmon-in-oracle","tag-what-is-pmon-process-in-oracle","tag-what-is-process-in-oracle-database","tag-what-is-server-process","tag-what-is-smon-in-oracle-database","tag-what-is-smon-in-oracle","tag-what-is-smon-process-in-oracle","tag-what-is-the-difference-between-pmon-and-smon","tag-what-is-the-difference-between-smon-and-pmon-processes","tag-what-is-the-job-of-smon-pmon-processes-in-oracle","tag-what-is-the-use-of-dbwr-in-oracle","tag-what-is-the-use-of-pmon-in-oracle","tag-what-is-the-use-of-smon-in-oracle"],"aioseo_notices":[],"a3_pvc":{"activated":true,"total_views":634,"today_views":1},"yoast_head":"\nOracle Background Processes - Database Tutorials<\/title>\n<meta name=\"description\" content=\"Oracle Background Processes\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/dbtut.com\/index.php\/2018\/07\/25\/oracle-background-processes\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Oracle Background Processes - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"Oracle Background Processes\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2018\/07\/25\/oracle-background-processes\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2018-07-25T20:02:46+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-01-02T08:37:19+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/07\/Ads\u0131z-5.png\" \/>\n\t<meta property=\"og:image:width\" content=\"555\" \/>\n\t<meta property=\"og:image:height\" content=\"339\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"dbtut\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"dbtut\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"11 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/07\/25\/oracle-background-processes\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/07\/25\/oracle-background-processes\/\"},\"author\":{\"name\":\"dbtut\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408\"},\"headline\":\"Oracle Background Processes\",\"datePublished\":\"2018-07-25T20:02:46+00:00\",\"dateModified\":\"2020-01-02T08:37:19+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/07\/25\/oracle-background-processes\/\"},\"wordCount\":1748,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/07\/25\/oracle-background-processes\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/07\/Ads\u0131z-5.png\",\"keywords\":[\"ADDM\",\"Advantages or Disadvantages of Checkpoint Frequency\",\"ARCn\",\"ARCn(The Archiver)\",\"Automatic Database Diagnostic Monitor\",\"Automatic Database Diagnostic Monitor(ADDM)\",\"CKPT\",\"CKPT(The Checkpoint Process)\",\"Database Writer\",\"DBWn\",\"DBWn(Database Writer)\",\"Distributed Transaction\",\"How many Lgwr processes are there in Oracle?\",\"How many Oracle processes are running?\",\"How To Find Background Running Process in Linux\",\"Incremental Checkpoint\",\"LGWR\",\"List Oracle Processes\",\"marked as committed in the redo log\",\"MMAN\",\"MMAN(The Memory Manager)\",\"MMNL\",\"MMNL(The Manageability Monitor Light)\",\"MMON\",\"MMON(The Manageability Monitor)\",\"Oracle Background Processes\",\"PGA\",\"pmon\",\"PMON(The Process Monitor)\",\"RBA\",\"RECO\",\"RECO process\",\"RECO(The Recoverer Process)\",\"redo byte address\",\"redo byte address(RBA)\",\"Redo log buffer\",\"SGA\",\"SMON\",\"SMON(The System Monitor)\",\"The Checkpoint Process\",\"The Process Monitor\",\"The System Monitor\",\"v$process\",\"What happens when checkpoint occurs in Oracle?\",\"what is arch process in oracle\",\"What is Archivelog mode in Oracle?\",\"What is ARCn in Oracle?\",\"What is background process in Oracle?\",\"What is checkpoint in Oracle?\",\"What is CKPT in Oracle?\",\"What is Ckpt process in Oracle?\",\"What is DBWn in Oracle?\",\"What is dbwr in Oracle?\",\"what is dbwr process in oracle\",\"What is dirty buffer in Oracle?\",\"What is instance recovery in Oracle?\",\"What is lgwr in Oracle?\",\"what is lgwr process in oracle\",\"What is MMAN in Oracle?\",\"What is MMON in Oracle?\",\"What is MMON process in Oracle?\",\"What is MMON?\",\"What is PMON in Oracle?\",\"what is pmon process in oracle\",\"What is process in Oracle database?\",\"What is server process?\",\"what is smon in oracle database\",\"What is SMON in Oracle?\",\"what is smon process in oracle\",\"What is the difference between Pmon and Smon?\",\"What is the difference between Smon and Pmon processes?\",\"what is the job of smon pmon processes in oracle\",\"What is the use of Dbwr in Oracle?\",\"what is the use of pmon in oracle\",\"what is the use of smon in oracle\"],\"articleSection\":[\"ORACLE\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2018\/07\/25\/oracle-background-processes\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/07\/25\/oracle-background-processes\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2018\/07\/25\/oracle-background-processes\/\",\"name\":\"Oracle Background Processes - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/07\/25\/oracle-background-processes\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/07\/25\/oracle-background-processes\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/07\/Ads\u0131z-5.png\",\"datePublished\":\"2018-07-25T20:02:46+00:00\",\"dateModified\":\"2020-01-02T08:37:19+00:00\",\"description\":\"Oracle Background Processes\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/07\/25\/oracle-background-processes\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2018\/07\/25\/oracle-background-processes\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/07\/25\/oracle-background-processes\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/07\/Ads\u0131z-5.png\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/07\/Ads\u0131z-5.png\",\"width\":555,\"height\":339},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/07\/25\/oracle-background-processes\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Oracle Background Processes\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/dbtut.com\/#website\",\"url\":\"https:\/\/dbtut.com\/\",\"name\":\"Database Tutorials\",\"description\":\"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux\",\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/dbtut.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/dbtut.com\/#organization\",\"name\":\"dbtut\",\"url\":\"https:\/\/dbtut.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"width\":223,\"height\":36,\"caption\":\"dbtut\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408\",\"name\":\"dbtut\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g\",\"caption\":\"dbtut\"},\"description\":\"We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.\",\"sameAs\":[\"http:\/\/NurullahCAKIR\"],\"url\":\"https:\/\/dbtut.com\/index.php\/author\/dbtut\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Oracle Background Processes - Database Tutorials","description":"Oracle Background Processes","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/dbtut.com\/index.php\/2018\/07\/25\/oracle-background-processes\/","og_locale":"en_US","og_type":"article","og_title":"Oracle Background Processes - Database Tutorials","og_description":"Oracle Background Processes","og_url":"https:\/\/dbtut.com\/index.php\/2018\/07\/25\/oracle-background-processes\/","og_site_name":"Database Tutorials","article_published_time":"2018-07-25T20:02:46+00:00","article_modified_time":"2020-01-02T08:37:19+00:00","og_image":[{"width":555,"height":339,"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/07\/Ads\u0131z-5.png","type":"image\/png"}],"author":"dbtut","twitter_card":"summary_large_image","twitter_misc":{"Written by":"dbtut","Est. reading time":"11 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2018\/07\/25\/oracle-background-processes\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/07\/25\/oracle-background-processes\/"},"author":{"name":"dbtut","@id":"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408"},"headline":"Oracle Background Processes","datePublished":"2018-07-25T20:02:46+00:00","dateModified":"2020-01-02T08:37:19+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/07\/25\/oracle-background-processes\/"},"wordCount":1748,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/07\/25\/oracle-background-processes\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/07\/Ads\u0131z-5.png","keywords":["ADDM","Advantages or Disadvantages of Checkpoint Frequency","ARCn","ARCn(The Archiver)","Automatic Database Diagnostic Monitor","Automatic Database Diagnostic Monitor(ADDM)","CKPT","CKPT(The Checkpoint Process)","Database Writer","DBWn","DBWn(Database Writer)","Distributed Transaction","How many Lgwr processes are there in Oracle?","How many Oracle processes are running?","How To Find Background Running Process in Linux","Incremental Checkpoint","LGWR","List Oracle Processes","marked as committed in the redo log","MMAN","MMAN(The Memory Manager)","MMNL","MMNL(The Manageability Monitor Light)","MMON","MMON(The Manageability Monitor)","Oracle Background Processes","PGA","pmon","PMON(The Process Monitor)","RBA","RECO","RECO process","RECO(The Recoverer Process)","redo byte address","redo byte address(RBA)","Redo log buffer","SGA","SMON","SMON(The System Monitor)","The Checkpoint Process","The Process Monitor","The System Monitor","v$process","What happens when checkpoint occurs in Oracle?","what is arch process in oracle","What is Archivelog mode in Oracle?","What is ARCn in Oracle?","What is background process in Oracle?","What is checkpoint in Oracle?","What is CKPT in Oracle?","What is Ckpt process in Oracle?","What is DBWn in Oracle?","What is dbwr in Oracle?","what is dbwr process in oracle","What is dirty buffer in Oracle?","What is instance recovery in Oracle?","What is lgwr in Oracle?","what is lgwr process in oracle","What is MMAN in Oracle?","What is MMON in Oracle?","What is MMON process in Oracle?","What is MMON?","What is PMON in Oracle?","what is pmon process in oracle","What is process in Oracle database?","What is server process?","what is smon in oracle database","What is SMON in Oracle?","what is smon process in oracle","What is the difference between Pmon and Smon?","What is the difference between Smon and Pmon processes?","what is the job of smon pmon processes in oracle","What is the use of Dbwr in Oracle?","what is the use of pmon in oracle","what is the use of smon in oracle"],"articleSection":["ORACLE"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2018\/07\/25\/oracle-background-processes\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2018\/07\/25\/oracle-background-processes\/","url":"https:\/\/dbtut.com\/index.php\/2018\/07\/25\/oracle-background-processes\/","name":"Oracle Background Processes - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/07\/25\/oracle-background-processes\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/07\/25\/oracle-background-processes\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/07\/Ads\u0131z-5.png","datePublished":"2018-07-25T20:02:46+00:00","dateModified":"2020-01-02T08:37:19+00:00","description":"Oracle Background Processes","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/07\/25\/oracle-background-processes\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2018\/07\/25\/oracle-background-processes\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2018\/07\/25\/oracle-background-processes\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/07\/Ads\u0131z-5.png","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/07\/Ads\u0131z-5.png","width":555,"height":339},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2018\/07\/25\/oracle-background-processes\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"Oracle Background Processes"}]},{"@type":"WebSite","@id":"https:\/\/dbtut.com\/#website","url":"https:\/\/dbtut.com\/","name":"Database Tutorials","description":"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux","publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/dbtut.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/dbtut.com\/#organization","name":"dbtut","url":"https:\/\/dbtut.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","width":223,"height":36,"caption":"dbtut"},"image":{"@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408","name":"dbtut","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g","caption":"dbtut"},"description":"We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.","sameAs":["http:\/\/NurullahCAKIR"],"url":"https:\/\/dbtut.com\/index.php\/author\/dbtut\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/1081","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/comments?post=1081"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/1081\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media\/14553"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=1081"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=1081"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=1081"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}