{"id":2915,"date":"2013-07-26T06:12:00","date_gmt":"2013-07-26T04:12:00","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/oracle-database-12c-information-lifecycle-management\/"},"modified":"2013-07-26T06:12:00","modified_gmt":"2013-07-26T04:12:00","slug":"oracle-database-12c-information-lifecycle-management","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/oracle-database-12c-information-lifecycle-management\/","title":{"rendered":"Oracle Database 12c: Information Lifecycle Management"},"content":{"rendered":"<p><img decoding=\"async\" class=\"blog-image aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/2e1ax_default_entry_Oracle_Database_12c.jpg\" alt=\"\" \/><\/p>\n<p>More and more resources are used in companies to manage data. Most companies buy more and more storage systems because of poor resource utilization.\u00a0Starting with Oracle 11g, Oracle has introduced Information Lifecycle Management (ILM) which can use different kinds of storage with varying performances in order to increase cost savings. In Oracle 12c, ILM now allows the automation of the data movement to different storage tiers and the compression at segment level. The idea behind ILM is that when a data is recent it is often accessed, but when the data is old it is not very much accessed. The old data can be moved to a low cost storage, and the most recent data may use high performance storage.<\/p>\n<h3>Storage types<\/h3>\n<p>Four types of storage tiers can be used:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/ilm1.png\" alt=\"ilm1\" width=\"517\" height=\"325\" \/><\/p>\n<p><em>Source: Oracle Documentation\u00a0<\/em><\/p>\n<ul>\n<li>High performance storage tier to be used by the frequently accessed data.<\/li>\n<li>Low cost storage tier to manage the old data rarely accessed.<\/li>\n<li>Online archive storage tier to manager data seldom accessed, which can be low cost storage tier.<\/li>\n<li>Offline archive storage tier to manage data removed from the database which can be stored on a tape.<\/li>\n<\/ul>\n<p>The central advantages of the online archive storage tier are:<\/p>\n<ul>\n<li>Data are always online with faster access in comparison to tape.<\/li>\n<li>The storage cost is low.<\/li>\n<li>The application can be used to access the data immediately &#8211;\u00a0no need to restore from a tape.<\/li>\n<\/ul>\n<p>Information Lifecycle Management (ILM) allows us to use policies at the row, segment, and table level with &#8220;create&#8221; and &#8220;alter&#8221; SQL statements.<br \/>\nThe syntax of the ILM clause is:<\/p>\n<p><samp><code class=\"SP13319652\"><span class=\"SC13155656\">ILM_clause := ILM {[ADD | DELETE | DELETE_ALL | ENABLE_ALL | DISABLE_ALL] <\/span><\/code><code class=\"1dbiCopy\"><span class=\"SC13155656\">policy_name POLICY_CLAUSE} | ILM_tracking_clause<\/span><\/code><\/samp><\/p>\n<p>These ILM policies help us moving data between different tiers of storage. And a new feature has appeared in the Oracle 12c version: The ILM policies now allow to fix the compression level for each storage tier.<\/p>\n<p>The syntax of the compression_clause is:<\/p>\n<p><samp><code class=\"SP13319652\"><span class=\"SC13155656\">compression_clause := <\/span><\/code><code class=\"SP13319652\"><span class=\"SC13155656\">{ COMPRESS FOR { OLTP [INPLACE] | QUERY {LOW | HIGH} } | ARCHIVE {LOW | HIGH}}}<\/span><\/code><\/samp><\/p>\n<p>The ILM storage tiering policies are only available at the segment level.<\/p>\n<p>The syntax of the tiering_clause is:<\/p>\n<p><samp><code class=\"1dbiCopy\"><span class=\"SC13155656\">tiering_clause := TIER TO tablespace_name<\/span><\/code><\/samp><\/p>\n<p>The ILM tracking clause syntax is:<\/p>\n<p><samp><code>ILM_tracking_clause ::= ILM {ENABLE | DISABLE} ACTIVITY TRACKING ILM_activity_clause<\/code><code style=\"margin: 19pt 0cm 4pt;\">ILM_activity_clause ::= { SEGMENT ACCESS | (WRITE TIME | CREATE TIME | READ TIME)}<\/code><\/samp><\/p>\n<h3>Segment level compression tiering<\/h3>\n<p>As already explained, ILM in Oracle 12c allows the automation of the data movement to different storage tiers and the compression at segment level. Thus, we can also define compression policies for each storage tier and decide when the data will be moved.<\/p>\n<p>Let&#8217;s create a table and enable activity tracking:<\/p>\n<p class=\"dbiNormal\"><span class=\"SC13155660\">\u00a0<img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/ilm2.png\" alt=\"ilm2\" width=\"651\" height=\"146\" \/><\/span><\/p>\n<p>The compression policy is created:<\/p>\n<p class=\"dbiNormal\"><span class=\"SC13155660\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/ilm3.png\" alt=\"ilm3\" width=\"516\" height=\"73\" \/><\/span><\/p>\n<p>Let&#8217;s define a storage policy:<\/p>\n<p class=\"dbiNormal\"><span class=\"SC13155660\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/ilm4.png\" alt=\"ilm4\" width=\"492\" height=\"44\" \/><\/span><\/p>\n<p>You can also disable the activity tracking:<\/p>\n<p class=\"dbiNormal\"><span class=\"SC13155660\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/ilm5.png\" alt=\"ilm5\" width=\"649\" height=\"68\" \/><\/span><\/p>\n<p>You can see in this last example how data is compressed after some delay of inactivity and how it is automatically moved to a low cost storage tier.<\/p>\n<h3>Row level compression tiering<\/h3>\n<p>We can use row level compression in combination with segment level compression.<br \/>\nFor example, we can compress the rows of the table trade for OLTP after 1 month of no modification by running the following SQL statement:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/ilm6.png\" alt=\"ilm6\" width=\"399\" height=\"104\" \/><\/p>\n<p>With the combination of the row level compression and segment level compression, the DBA has really an efficient way to know where his data is and how it is managed. In fact, because of the data volume reduction, the performance will become better and the size of the rman backups will also decrease.<\/p>\n<h3>Conclusion<\/h3>\n<p>The new ILM features &#8211; row and segment level compression tiering &#8211; allow a better control of the data in the database. These features are very interesting for automatically managing the database storage, optimizing its performance, and reducing the storage cost.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>More and more resources are used in companies to manage data. Most companies buy more and more storage systems because of poor resource utilization.\u00a0Starting with Oracle 11g, Oracle has introduced Information Lifecycle Management (ILM) which can use different kinds of storage with varying performances in order to increase cost savings. In Oracle 12c, ILM now [&hellip;]<\/p>\n","protected":false},"author":27,"featured_media":2695,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[48],"tags":[364,209,35],"type_dbi":[],"class_list":["post-2915","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-technology-survey","tag-information-lifecycle-management","tag-oracle-12c","tag-storage"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.2 (Yoast SEO v27.4) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Oracle Database 12c: Information Lifecycle Management - dbi Blog<\/title>\n<meta name=\"description\" content=\"More and more resources are used in companies to manage data. Most companies buy more and more storage systems because of poor resource utilization. Starting with Oracle 11g, Oracle has introduced Information Lifecycle Management (ILM) which can use different kinds of storage with varying performances in order to increase cost savings. In Oracle 12c, ILM now allows the automation of the data movement to different storage tiers and the compression at segment level.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dbi-services.com\/blog\/oracle-database-12c-information-lifecycle-management\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Oracle Database 12c: Information Lifecycle Management\" \/>\n<meta property=\"og:description\" content=\"More and more resources are used in companies to manage data. Most companies buy more and more storage systems because of poor resource utilization. Starting with Oracle 11g, Oracle has introduced Information Lifecycle Management (ILM) which can use different kinds of storage with varying performances in order to increase cost savings. In Oracle 12c, ILM now allows the automation of the data movement to different storage tiers and the compression at segment level.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/oracle-database-12c-information-lifecycle-management\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2013-07-26T04:12:00+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/2e1ax_default_entry_Oracle_Database_12c.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"406\" \/>\n\t<meta property=\"og:image:height\" content=\"100\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Oracle Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Oracle Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/oracle-database-12c-information-lifecycle-management\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/oracle-database-12c-information-lifecycle-management\\\/\"},\"author\":{\"name\":\"Oracle Team\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/66ab87129f2d357f09971bc7936a77ee\"},\"headline\":\"Oracle Database 12c: Information Lifecycle Management\",\"datePublished\":\"2013-07-26T04:12:00+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/oracle-database-12c-information-lifecycle-management\\\/\"},\"wordCount\":576,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/oracle-database-12c-information-lifecycle-management\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/04\\\/2e1ax_default_entry_Oracle_Database_12c.jpg\",\"keywords\":[\"Information Lifecycle Management\",\"Oracle 12c\",\"Storage\"],\"articleSection\":[\"Technology Survey\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/oracle-database-12c-information-lifecycle-management\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/oracle-database-12c-information-lifecycle-management\\\/\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/oracle-database-12c-information-lifecycle-management\\\/\",\"name\":\"Oracle Database 12c: Information Lifecycle Management - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/oracle-database-12c-information-lifecycle-management\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/oracle-database-12c-information-lifecycle-management\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/04\\\/2e1ax_default_entry_Oracle_Database_12c.jpg\",\"datePublished\":\"2013-07-26T04:12:00+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/66ab87129f2d357f09971bc7936a77ee\"},\"description\":\"More and more resources are used in companies to manage data. Most companies buy more and more storage systems because of poor resource utilization. Starting with Oracle 11g, Oracle has introduced Information Lifecycle Management (ILM) which can use different kinds of storage with varying performances in order to increase cost savings. In Oracle 12c, ILM now allows the automation of the data movement to different storage tiers and the compression at segment level.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/oracle-database-12c-information-lifecycle-management\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/oracle-database-12c-information-lifecycle-management\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/oracle-database-12c-information-lifecycle-management\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/04\\\/2e1ax_default_entry_Oracle_Database_12c.jpg\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/04\\\/2e1ax_default_entry_Oracle_Database_12c.jpg\",\"width\":406,\"height\":100},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/oracle-database-12c-information-lifecycle-management\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Oracle Database 12c: Information Lifecycle Management\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\",\"name\":\"dbi Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/66ab87129f2d357f09971bc7936a77ee\",\"name\":\"Oracle Team\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g\",\"caption\":\"Oracle Team\"},\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/author\\\/oracle-team\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Oracle Database 12c: Information Lifecycle Management - dbi Blog","description":"More and more resources are used in companies to manage data. Most companies buy more and more storage systems because of poor resource utilization. Starting with Oracle 11g, Oracle has introduced Information Lifecycle Management (ILM) which can use different kinds of storage with varying performances in order to increase cost savings. In Oracle 12c, ILM now allows the automation of the data movement to different storage tiers and the compression at segment level.","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:\/\/www.dbi-services.com\/blog\/oracle-database-12c-information-lifecycle-management\/","og_locale":"en_US","og_type":"article","og_title":"Oracle Database 12c: Information Lifecycle Management","og_description":"More and more resources are used in companies to manage data. Most companies buy more and more storage systems because of poor resource utilization. Starting with Oracle 11g, Oracle has introduced Information Lifecycle Management (ILM) which can use different kinds of storage with varying performances in order to increase cost savings. In Oracle 12c, ILM now allows the automation of the data movement to different storage tiers and the compression at segment level.","og_url":"https:\/\/www.dbi-services.com\/blog\/oracle-database-12c-information-lifecycle-management\/","og_site_name":"dbi Blog","article_published_time":"2013-07-26T04:12:00+00:00","og_image":[{"width":406,"height":100,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/2e1ax_default_entry_Oracle_Database_12c.jpg","type":"image\/jpeg"}],"author":"Oracle Team","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Oracle Team","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/oracle-database-12c-information-lifecycle-management\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-database-12c-information-lifecycle-management\/"},"author":{"name":"Oracle Team","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"headline":"Oracle Database 12c: Information Lifecycle Management","datePublished":"2013-07-26T04:12:00+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-database-12c-information-lifecycle-management\/"},"wordCount":576,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-database-12c-information-lifecycle-management\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/2e1ax_default_entry_Oracle_Database_12c.jpg","keywords":["Information Lifecycle Management","Oracle 12c","Storage"],"articleSection":["Technology Survey"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/oracle-database-12c-information-lifecycle-management\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/oracle-database-12c-information-lifecycle-management\/","url":"https:\/\/www.dbi-services.com\/blog\/oracle-database-12c-information-lifecycle-management\/","name":"Oracle Database 12c: Information Lifecycle Management - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-database-12c-information-lifecycle-management\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-database-12c-information-lifecycle-management\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/2e1ax_default_entry_Oracle_Database_12c.jpg","datePublished":"2013-07-26T04:12:00+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"description":"More and more resources are used in companies to manage data. Most companies buy more and more storage systems because of poor resource utilization. Starting with Oracle 11g, Oracle has introduced Information Lifecycle Management (ILM) which can use different kinds of storage with varying performances in order to increase cost savings. In Oracle 12c, ILM now allows the automation of the data movement to different storage tiers and the compression at segment level.","breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-database-12c-information-lifecycle-management\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/oracle-database-12c-information-lifecycle-management\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/oracle-database-12c-information-lifecycle-management\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/2e1ax_default_entry_Oracle_Database_12c.jpg","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/2e1ax_default_entry_Oracle_Database_12c.jpg","width":406,"height":100},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/oracle-database-12c-information-lifecycle-management\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Oracle Database 12c: Information Lifecycle Management"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee","name":"Oracle Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g","caption":"Oracle Team"},"url":"https:\/\/www.dbi-services.com\/blog\/author\/oracle-team\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/2915","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/27"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=2915"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/2915\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/2695"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=2915"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=2915"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=2915"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=2915"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}