{"id":33,"date":"2009-06-17T22:19:51","date_gmt":"2009-06-17T22:19:51","guid":{"rendered":"http:\/\/oracle-internals.com\/blog\/?p=33"},"modified":"2014-01-26T22:20:20","modified_gmt":"2014-01-26T22:20:20","slug":"distributed-oracle-buffer-cache","status":"publish","type":"post","link":"http:\/\/oracle-internals.com\/blog\/2009\/06\/17\/distributed-oracle-buffer-cache\/","title":{"rendered":"Distributed Oracle Buffer Cache"},"content":{"rendered":"<p>If you\u2019ve read\u00a0<a href=\"https:\/\/web.archive.org\/web\/20110919001537\/http:\/\/www.enterprisedb.com\/company\/news_events\/press_releases\/2009_14.do\">EnterpriseDB\u2019s latest press release<\/a>, you\u2019ll notice a new feature called\u00a0<a href=\"https:\/\/web.archive.org\/web\/20110919001537\/http:\/\/www.enterprisedb.com\/docs\/en\/8.3R2\/perf\/Performance_Guide-02.htm#P26_2527\">Infinite Cache<\/a>.\u00a0 While it may sound revolutionary, it is not a new technology.\u00a0 In fact, it was done for MySQL quite awhile ago under the\u00a0<a href=\"https:\/\/web.archive.org\/web\/20110919001537\/http:\/\/www.wafflegrid.com\/\">Waffle Grid<\/a>\u00a0project.<\/p>\n<p>While I consider this type of caching relatively simple, I don\u2019t want Oracle to be left out.\u00a0 As such, I\u2019m going to join the fray by throwing my own project,\u00a0, into the mix.<\/p>\n<p>Similar to Waffle Grid for MySQL and Infinite Cache for EnterpriseDB, Mercury supplements the Oracle buffer cache with optimized, network-based data block storage to reduce the amount of read-related disk I\/O which must be performed when working with large-scale databases.<\/p>\n<p>For the time being, please forward all Mercury-related questions directly to me via email.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>If you\u2019ve read\u00a0EnterpriseDB\u2019s latest press release, you\u2019ll notice a new feature called\u00a0Infinite Cache.\u00a0 While it may sound revolutionary, it is not a new technology.\u00a0 In fact, it was done for MySQL quite awhile ago under the\u00a0Waffle Grid\u00a0project. While I consider this type of caching relatively simple, I don\u2019t want Oracle to be left out.\u00a0 As [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.8 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Distributed Oracle Buffer Cache - Oracle Internals<\/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:\/\/oracle-internals.com\/blog\/2009\/06\/17\/distributed-oracle-buffer-cache\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Distributed Oracle Buffer Cache - Oracle Internals\" \/>\n<meta property=\"og:description\" content=\"If you\u2019ve read\u00a0EnterpriseDB\u2019s latest press release, you\u2019ll notice a new feature called\u00a0Infinite Cache.\u00a0 While it may sound revolutionary, it is not a new technology.\u00a0 In fact, it was done for MySQL quite awhile ago under the\u00a0Waffle Grid\u00a0project. While I consider this type of caching relatively simple, I don\u2019t want Oracle to be left out.\u00a0 As [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/oracle-internals.com\/blog\/2009\/06\/17\/distributed-oracle-buffer-cache\/\" \/>\n<meta property=\"og:site_name\" content=\"Oracle Internals\" \/>\n<meta property=\"article:published_time\" content=\"2009-06-17T22:19:51+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2014-01-26T22:20:20+00:00\" \/>\n<meta name=\"author\" content=\"Jonah Harris\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@jonahharris\" \/>\n<meta name=\"twitter:site\" content=\"@jonahharris\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Jonah Harris\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/oracle-internals.com\/blog\/2009\/06\/17\/distributed-oracle-buffer-cache\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/oracle-internals.com\/blog\/2009\/06\/17\/distributed-oracle-buffer-cache\/\"},\"author\":{\"name\":\"Jonah Harris\",\"@id\":\"http:\/\/oracle-internals.com\/blog\/#\/schema\/person\/549d9c522c3960b062618b600bb762a4\"},\"headline\":\"Distributed Oracle Buffer Cache\",\"datePublished\":\"2009-06-17T22:19:51+00:00\",\"dateModified\":\"2014-01-26T22:20:20+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/oracle-internals.com\/blog\/2009\/06\/17\/distributed-oracle-buffer-cache\/\"},\"wordCount\":138,\"commentCount\":0,\"publisher\":{\"@id\":\"http:\/\/oracle-internals.com\/blog\/#\/schema\/person\/549d9c522c3960b062618b600bb762a4\"},\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/oracle-internals.com\/blog\/2009\/06\/17\/distributed-oracle-buffer-cache\/\",\"url\":\"https:\/\/oracle-internals.com\/blog\/2009\/06\/17\/distributed-oracle-buffer-cache\/\",\"name\":\"Distributed Oracle Buffer Cache - Oracle Internals\",\"isPartOf\":{\"@id\":\"http:\/\/oracle-internals.com\/blog\/#website\"},\"datePublished\":\"2009-06-17T22:19:51+00:00\",\"dateModified\":\"2014-01-26T22:20:20+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/oracle-internals.com\/blog\/2009\/06\/17\/distributed-oracle-buffer-cache\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/oracle-internals.com\/blog\/2009\/06\/17\/distributed-oracle-buffer-cache\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/oracle-internals.com\/blog\/2009\/06\/17\/distributed-oracle-buffer-cache\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"http:\/\/oracle-internals.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Distributed Oracle Buffer Cache\"}]},{\"@type\":\"WebSite\",\"@id\":\"http:\/\/oracle-internals.com\/blog\/#website\",\"url\":\"http:\/\/oracle-internals.com\/blog\/\",\"name\":\"Oracle Internals\",\"description\":\"Researching the Inner Workings of the World&#039;s Most Powerful Database\",\"publisher\":{\"@id\":\"http:\/\/oracle-internals.com\/blog\/#\/schema\/person\/549d9c522c3960b062618b600bb762a4\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"http:\/\/oracle-internals.com\/blog\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"http:\/\/oracle-internals.com\/blog\/#\/schema\/person\/549d9c522c3960b062618b600bb762a4\",\"name\":\"Jonah Harris\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"http:\/\/oracle-internals.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"http:\/\/1.gravatar.com\/avatar\/a6d16ed0f510e8de0929f129471dc1e5?s=96&d=mm&r=g\",\"contentUrl\":\"http:\/\/1.gravatar.com\/avatar\/a6d16ed0f510e8de0929f129471dc1e5?s=96&d=mm&r=g\",\"caption\":\"Jonah Harris\"},\"logo\":{\"@id\":\"http:\/\/oracle-internals.com\/blog\/#\/schema\/person\/image\/\"},\"sameAs\":[\"https:\/\/www.linkedin.com\/in\/jonahharris\/\",\"https:\/\/x.com\/jonahharris\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Distributed Oracle Buffer Cache - Oracle Internals","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:\/\/oracle-internals.com\/blog\/2009\/06\/17\/distributed-oracle-buffer-cache\/","og_locale":"en_US","og_type":"article","og_title":"Distributed Oracle Buffer Cache - Oracle Internals","og_description":"If you\u2019ve read\u00a0EnterpriseDB\u2019s latest press release, you\u2019ll notice a new feature called\u00a0Infinite Cache.\u00a0 While it may sound revolutionary, it is not a new technology.\u00a0 In fact, it was done for MySQL quite awhile ago under the\u00a0Waffle Grid\u00a0project. While I consider this type of caching relatively simple, I don\u2019t want Oracle to be left out.\u00a0 As [&hellip;]","og_url":"https:\/\/oracle-internals.com\/blog\/2009\/06\/17\/distributed-oracle-buffer-cache\/","og_site_name":"Oracle Internals","article_published_time":"2009-06-17T22:19:51+00:00","article_modified_time":"2014-01-26T22:20:20+00:00","author":"Jonah Harris","twitter_card":"summary_large_image","twitter_creator":"@jonahharris","twitter_site":"@jonahharris","twitter_misc":{"Written by":"Jonah Harris","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/oracle-internals.com\/blog\/2009\/06\/17\/distributed-oracle-buffer-cache\/#article","isPartOf":{"@id":"https:\/\/oracle-internals.com\/blog\/2009\/06\/17\/distributed-oracle-buffer-cache\/"},"author":{"name":"Jonah Harris","@id":"http:\/\/oracle-internals.com\/blog\/#\/schema\/person\/549d9c522c3960b062618b600bb762a4"},"headline":"Distributed Oracle Buffer Cache","datePublished":"2009-06-17T22:19:51+00:00","dateModified":"2014-01-26T22:20:20+00:00","mainEntityOfPage":{"@id":"https:\/\/oracle-internals.com\/blog\/2009\/06\/17\/distributed-oracle-buffer-cache\/"},"wordCount":138,"commentCount":0,"publisher":{"@id":"http:\/\/oracle-internals.com\/blog\/#\/schema\/person\/549d9c522c3960b062618b600bb762a4"},"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/oracle-internals.com\/blog\/2009\/06\/17\/distributed-oracle-buffer-cache\/","url":"https:\/\/oracle-internals.com\/blog\/2009\/06\/17\/distributed-oracle-buffer-cache\/","name":"Distributed Oracle Buffer Cache - Oracle Internals","isPartOf":{"@id":"http:\/\/oracle-internals.com\/blog\/#website"},"datePublished":"2009-06-17T22:19:51+00:00","dateModified":"2014-01-26T22:20:20+00:00","breadcrumb":{"@id":"https:\/\/oracle-internals.com\/blog\/2009\/06\/17\/distributed-oracle-buffer-cache\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/oracle-internals.com\/blog\/2009\/06\/17\/distributed-oracle-buffer-cache\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/oracle-internals.com\/blog\/2009\/06\/17\/distributed-oracle-buffer-cache\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"http:\/\/oracle-internals.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Distributed Oracle Buffer Cache"}]},{"@type":"WebSite","@id":"http:\/\/oracle-internals.com\/blog\/#website","url":"http:\/\/oracle-internals.com\/blog\/","name":"Oracle Internals","description":"Researching the Inner Workings of the World&#039;s Most Powerful Database","publisher":{"@id":"http:\/\/oracle-internals.com\/blog\/#\/schema\/person\/549d9c522c3960b062618b600bb762a4"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"http:\/\/oracle-internals.com\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"http:\/\/oracle-internals.com\/blog\/#\/schema\/person\/549d9c522c3960b062618b600bb762a4","name":"Jonah Harris","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"http:\/\/oracle-internals.com\/blog\/#\/schema\/person\/image\/","url":"http:\/\/1.gravatar.com\/avatar\/a6d16ed0f510e8de0929f129471dc1e5?s=96&d=mm&r=g","contentUrl":"http:\/\/1.gravatar.com\/avatar\/a6d16ed0f510e8de0929f129471dc1e5?s=96&d=mm&r=g","caption":"Jonah Harris"},"logo":{"@id":"http:\/\/oracle-internals.com\/blog\/#\/schema\/person\/image\/"},"sameAs":["https:\/\/www.linkedin.com\/in\/jonahharris\/","https:\/\/x.com\/jonahharris"]}]}},"_links":{"self":[{"href":"http:\/\/oracle-internals.com\/blog\/wp-json\/wp\/v2\/posts\/33"}],"collection":[{"href":"http:\/\/oracle-internals.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/oracle-internals.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/oracle-internals.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/oracle-internals.com\/blog\/wp-json\/wp\/v2\/comments?post=33"}],"version-history":[{"count":1,"href":"http:\/\/oracle-internals.com\/blog\/wp-json\/wp\/v2\/posts\/33\/revisions"}],"predecessor-version":[{"id":34,"href":"http:\/\/oracle-internals.com\/blog\/wp-json\/wp\/v2\/posts\/33\/revisions\/34"}],"wp:attachment":[{"href":"http:\/\/oracle-internals.com\/blog\/wp-json\/wp\/v2\/media?parent=33"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/oracle-internals.com\/blog\/wp-json\/wp\/v2\/categories?post=33"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/oracle-internals.com\/blog\/wp-json\/wp\/v2\/tags?post=33"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}