{"id":9920,"date":"2019-02-28T06:21:41","date_gmt":"2019-02-28T06:21:41","guid":{"rendered":"https:\/\/dbtut.com\/?p=9920"},"modified":"2019-02-28T06:25:27","modified_gmt":"2019-02-28T06:25:27","slug":"oracle-database-architecture-part-3","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2019\/02\/28\/oracle-database-architecture-part-3\/","title":{"rendered":"Oracle Database Architecture Part 3"},"content":{"rendered":"<p>I will continue to explain Oracle database architecture in this article. I\u2019m adding the following image to be memorable. If you didn\u2019t read the previous articles, I suggest you read these articles.<\/p>\n<p>\u201c<a href=\"https:\/\/dbtut.com\/index.php\/2019\/02\/27\/oracle-database-architecture-part-1\/\" target=\"_blank\" rel=\"noopener noreferrer\">Oracle Database Architecture Part 1<\/a>\u201d,<\/p>\n<p>\u201c<a href=\"https:\/\/dbtut.com\/index.php\/2019\/02\/27\/oracle-database-architecture-part-2\/\" target=\"_blank\" rel=\"noopener noreferrer\">Oracle Database Architecture Part 2<\/a>\u201d<\/p>\n<p id=\"eoWhAry\"><img loading=\"lazy\" decoding=\"async\" width=\"488\" height=\"410\" class=\"size-full wp-image-9921  aligncenter\" src=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/02\/img_5c7683709c6ac.png\" alt=\"\" \/><\/p>\n<p><strong>SMON (System Monitor):<\/strong> It is an important process responsible for recovering Oracle Instance. If this process does not work, the database is down.<\/p>\n<p>This process ensures that the instance to open consistently, during the database opening using the online redo log files when the Oracle database is closed inconsistently. This process also allows the recovery of suddenly killed transactions.<\/p>\n<p>We can see this process via the operating system as follows.<\/p>\n<pre class=\"\">bash-4.1$ ps -ef | grep smon\noracle\u00a0\u00a0\u00a0 9055\u00a0\u00a0\u00a0\u00a0 1\u00a0 0 13:38 ?\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 00:00:00 ora_smon_TESTDB\noracle\u00a0\u00a0\u00a0 9250\u00a0 8803\u00a0 0 14:24 pts\/0\u00a0\u00a0\u00a0 00:00:00 grep smon\nbash-4.1$<\/pre>\n<p>When we kill this process through the operating system, the database will shut down suddenly as follows.<\/p>\n<pre class=\"\">bash-4.1$ ps -ef | grep smon\noracle\u00a0\u00a0\u00a0 <em><strong>9055<\/strong><\/em>\u00a0\u00a0\u00a0\u00a0 1\u00a0 0 13:38 ?\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 00:00:00 ora_smon_TESTDB\noracle\u00a0\u00a0\u00a0 9258\u00a0 8803\u00a0 0 14:28 pts\/0\u00a0\u00a0\u00a0 00:00:00 grep smon\nbash-4.1$ kill -9 <em><strong>9055<\/strong><\/em>\nbash-4.1$ ps -ef | grep smon\noracle\u00a0\u00a0\u00a0 9260\u00a0 8803\u00a0 0 14:29 pts\/0\u00a0\u00a0\u00a0 00:00:00 grep smon\nbash-4.1$ sqlplus \/ as sysdba\nSQL*Plus: Release 11.2.0.3.0 Production on Fri Oct 4 14:29:08 2013\nCopyright (c) 1982, 2011, Oracle.\u00a0 All rights reserved.\n<em><strong>Connected to an idle instance.<\/strong><\/em>\nSQL&gt;<\/pre>\n<p><strong>PMON (Process Monitor):<\/strong> This process frees up system resources that are used by processes that have failed or are suddenly terminated, and will give back this resources to the server.<\/p>\n<p>It also allows Oracle instance to communicate with the listener.<\/p>\n<p>We can see this process on the operating system as follows.<\/p>\n<pre class=\"\">bash-4.1$ ps -ef | grep pmon\noracle\u00a0\u00a0\u00a0 9423\u00a0\u00a0\u00a0\u00a0 1\u00a0 0 14:37 ?\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 00:00:00 ora_pmon_TESTDB\noracle\u00a0\u00a0\u00a0 9559\u00a0 8803\u00a0 0 14:37 pts\/0\u00a0\u00a0\u00a0 00:00:00 grep pmon\nbash-4.1$<\/pre>\n<p><strong>RECO (Recoverer Process):<\/strong> This process enables the completion of unfinished operations.<\/p>\n<p><strong>DBWn (Database Writer):<\/strong> The DBW process is a process that shuttles between Datafiles and Database Buffer Cache. That is, when a transaction starts, if the corresponding blocks are not in the buffer cache, DBW move these blocks from the datafiles to the Buffer cache. In the same way, it writes the dirty blocks that should be written to the Datafiles to the Datafiles from the Buffer cache.<\/p>\n<pre class=\"\">bash-4.1$ sqlplus \/ as sysdba\nSQL*Plus: Release 11.2.0.3.0 Production on Fri Oct 4 13:39:44 2013\nCopyright (c) 1982, 2011, Oracle.\u00a0 All rights reserved. \nConnected to:\nOracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production\nWith the Partitioning, OLAP, Data Mining and Real Application Testing options\nSQL&gt; show parameter db_writer_process\n\nNAME\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 TYPE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 VALUE\n------------------------------------ ----------- ------------------------------\ndb_writer_processes\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 integer\u00a0\u00a0\u00a0\u00a0 1\nSQL&gt;<\/pre>\n<p>These processes work when the following events occur, and the changing blocks in Buffer Cache are written to the datafiles.<\/p>\n<ul>\n<li>When the memory space in the database buffer cache is full, these blocks are written to the datafiles starting from the oldest blocks in this memory area.<\/li>\n<li>If the Checkpoint process is triggered.<\/li>\n<li>When a tablespace is set to read-only mode.<\/li>\n<li>When a tablespace is taken offline.<\/li>\n<li>When any table is dropped or truncated.<\/li>\n<\/ul>\n<p>The following code can be used to manually write the data in the buffer cache to the datafiles.<\/p>\n<pre class=\"\">SQL&gt; Alter system checkpoint;<\/pre>\n<p><strong>LGWR (Log Writer Process):<\/strong> This process is a process that writes the data in the buffer memory to physical files like DBW process. This process runs between the Redo log buffer and the Online Redo log files. Writes transaction information in Redo log buffer to Online redo log files respectively. The LGWR process writes the data in the Redo log buffer to the Online Redo log files when the following conditions occur.<\/p>\n<ul>\n<li>When a commit operation occurs<\/li>\n<li>When a log switch occurs<\/li>\n<li>Every 3 seconds<\/li>\n<li>Average, when the redo log size is 1 mb.<\/li>\n<li>When 1\/3 of the Redo log buffer area is full<\/li>\n<\/ul>\n<p><strong>CKPT (Checkpoint Process):<\/strong> When this process is triggered, the Database Writer (DBW) process writes dirty blocks in the database buffer cache to datafiles. It also updates the header information of Datafiles.<\/p>\n<p>If this process is triggered at very frequent intervals, the database will slow down because disk I \/ O will increase.<\/p>\n<p>If it is rarely triggered, it will take some time to recover instance when the Oracle database instance crashes suddenly. Because changing blocks are not written to datafiles and the number of changing blocks is accumulated. Therefore, during the recovery process, the number of blocks to be written from the online redo log to the data files will be more.<\/p>\n<p>Determining the frequency of triggering of this process is important for the above reasons.<\/p>\n<p><strong>ARCn ( archiver process ):<\/strong> This is a process that is activated when the database is in archive mode. This process copies a copy of the redo log file to the archive file during the log switch operation when the online redo log groups are full. Another task of this process is send Redo log files to the &#8220;disaster\/standby&#8221; server in the disaster recovery scenario.<\/p>\n<p>So, I am completing the article series of the Oracle database architecture with this article.<\/p>\n\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_9920\" class=\"pvc_stats all  \" data-element-id=\"9920\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/dbtut.com\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"excerpt":{"rendered":"<p>I will continue to explain Oracle database architecture in this article. I\u2019m adding the following image to be memorable. If you didn\u2019t read the previous articles, I suggest you read these articles. \u201cOracle Database Architecture Part 1\u201d, \u201cOracle Database Architecture Part 2\u201d SMON (System Monitor): It is an important process responsible for recovering Oracle Instance. &hellip;<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_9920\" class=\"pvc_stats all  \" data-element-id=\"9920\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/dbtut.com\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"author":472,"featured_media":0,"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":[2229,1184,2230,1198,1204,1076,1087,2231,1179,2232,468,2234,1182,1181,2233,1210,2235],"class_list":["post-9920","post","type-post","status-publish","format-standard","","category-oracle","tag-archiver-process","tag-arcn","tag-checkpoint-process","tag-ckpt","tag-database-writer","tag-dbwn","tag-lgwr","tag-log-writer-process","tag-oracle-background-processes","tag-oracle-checkpoint","tag-pmon","tag-process-monitor","tag-reco","tag-reco-process","tag-recoverer-process","tag-smon","tag-system-monitor"],"aioseo_notices":[],"a3_pvc":{"activated":true,"total_views":217,"today_views":1},"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Oracle Database Architecture Part 3 - Database Tutorials<\/title>\n<meta name=\"description\" content=\"Oracle Database Architecture Part 3\" \/>\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\/2019\/02\/28\/oracle-database-architecture-part-3\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Oracle Database Architecture Part 3 - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"Oracle Database Architecture Part 3\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2019\/02\/28\/oracle-database-architecture-part-3\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2019-02-28T06:21:41+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-02-28T06:25:27+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/02\/img_5c7683709c6ac.png\" \/>\n<meta name=\"author\" content=\"Mehmet Salih DEVEC\u0130\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Mehmet Salih DEVEC\u0130\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/02\/28\/oracle-database-architecture-part-3\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/02\/28\/oracle-database-architecture-part-3\/\"},\"author\":{\"name\":\"Mehmet Salih DEVEC\u0130\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/bbdc56d959b34d47d81999c7af91a2fa\"},\"headline\":\"Oracle Database Architecture Part 3\",\"datePublished\":\"2019-02-28T06:21:41+00:00\",\"dateModified\":\"2019-02-28T06:25:27+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/02\/28\/oracle-database-architecture-part-3\/\"},\"wordCount\":662,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/02\/28\/oracle-database-architecture-part-3\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/02\/img_5c7683709c6ac.png\",\"keywords\":[\"archiver process\",\"ARCn\",\"Checkpoint Process\",\"CKPT\",\"Database Writer\",\"DBWn\",\"LGWR\",\"Log Writer Process\",\"Oracle Background Processes\",\"Oracle Checkpoint\",\"pmon\",\"Process Monitor\",\"RECO\",\"RECO process\",\"Recoverer Process\",\"SMON\",\"System Monitor\"],\"articleSection\":[\"ORACLE\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2019\/02\/28\/oracle-database-architecture-part-3\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/02\/28\/oracle-database-architecture-part-3\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2019\/02\/28\/oracle-database-architecture-part-3\/\",\"name\":\"Oracle Database Architecture Part 3 - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/02\/28\/oracle-database-architecture-part-3\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/02\/28\/oracle-database-architecture-part-3\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/02\/img_5c7683709c6ac.png\",\"datePublished\":\"2019-02-28T06:21:41+00:00\",\"dateModified\":\"2019-02-28T06:25:27+00:00\",\"description\":\"Oracle Database Architecture Part 3\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/02\/28\/oracle-database-architecture-part-3\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2019\/02\/28\/oracle-database-architecture-part-3\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/02\/28\/oracle-database-architecture-part-3\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/02\/img_5c7683709c6ac.png\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/02\/img_5c7683709c6ac.png\",\"width\":488,\"height\":410},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/02\/28\/oracle-database-architecture-part-3\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Oracle Database Architecture Part 3\"}]},{\"@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\/bbdc56d959b34d47d81999c7af91a2fa\",\"name\":\"Mehmet Salih DEVEC\u0130\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/adcbb5bfb748dc6f31a1196c490f93fdbc20e6584b62d850570545f39c910c41?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/adcbb5bfb748dc6f31a1196c490f93fdbc20e6584b62d850570545f39c910c41?s=96&d=mm&r=g\",\"caption\":\"Mehmet Salih DEVEC\u0130\"},\"url\":\"https:\/\/dbtut.com\/index.php\/author\/salihdeveci\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Oracle Database Architecture Part 3 - Database Tutorials","description":"Oracle Database Architecture Part 3","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\/2019\/02\/28\/oracle-database-architecture-part-3\/","og_locale":"en_US","og_type":"article","og_title":"Oracle Database Architecture Part 3 - Database Tutorials","og_description":"Oracle Database Architecture Part 3","og_url":"https:\/\/dbtut.com\/index.php\/2019\/02\/28\/oracle-database-architecture-part-3\/","og_site_name":"Database Tutorials","article_published_time":"2019-02-28T06:21:41+00:00","article_modified_time":"2019-02-28T06:25:27+00:00","og_image":[{"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/02\/img_5c7683709c6ac.png","type":"","width":"","height":""}],"author":"Mehmet Salih DEVEC\u0130","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Mehmet Salih DEVEC\u0130","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2019\/02\/28\/oracle-database-architecture-part-3\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/02\/28\/oracle-database-architecture-part-3\/"},"author":{"name":"Mehmet Salih DEVEC\u0130","@id":"https:\/\/dbtut.com\/#\/schema\/person\/bbdc56d959b34d47d81999c7af91a2fa"},"headline":"Oracle Database Architecture Part 3","datePublished":"2019-02-28T06:21:41+00:00","dateModified":"2019-02-28T06:25:27+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/02\/28\/oracle-database-architecture-part-3\/"},"wordCount":662,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/02\/28\/oracle-database-architecture-part-3\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/02\/img_5c7683709c6ac.png","keywords":["archiver process","ARCn","Checkpoint Process","CKPT","Database Writer","DBWn","LGWR","Log Writer Process","Oracle Background Processes","Oracle Checkpoint","pmon","Process Monitor","RECO","RECO process","Recoverer Process","SMON","System Monitor"],"articleSection":["ORACLE"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2019\/02\/28\/oracle-database-architecture-part-3\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2019\/02\/28\/oracle-database-architecture-part-3\/","url":"https:\/\/dbtut.com\/index.php\/2019\/02\/28\/oracle-database-architecture-part-3\/","name":"Oracle Database Architecture Part 3 - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/02\/28\/oracle-database-architecture-part-3\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/02\/28\/oracle-database-architecture-part-3\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/02\/img_5c7683709c6ac.png","datePublished":"2019-02-28T06:21:41+00:00","dateModified":"2019-02-28T06:25:27+00:00","description":"Oracle Database Architecture Part 3","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/02\/28\/oracle-database-architecture-part-3\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2019\/02\/28\/oracle-database-architecture-part-3\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2019\/02\/28\/oracle-database-architecture-part-3\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/02\/img_5c7683709c6ac.png","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/02\/img_5c7683709c6ac.png","width":488,"height":410},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2019\/02\/28\/oracle-database-architecture-part-3\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"Oracle Database Architecture Part 3"}]},{"@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\/bbdc56d959b34d47d81999c7af91a2fa","name":"Mehmet Salih DEVEC\u0130","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/adcbb5bfb748dc6f31a1196c490f93fdbc20e6584b62d850570545f39c910c41?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/adcbb5bfb748dc6f31a1196c490f93fdbc20e6584b62d850570545f39c910c41?s=96&d=mm&r=g","caption":"Mehmet Salih DEVEC\u0130"},"url":"https:\/\/dbtut.com\/index.php\/author\/salihdeveci\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/9920","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\/472"}],"replies":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/comments?post=9920"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/9920\/revisions"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=9920"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=9920"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=9920"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}