{"id":9916,"date":"2019-02-27T12:24:07","date_gmt":"2019-02-27T12:24:07","guid":{"rendered":"https:\/\/dbtut.com\/?p=9916"},"modified":"2019-02-28T06:24:05","modified_gmt":"2019-02-28T06:24:05","slug":"oracle-database-architecture-part-2","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2019\/02\/27\/oracle-database-architecture-part-2\/","title":{"rendered":"Oracle Database Architecture Part 2"},"content":{"rendered":"

I will continue to explain Oracle database architecture in this article. I’m adding the following image to be memorable. If you didn’t read the first article, I suggest you read the first article.<\/p>\n

“Oracle Database Architecture Part 1<\/a>”<\/p>\n

\"\"<\/p>\n

Database Buffer Cache:<\/strong> Data of a transaction that started by a user or application is stored in this memory space.<\/p>\n

For example:<\/strong> When an insert, update, or delete operation is performed on a table, the corresponding change is not written directly to the datafiles. It is stored in the buffer cache for a while(This data called as dirty data).<\/p>\n

The most frequently used and most up-to-date data in the database is stored in here, and this memory space is common to all users. Data stored in the Buffer cache are written to the data files after a while.<\/p>\n

You can flush the data in the Buffer Cache with the following query:<\/strong><\/p>\n

alter system flush buffer_cache;<\/pre>\n
However, you should not execute the above command in production systems unless required. Because when the buffer cache is emptied, all queries or transactions will make I \/ O from the physical disk, which means that our queries will slow down.<\/p>\n
Redo Log Buffer:<\/strong> The Oracle database stores each transaction’s record. When a user or an application initiates a transaction, the transaction is initially written to the Redo log buffer. Periodically, records in the Redo log buffer area are written to the Online Redo log files by the LGWR process. Storing records of transactions is required for recovery when the instance crashes.<\/p>\n
Online Redo log Files:<\/strong> These files are physical files on the operating system where all transactions in the database are stored. These files store all changes in the database, and as I mentioned above, the records accumulated in the Redo log buffer area are recorded here at regular intervals. If the database is in Archive mode, these files are archived periodically as a result of a switch operation.<\/p>\n
The database must be in archive mode in order to make a backup in online mode. If there is a damage to the database, archive files will also be required when returning from the backup.<\/p>\n
You cannot open the database consistently without applying Archive Logs. Once the corresponding archive logs have been applied, online redo logs can be applied to recover the data until the last time.<\/p>\n
\"\"<\/p>\n
There are logical Redo log groups on the database where the Redo log files are stored, and each group has 2 identical files. This is necessary for redundancy and consistency. When a file is corrupted, database continue to work using other member of the redo log group. You can also create more than 2 members for a redo log group. The information in the Redo log buffer is written to all the members of the redo log group at the same time. If any of the online Redo log groups are fully filled, the new logs will be written to another group. This process is called a log switch.<\/p>\n
You can see the online redo logs on the database with the following query:<\/strong><\/p>\n
bash-4.1$ sqlplus \/ as sysdba\nSQL*Plus: Release 11.2.0.3.0 Production on Thu Oct 3 16:54:27 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\n\nSQL> set lines 600\nSQL> select * from v$log;\n\n\u00a0\u00a0\u00a0 GROUP#\u00a0\u00a0\u00a0 THREAD#\u00a0 SEQUENCE#\u00a0\u00a0\u00a0\u00a0\u00a0 BYTES\u00a0 BLOCKSIZE\u00a0\u00a0\u00a0 MEMBERS ARC STATUS\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 FIRST_CHANGE# FIRST_TIM NEXT_CHANGE# NEXT_TIME\n---------- ---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- --------- ------------ ---------\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1\u00a0\u00a0\u00a0\u00a0\u00a0 18622\u00a0\u00a0 52428800\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 512\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1 YES ACTIVE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 12514027 03-JAN-13\u00a0\u00a0\u00a0\u00a0 12514404 03-OCT-13\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1\u00a0\u00a0\u00a0\u00a0\u00a0 18623\u00a0\u00a0 52428800\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 512\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1 NO\u00a0 CURRENT\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 12514404 03- JAN -13\u00a0\u00a0 2.8147E+14\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 3\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1\u00a0\u00a0\u00a0\u00a0\u00a0 18621\u00a0\u00a0 52428800\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 512\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1 YES INACTIVE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a012513648 03- JAN -13\u00a0\u00a0\u00a0\u00a0 12514027 03-OCT-13<\/pre>\n
If you have a Oracle database that is running in archive log mode, redo log files are copied to archive log files after log switch.<\/p>\n
Archive files are files that are required to recover instance consistently. In addition, you can recover your database to a specific time using archive log files.<\/p>\n
You can check archive log files with the following query:<\/strong><\/p>\n
bash-4.1$ sqlplus \/ as sysdba\nSQL*Plus: Release 11.2.0.3.0 Production on Thu Oct 3 17:12:20 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\n\nSQL> set lines 900\nSQL> select NAME,DEST_ID,THREAD#,SEQUENCE#,CREATOR,APPLIED from v$archived_log where rownum<3;\n\nNAME\u00a0\u00a0\u00a0\u00a0 DEST_ID\u00a0\u00a0\u00a0 THREAD#\u00a0 SEQUENCE# CREATOR APPLIED\n--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------- ---------- ---------- ------- ---------\n\/oracle\/ARCH\/1_15266_821030721.arc\u00a0\u00a0 1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1\u00a0\u00a0\u00a0\u00a0\u00a0 15266 ARCH\u00a0\u00a0\u00a0 NO\n\/oracle\/ARCH\/1_15267_821030721.arc\u00a0\u00a0 1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1\u00a0\u00a0\u00a0\u00a0\u00a0 15267 ARCH\u00a0\u00a0\u00a0 NO\n\nSQL><\/pre>\n
You can find the last article of this article series below.<\/p>\n
“Oracle Database Architecture Part 3<\/a>”<\/p>\n\n
<\/div>\n
<\/path><\/svg><\/i> \"Loading\"<\/p>\n
<\/div>\n","protected":false},"excerpt":{"rendered":"
I will continue to explain Oracle database architecture in this article. I’m adding the following image to be memorable. If you didn’t read the first article, I suggest you read the first article. “Oracle Database Architecture Part 1” Database Buffer Cache: Data of a transaction that started by a user or application is stored in …<\/p>\n
<\/div>\n
<\/path><\/svg><\/i> \"Loading\"<\/p>\n
<\/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":[2228,2223,2224,1043,2219,2217,2218,2221,1087,1213,2225,2220,2202,2227,2226,1090,1044,2222,1214],"class_list":["post-9916","post","type-post","status-publish","format-standard","","category-oracle","tag-archive-log-files","tag-archive-logs","tag-archive-mode","tag-database-buffer-cache","tag-empty-buffer-cache","tag-flush-buffer","tag-flush-buffer-cache","tag-flush-buffer_cache","tag-lgwr","tag-log-switch","tag-online-backup","tag-online-redo-log-files","tag-oracle-database-architecture","tag-query-archive-logs","tag-query-redo-logs","tag-redo-log","tag-redo-log-buffer","tag-redo-log-files","tag-redo-log-switch"],"aioseo_notices":[],"a3_pvc":{"activated":true,"total_views":219,"today_views":0},"yoast_head":"\nOracle Database Architecture Part 2 - Database Tutorials<\/title>\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\/27\/oracle-database-architecture-part-2\/\" \/>\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 2 - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"I will continue to explain Oracle database architecture in this article. I’m adding the following image to be memorable. If you didn’t read the first article, I suggest you read the first article. “Oracle Database Architecture Part 1” Database Buffer Cache: Data of a transaction that started by a user or application is stored in …\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2019\/02\/27\/oracle-database-architecture-part-2\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2019-02-27T12:24:07+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-02-28T06:24:05+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/02\/img_5c766c47ae8d0.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\/27\/oracle-database-architecture-part-2\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/02\/27\/oracle-database-architecture-part-2\/\"},\"author\":{\"name\":\"Mehmet Salih DEVEC\u0130\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/bbdc56d959b34d47d81999c7af91a2fa\"},\"headline\":\"Oracle Database Architecture Part 2\",\"datePublished\":\"2019-02-27T12:24:07+00:00\",\"dateModified\":\"2019-02-28T06:24:05+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/02\/27\/oracle-database-architecture-part-2\/\"},\"wordCount\":589,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/02\/27\/oracle-database-architecture-part-2\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/02\/img_5c766c47ae8d0.png\",\"keywords\":[\"archive log files\",\"Archive Logs\",\"archive mode\",\"Database buffer cache\",\"empty buffer cache\",\"flush buffer\",\"flush buffer cache\",\"flush buffer_cache\",\"LGWR\",\"log switch\",\"online backup\",\"Online Redo log Files\",\"Oracle Database Architecture\",\"query archive logs\",\"query redo logs\",\"redo log\",\"Redo log buffer\",\"Redo log Files\",\"redo log switch\"],\"articleSection\":[\"ORACLE\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2019\/02\/27\/oracle-database-architecture-part-2\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/02\/27\/oracle-database-architecture-part-2\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2019\/02\/27\/oracle-database-architecture-part-2\/\",\"name\":\"Oracle Database Architecture Part 2 - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/02\/27\/oracle-database-architecture-part-2\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/02\/27\/oracle-database-architecture-part-2\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/02\/img_5c766c47ae8d0.png\",\"datePublished\":\"2019-02-27T12:24:07+00:00\",\"dateModified\":\"2019-02-28T06:24:05+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/02\/27\/oracle-database-architecture-part-2\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2019\/02\/27\/oracle-database-architecture-part-2\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/02\/27\/oracle-database-architecture-part-2\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/02\/img_5c766c47ae8d0.png\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/02\/img_5c766c47ae8d0.png\",\"width\":471,\"height\":381},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/02\/27\/oracle-database-architecture-part-2\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Oracle Database Architecture Part 2\"}]},{\"@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 2 - Database Tutorials","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\/27\/oracle-database-architecture-part-2\/","og_locale":"en_US","og_type":"article","og_title":"Oracle Database Architecture Part 2 - Database Tutorials","og_description":"I will continue to explain Oracle database architecture in this article. I’m adding the following image to be memorable. If you didn’t read the first article, I suggest you read the first article. “Oracle Database Architecture Part 1” Database Buffer Cache: Data of a transaction that started by a user or application is stored in …","og_url":"https:\/\/dbtut.com\/index.php\/2019\/02\/27\/oracle-database-architecture-part-2\/","og_site_name":"Database Tutorials","article_published_time":"2019-02-27T12:24:07+00:00","article_modified_time":"2019-02-28T06:24:05+00:00","og_image":[{"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/02\/img_5c766c47ae8d0.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\/27\/oracle-database-architecture-part-2\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/02\/27\/oracle-database-architecture-part-2\/"},"author":{"name":"Mehmet Salih DEVEC\u0130","@id":"https:\/\/dbtut.com\/#\/schema\/person\/bbdc56d959b34d47d81999c7af91a2fa"},"headline":"Oracle Database Architecture Part 2","datePublished":"2019-02-27T12:24:07+00:00","dateModified":"2019-02-28T06:24:05+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/02\/27\/oracle-database-architecture-part-2\/"},"wordCount":589,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/02\/27\/oracle-database-architecture-part-2\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/02\/img_5c766c47ae8d0.png","keywords":["archive log files","Archive Logs","archive mode","Database buffer cache","empty buffer cache","flush buffer","flush buffer cache","flush buffer_cache","LGWR","log switch","online backup","Online Redo log Files","Oracle Database Architecture","query archive logs","query redo logs","redo log","Redo log buffer","Redo log Files","redo log switch"],"articleSection":["ORACLE"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2019\/02\/27\/oracle-database-architecture-part-2\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2019\/02\/27\/oracle-database-architecture-part-2\/","url":"https:\/\/dbtut.com\/index.php\/2019\/02\/27\/oracle-database-architecture-part-2\/","name":"Oracle Database Architecture Part 2 - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/02\/27\/oracle-database-architecture-part-2\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/02\/27\/oracle-database-architecture-part-2\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/02\/img_5c766c47ae8d0.png","datePublished":"2019-02-27T12:24:07+00:00","dateModified":"2019-02-28T06:24:05+00:00","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/02\/27\/oracle-database-architecture-part-2\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2019\/02\/27\/oracle-database-architecture-part-2\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2019\/02\/27\/oracle-database-architecture-part-2\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/02\/img_5c766c47ae8d0.png","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/02\/img_5c766c47ae8d0.png","width":471,"height":381},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2019\/02\/27\/oracle-database-architecture-part-2\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"Oracle Database Architecture Part 2"}]},{"@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\/9916","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=9916"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/9916\/revisions"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=9916"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=9916"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=9916"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}