{"id":10613,"date":"2017-11-05T17:38:31","date_gmt":"2017-11-05T16:38:31","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/multitenant-dictionary-what-is-consolidated-and-what-is-not\/"},"modified":"2017-11-05T17:38:31","modified_gmt":"2017-11-05T16:38:31","slug":"multitenant-dictionary-what-is-consolidated-and-what-is-not","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/multitenant-dictionary-what-is-consolidated-and-what-is-not\/","title":{"rendered":"Multitenant dictionary: what is consolidated and what is not"},"content":{"rendered":"<h2>By Franck Pachot<\/h2>\n<p>.<br \/>\nThe <a href=\"https:\/\/docs.oracle.com\/database\/121\/CNCPT\/cdblogic.htm#CNCPT89255\" target=\"_blank\" rel=\"noopener noreferrer\">documentation<\/a> says that for <i>Reduction of duplication<\/i> and <i>Ease of database upgrade<\/i> the <i>Oracle-supplied objects such as data dictionary table definitions and PL\/SQL packages are represented only in the root<\/i>. <\/p>\n<p>Unfortunately, this is only partly true. System PL\/SQL packages are only in root but system table definition are replicated into all PDBs.<br \/>\n<!--more--><\/p>\n<p>This post is an extension of a <a href=\"https:\/\/www.dbi-services.com\/blog\/multitenant-dictionary-what-is-stored-only-in-cdbroot\/\" target=\"_blank\" rel=\"noopener noreferrer\">previous blog<\/a> post which was on 12<em>c<\/em>R1. This one is on 12<em>c<\/em>R2.<\/p>\n<p>As I did at Open World and will do at DOAG, I show multitenant internals by creating a metadata link procedure. When I do a simple &#8216;describe&#8217; when connected to a PDB, the sql_trace shows that the session switches to the CDB$ROOT to get the procedure information:<\/p>\n<pre><code>\n*** 2017-11-05T16:17:36.339126+01:00 (CDB$ROOT(1))\n=====================\nPARSING IN CURSOR #140420856738440 len=143 dep=1 uid=0 oct=3 lid=0 tim=101728244788 hv=2206365737 ad='7f60a7f0' sqlid='9fjf75a1s4y19'\nselect procedure#,procedurename,properties,itypeobj#, properties2 from procedureinfo$ where obj#=:1 order by procedurename desc, overload# desc\nEND OF STMT<\/code><\/pre>\n<p>All information about the system PL\/SQL procedures is stored in the root only. The PDB has only a dummy row in OBJ$ to mention that it is a metadata link. And this is why you pay for the multitenant option: consolidation of all system dictionary objects into the root only. You save space (on disk and related memory) and you have only one place to upgrade. <\/p>\n<p>But this is implemented only for some objects, like PL\/SQL procedures, but not for others like table and indexes. If you &#8216;describe&#8217; a metadata link table when connected to a PDB you will not see any switch to CDB$ROOT in the sql_trace:<\/p>\n<pre><code>\n*** 2017-11-05T13:01:53.541231+01:00 (PDB1(3))\nPARSING IN CURSOR #139835947128936 len=86 dep=1 uid=0 oct=3 lid=0 tim=98244321664 hv=2195287067 ad='75f823b8' sqlid='32bhha21dkv0v'\nselect col#,intcol#,charsetid,charsetform from col$ where obj#=:1 order by intcol# asc\nEND OF STMT\nPARSE #139835947128936:c=0,e=158,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=4,plh=3765558045,tim=98244321664\nBINDS #139835947128936:\n Bind#0\n  oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00\n  oacflg=08 fl2=1000001 frm=00 csi=00 siz=24 off=0\n  kxsbbbfp=7f2e124fef10  bln=22  avl=03  flg=05\n  value=747\nEXEC #139835947128936:c=1000,e=603,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=4,plh=3765558045,tim=98244322311\nFETCH #139835947128936:c=0,e=15,p=0,cr=3,cu=0,mis=0,r=1,dep=1,og=4,plh=3765558045,tim=98244322342\nFETCH #139835947128936:c=0,e=1,p=0,cr=0,cu=0,mis=0,r=1,dep=1,og=4,plh=3765558045,tim=98244322356\nFETCH #139835947128936:c=0,e=4,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,plh=3765558045,tim=98244322369\nSTAT #139835947128936 id=1 cnt=2 pid=0 pos=1 obj=0 op='SORT ORDER BY (cr=3 pr=0 pw=0 str=1 time=16 us cost=3 size=234 card=13)'\nSTAT #139835947128936 id=2 cnt=2 pid=1 pos=1 obj=21 op='TABLE ACCESS CLUSTER COL$ (cr=3 pr=0 pw=0 str=1 time=11 us cost=2 size=234 card=13)'\nSTAT #139835947128936 id=3 cnt=1 pid=2 pos=1 obj=3 op='INDEX UNIQUE SCAN I_OBJ# (cr=2 pr=0 pw=0 str=1 time=6 us cost=1 size=0 card=1)'\nCLOSE #139835947128936:c=0,e=1,dep=1,type=3,tim=98244322439\n<\/code><\/pre>\n<p>Here all information about the columns is read from COL$ in the PDB. And if you look at TAB$ (tables), COL$ (table columns), IND$ (indexes), CONS$ and CDEF$ (constraints), you will see that they contain rows in a PDB where no user objects have been created. This is the case for all information related to tables: they are stored in CDB$ROOT and replicated into all other containers: PDB$SEED and all user created PDB. Only the information related to non-data objects, are stored only in one container.<\/p>\n<p>I&#8217;ve run a query to count the rows in CDB$ROOT and PDB$SEED and here is the result:<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureMultitenantNumRows.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureMultitenantNumRows.png\" alt=\"CaptureMultitenantNumRows\" width=\"1134\" height=\"852\" class=\"aligncenter size-full wp-image-19430\" \/><\/a><\/p>\n<p>All rows in OBJ$ are replicated, which is expected because this is where the metadata link information is stored. But you see also all information related to tables that are also replicated, such as the 100000+ columns in COL$. And this is the reason why you do not see a big consolidation benefit when you look at the size of the SYSTEM tablespace in pluggable databases which do no contain any user data:<\/p>\n<pre><code>\nList of Permanent Datafiles\n===========================\nFile Size(MB) Tablespace           RB segs Datafile Name\n---- -------- -------------------- ------- ------------------------\n1    820      SYSTEM               YES     \/u01\/oradata\/CDB1A\/system01.dbf\n3    630      SYSAUX               NO      \/u01\/oradata\/CDB1A\/sysaux01.dbf\n4    80       UNDOTBS1             YES     \/u01\/oradata\/CDB1A\/undotbs01.dbf\n5    250      PDB$SEED:SYSTEM      NO      \/u01\/oradata\/CDB1A\/pdbseed\/system01.dbf\n6    390      PDB$SEED:SYSAUX      NO      \/u01\/oradata\/CDB1A\/pdbseed\/sysaux01.dbf\n7    5        USERS                NO      \/u01\/oradata\/CDB1A\/users01.dbf\n8    100      PDB$SEED:UNDOTBS1    NO      \/u01\/oradata\/CDB1A\/pdbseed\/undotbs01.dbf\n9    270      PDB1:SYSTEM          YES     \/u01\/oradata\/CDB1A\/PDB1\/system01.dbf\n10   440      PDB1:SYSAUX          NO      \/u01\/oradata\/CDB1A\/PDB1\/sysaux01.dbf\n11   100      PDB1:UNDOTBS1        YES     \/u01\/oradata\/CDB1A\/PDB1\/undotbs01.dbf\n12   5        PDB1:USERS           NO      \/u01\/oradata\/CDB1A\/PDB1\/users01.dbf\n<\/code><\/pre>\n<p>Here I have 250MB in PDB$SEED which is supposed to contain only links to the 820GB SYSTEM tablespace, but there is a lot more than that.<\/p>\n<p>So, basically, not all the dictionary is consolidated in multitenant but only the non-data part such as those PL\/SQL packages and the dictionary views definition. You can think about the multitenant option consolidation as an extension to sharing the Oracle Home among several databases. It concerns the software part only. But the part of the dictionary which contains data about system objects is replicated into all containers, and is read locally without a context switch. This also means that a patch or upgrade on them has to be run in all containers.<\/p>\n<p>With the fact that some information is replicated and some are not, comes the complexity to manage that in the dictionary views, and this will be the subject of the <a href=\"https:\/\/www.dbi-services.com\/blog\/multitenant-internals-int-and-intint-views\/\" target=\"_blank\" rel=\"noopener noreferrer\">next blog post<\/a> about INT$INT$ views.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>By Franck Pachot . The documentation says that for Reduction of duplication and Ease of database upgrade the Oracle-supplied objects such as data dictionary table definitions and PL\/SQL packages are represented only in the root. Unfortunately, this is only partly true. System PL\/SQL packages are only in root but system table definition are replicated into [&hellip;]<\/p>\n","protected":false},"author":27,"featured_media":10614,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[59],"tags":[220,455,64,707,875,66,223],"type_dbi":[],"class_list":["post-10613","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-oracle","tag-cdb","tag-internals","tag-multitenant","tag-oracle-12","tag-oracle-multitenant","tag-pdb","tag-pluggable-databases"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.2 (Yoast SEO v27.2) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Multitenant dictionary: what is consolidated and what is not - dbi Blog<\/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:\/\/www.dbi-services.com\/blog\/multitenant-dictionary-what-is-consolidated-and-what-is-not\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Multitenant dictionary: what is consolidated and what is not\" \/>\n<meta property=\"og:description\" content=\"By Franck Pachot . The documentation says that for Reduction of duplication and Ease of database upgrade the Oracle-supplied objects such as data dictionary table definitions and PL\/SQL packages are represented only in the root. Unfortunately, this is only partly true. System PL\/SQL packages are only in root but system table definition are replicated into [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/multitenant-dictionary-what-is-consolidated-and-what-is-not\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2017-11-05T16:38:31+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureMultitenantNumRows.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1134\" \/>\n\t<meta property=\"og:image:height\" content=\"852\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\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=\"5 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\/multitenant-dictionary-what-is-consolidated-and-what-is-not\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/multitenant-dictionary-what-is-consolidated-and-what-is-not\/\"},\"author\":{\"name\":\"Oracle Team\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\"},\"headline\":\"Multitenant dictionary: what is consolidated and what is not\",\"datePublished\":\"2017-11-05T16:38:31+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/multitenant-dictionary-what-is-consolidated-and-what-is-not\/\"},\"wordCount\":584,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/multitenant-dictionary-what-is-consolidated-and-what-is-not\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureMultitenantNumRows.png\",\"keywords\":[\"CDB\",\"internals\",\"multitenant\",\"Oracle 12\",\"Oracle Multitenant\",\"PDB\",\"Pluggable Databases\"],\"articleSection\":[\"Oracle\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/multitenant-dictionary-what-is-consolidated-and-what-is-not\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/multitenant-dictionary-what-is-consolidated-and-what-is-not\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/multitenant-dictionary-what-is-consolidated-and-what-is-not\/\",\"name\":\"Multitenant dictionary: what is consolidated and what is not - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/multitenant-dictionary-what-is-consolidated-and-what-is-not\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/multitenant-dictionary-what-is-consolidated-and-what-is-not\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureMultitenantNumRows.png\",\"datePublished\":\"2017-11-05T16:38:31+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/multitenant-dictionary-what-is-consolidated-and-what-is-not\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/multitenant-dictionary-what-is-consolidated-and-what-is-not\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/multitenant-dictionary-what-is-consolidated-and-what-is-not\/#primaryimage\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureMultitenantNumRows.png\",\"contentUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureMultitenantNumRows.png\",\"width\":1134,\"height\":852},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/multitenant-dictionary-what-is-consolidated-and-what-is-not\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Multitenant dictionary: what is consolidated and what is not\"}]},{\"@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":"Multitenant dictionary: what is consolidated and what is not - dbi Blog","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\/multitenant-dictionary-what-is-consolidated-and-what-is-not\/","og_locale":"en_US","og_type":"article","og_title":"Multitenant dictionary: what is consolidated and what is not","og_description":"By Franck Pachot . The documentation says that for Reduction of duplication and Ease of database upgrade the Oracle-supplied objects such as data dictionary table definitions and PL\/SQL packages are represented only in the root. Unfortunately, this is only partly true. System PL\/SQL packages are only in root but system table definition are replicated into [&hellip;]","og_url":"https:\/\/www.dbi-services.com\/blog\/multitenant-dictionary-what-is-consolidated-and-what-is-not\/","og_site_name":"dbi Blog","article_published_time":"2017-11-05T16:38:31+00:00","og_image":[{"width":1134,"height":852,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureMultitenantNumRows.png","type":"image\/png"}],"author":"Oracle Team","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Oracle Team","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/multitenant-dictionary-what-is-consolidated-and-what-is-not\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/multitenant-dictionary-what-is-consolidated-and-what-is-not\/"},"author":{"name":"Oracle Team","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"headline":"Multitenant dictionary: what is consolidated and what is not","datePublished":"2017-11-05T16:38:31+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/multitenant-dictionary-what-is-consolidated-and-what-is-not\/"},"wordCount":584,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/multitenant-dictionary-what-is-consolidated-and-what-is-not\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureMultitenantNumRows.png","keywords":["CDB","internals","multitenant","Oracle 12","Oracle Multitenant","PDB","Pluggable Databases"],"articleSection":["Oracle"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/multitenant-dictionary-what-is-consolidated-and-what-is-not\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/multitenant-dictionary-what-is-consolidated-and-what-is-not\/","url":"https:\/\/www.dbi-services.com\/blog\/multitenant-dictionary-what-is-consolidated-and-what-is-not\/","name":"Multitenant dictionary: what is consolidated and what is not - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/multitenant-dictionary-what-is-consolidated-and-what-is-not\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/multitenant-dictionary-what-is-consolidated-and-what-is-not\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureMultitenantNumRows.png","datePublished":"2017-11-05T16:38:31+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/multitenant-dictionary-what-is-consolidated-and-what-is-not\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/multitenant-dictionary-what-is-consolidated-and-what-is-not\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/multitenant-dictionary-what-is-consolidated-and-what-is-not\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureMultitenantNumRows.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureMultitenantNumRows.png","width":1134,"height":852},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/multitenant-dictionary-what-is-consolidated-and-what-is-not\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Multitenant dictionary: what is consolidated and what is not"}]},{"@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\/10613","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=10613"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/10613\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/10614"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=10613"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=10613"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=10613"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=10613"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}