![\"CaptureCON_ID\"](\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureCON_ID.png\")
<\/a><\/p>\nMAX_PDBS<\/h3>\n
In 12.1 you have no supported way to prevent creating more than one PDB. In 12.2 you have a parameter, MAX_PDBS, which is documented as the maximum number of user created pluggable database. You you can expect it to have the maximum of 4096 but it’s actually 4098 and this is the default value:<\/p>\n
\nSQL> show parameter max_pdbs\n \nNAME TYPE VALUE\n------------------------------------ ----------- ------------------------------\nmax_pdbs integer 4098\n<\/code><\/pre>\nSo to be sure, let’s create many pluggable databases.<\/p>\n
I have one pluggable database, PDB1, opened in read-only:<\/p>\n
\nSQL> show pdbs\n \n CON_ID CON_NAME OPEN MODE RESTRICTED\n---------- ------------------------------ ---------- ----------\n 2 PDB$SEED READ ONLY NO\n 3 PDB1 READ ONLY NO\n<\/code><\/pre>\nAnd use the following script to clone them:<\/p>\n
for i in {1..5000} ; do echo \"connect \/ as sysdba\"; echo \"create pluggable database pdb$i$RANDOM from pdb1 snapshot copy;\" ; echo 'select max(con_id),count(*) from dba_pdbs;' ; echo \"host df -h \/u01 \/u02\" ; done | sqlplus \/ as sysdba<\/code><\/pre>\nuntil it fails with:<\/p>\n
\nSQL> create pluggable database pdb49613971 from pdb1 snapshot copy\n *\nERROR at line 1:\nORA-65010: maximum number of pluggable databases created\n<\/code><\/pre>\nNote that I use clonedb=true snapshot copy because I don’t want to fill up my filesystem:<\/p>\n
\nSQL> show parameter clonedb\n \nNAME TYPE VALUE\n------------------------------------ ----------- ------------------------------\nclonedb boolean TRUE\nclonedb_dir string \/u02\/oradata\/CDB1\n \nSQL> host du -h \/u02\/oradata\/CDB1\/CDB1_bitmap.dbf\n31M \/u02\/oradata\/CDB1\/CDB1_bitmap.dbf\n<\/code><\/pre>\nAs you see I’ve put the bitmap file outside of $ORACLE_HOME\/dbs because in 12.2 we have a parameter for that. So many new features…
\nIn addition to that I had to increase sga, processes and db_files.<\/p>\n
Here I have my 4097 PDBs<\/p>\n
\nSQL> select max(con_iount(*) from dba_pdbs;\n \nMAX(CON_ID) COUNT(*)\n----------- ----------\n 4098 4097<\/code><\/pre>\nwhich includes PDB$SEED. This means 4098 containers inside of my CDB:<\/p>\n
SQL> select max(con_id),count(*) from v$containers;\n \nMAX(CON_ID) COUNT(*)\n----------- ----------\n 4098 4098<\/code><\/pre>\nSQL> set pagesize 1000 linesize 1000\nselect min(con_id),max(con_id),count(*),substr(listagg(name,',' on overflow truncate)within group(order by con_id),1,30) from v$containers;SQL>\n \nMIN(CON_ID) MAX(CON_ID) COUNT(*) SUBSTR(LISTAGG(NAME,','ONOVERFLOWTRUNCATE)WITHINGROUP(ORDERBYCON_ID),1,30)\n----------- ----------- ---------- ------------------------------------------------------------------------------------------------------------------------\n 1 4098 4098 CDB$ROOT,PDB$SEED,PDB1,PDB2105<\/code><\/pre>\nSo basically you can’t reach the MAX_PDBS default with user created PDBs.<\/p>\n
But…<\/h3>\n
What is really cool with ‘cloud first’ is that we can test it, all on the same platform, probably hit bugs that will be fixed before the on-premises version. This is a great way to ensure that the version is stable when we will put production on it. <\/p>\n
I have one PDB:<\/p>\n
\nSQL*Plus: Release 12.2.0.1.0 Production on Thu Nov 10 12:12:25 2016\n \nCopyright (c) 1982, 2016, Oracle. All rights reserved.\n \nConnected to:\nOracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production\n \n12:12:25 SQL> show pdbs\n \n CON_ID CON_NAME OPEN MODE RESTRICTED\n---------- ------------------------------ ---------- ----------\n 2 PDB$SEED READ ONLY NO\n 3 PDB1 MOUNTED\n<\/code><\/pre>\nI drop it:<\/p>\n
\n12:12:26 SQL> drop pluggable database pdb1 including datafiles;\nPluggable database dropped.\n<\/code><\/pre>\nI set MAX_PDBS to one:<\/p>\n
\n \n12:12:44 SQL> show parameter max_pdbs\n \nNAME TYPE VALUE\n------------------------------------ ----------- ------------------------------\nmax_pdbs integer 4098\n \n12:13:24 SQL> alter system set max_pdbs=1 scope=memory;\nSystem altered.\n \n12:13:45 SQL> show parameter max_pdbs\n \nNAME TYPE VALUE\n------------------------------------ ----------- ------------------------------\nmax_pdbs integer 1\n<\/code><\/pre>\nAnd then try to re-create my PDB:<\/p>\n
\n12:13:54 SQL> create pluggable database PDB1 admin user pdbadmin identified by oracle;\ncreate pluggable database PDB1 admin user pdbadmin identified by oracle\n*\nERROR at line 1:\nORA-65010: maximum number of pluggable databases created\n<\/code><\/pre>\nThis is not what I expected. Let’s try to increase MAX_PDBS to two, even if I’m sure to have only one user PDB:<\/p>\n
\n12:14:07 SQL> alter system set max_pdbs=2 scope=memory;\nSystem altered.\n \n12:14:18 SQL> create pluggable database PDB1 admin user pdbadmin identified by oracle;\nPluggable database created.\n<\/code><\/pre>\nOk. Let’s drop it and re-create it again:<\/p>\n
\n12:15:20 SQL> drop pluggable database PDB1 including datafiles;\nPluggable database dropped.\n \n12:16:02 SQL> create pluggable database PDB1 admin user pdbadmin identified by oracle;\ncreate pluggable database PDB1 admin user pdbadmin identified by oracle\n*\nERROR at line 1:\nORA-65010: maximum number of pluggable databases created\n<\/code><\/pre>\nThat’s bad. It seems that the previously dropped PDBs are still counted:<\/p>\n
\n12:16:07 SQL> alter system set max_pdbs=3 scope=memory;\nSystem altered.\n \n12:16:17 SQL> create pluggable database PDB1 admin user pdbadmin identified by oracle;\nPluggable database created.\n \n12:17:10 SQL> show pdbs;\n \n CON_ID CON_NAME OPEN MODE RESTRICTED\n---------- ------------------------------ ---------- ----------\n 2 PDB$SEED READ ONLY NO\n 3 PDB1 MOUNTED\n12:18:14 SQL> drop pluggable database PDB1 including datafiles;\nPluggable database dropped.\n \n12:18:28 SQL> create pluggable database PDB1 admin user pdbadmin identified by oracle;\ncreate pluggable database PDB1 admin user pdbadmin identified by oracle\n*\nERROR at line 1:\nORA-65010: maximum number of pluggable databases created\n<\/code><\/pre>\nProbably a small bug there. Some counters not reset maybe.<\/p>\n
<\/h3>\n
I’ve dropped one PDB from the CDB where I reached the limit of 4096:<\/p>\n
\nSQL> select count(*) from dba_pdbs where con_id>2;\n \n COUNT(*)\n----------\n 4095\n<\/code><\/pre>\nI can set MAX_PDBS to 4095 if I and to prevent creating a new one:<\/p>\n
\nSQL> alter system set max_pdbs=4095;\nSystem altered.\n<\/code><\/pre>\nWhat if I want to set it lower than the number of PDBs I have? An error message would be nice, but probably not this one:<\/p>\n
\nSQL> alter system set max_pdbs=4094;\nalter system set max_pdbs=4094\n*\nERROR at line 1:\nORA-32017: failure in updating SPFILE\nORA-65331: DDL on a data link table is outside an application action.\n<\/code><\/pre>\nAnyway, now that MAX_PDBS is set to 4095 I can’t create another one:<\/p>\n
\nSQL> create pluggable database PDB2 from PDB1;\ncreate pluggable database PDB2 from PDB1\n*\nERROR at line 1:\nORA-65010: maximum number of pluggable databases created\n<\/code><\/pre>\nwhich is the goal of this parameter and confirms that it counts the user created PDBs and not the all containers.<\/p>\n
Here it seems that I can re-create my last PDB when I increase the MAX_PDBS:<\/p>\n
\nSQL> alter system set max_pdbs=4096;\nSystem altered.\nSQL> create pluggable database PDB2 from PDB1;\nPluggable database created.\n<\/code><\/pre>\nBy the way, here is how the multitenant feature usage is detected:<\/p>\n
\nSQL> select name feature_name,version,detected_usages,aux_count \n from dba_feature_usage_statistics \n where name like '%Pluggable%' or name like '%Multitenant%';\n \nFEATURE_NAME\n--------------------------------------------------------------------------------\nVERSION DETECTED_USAGES AUX_COUNT\n----------------- --------------- ----------\nOracle Multitenant\n12.2.0.1.0 3 4096\n<\/code><\/pre>\nThe detected usage just means that I’m in a CDB. The AUX_COUNT tells me if I require the multitenant option. But that’s for a future blog post.<\/p>\n","protected":false},"excerpt":{"rendered":"
By Franck Pachot . Oracle database 12.2 is there on the Database Cloud Service, in multitenant. In EE High Performance or Extreme Performance, you have the multitenant option: you can create 4096 pluggable database (instead of 252 in 12.1). If you are in lower services, you can create only one user PDB (not counting application […]<\/p>\n","protected":false},"author":27,"featured_media":8636,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[229],"tags":[656,220,64,96,209,66,223],"type_dbi":[],"class_list":["post-9292","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database-administration-monitoring","tag-12-2","tag-cdb","tag-multitenant","tag-oracle","tag-oracle-12c","tag-pdb","tag-pluggable-databases"],"acf":[],"yoast_head":"\n
Oracle 12cR2: MAX_PDBS - 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\/oracle-12cr2-max_pdbs\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Oracle 12cR2: MAX_PDBS\" \/>\n<meta property=\"og:description\" content=\"By Franck Pachot . Oracle database 12.2 is there on the Database Cloud Service, in multitenant. In EE High Performance or Extreme Performance, you have the multitenant option: you can create 4096 pluggable database (instead of 252 in 12.1). If you are in lower services, you can create only one user PDB (not counting application […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/oracle-12cr2-max_pdbs\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2016-11-11T05:43:44+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureCON_ID.png\" \/>\n\t<meta property=\"og:image:width\" content=\"803\" \/>\n\t<meta property=\"og:image:height\" content=\"518\" \/>\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=\"6 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-12cr2-max_pdbs\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-12cr2-max_pdbs\/\"},\"author\":{\"name\":\"Oracle Team\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\"},\"headline\":\"Oracle 12cR2: MAX_PDBS\",\"datePublished\":\"2016-11-11T05:43:44+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-12cr2-max_pdbs\/\"},\"wordCount\":579,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-12cr2-max_pdbs\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureCON_ID.png\",\"keywords\":[\"12.2\",\"CDB\",\"multitenant\",\"Oracle\",\"Oracle 12c\",\"PDB\",\"Pluggable Databases\"],\"articleSection\":[\"Database Administration & Monitoring\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/oracle-12cr2-max_pdbs\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-12cr2-max_pdbs\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/oracle-12cr2-max_pdbs\/\",\"name\":\"Oracle 12cR2: MAX_PDBS - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-12cr2-max_pdbs\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-12cr2-max_pdbs\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureCON_ID.png\",\"datePublished\":\"2016-11-11T05:43:44+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-12cr2-max_pdbs\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/oracle-12cr2-max_pdbs\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-12cr2-max_pdbs\/#primaryimage\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureCON_ID.png\",\"contentUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureCON_ID.png\",\"width\":803,\"height\":518},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-12cr2-max_pdbs\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Oracle 12cR2: MAX_PDBS\"}]},{\"@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 12cR2: MAX_PDBS - 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\/oracle-12cr2-max_pdbs\/","og_locale":"en_US","og_type":"article","og_title":"Oracle 12cR2: MAX_PDBS","og_description":"By Franck Pachot . Oracle database 12.2 is there on the Database Cloud Service, in multitenant. In EE High Performance or Extreme Performance, you have the multitenant option: you can create 4096 pluggable database (instead of 252 in 12.1). If you are in lower services, you can create only one user PDB (not counting application […]","og_url":"https:\/\/www.dbi-services.com\/blog\/oracle-12cr2-max_pdbs\/","og_site_name":"dbi Blog","article_published_time":"2016-11-11T05:43:44+00:00","og_image":[{"width":803,"height":518,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureCON_ID.png","type":"image\/png"}],"author":"Oracle Team","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Oracle Team","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/oracle-12cr2-max_pdbs\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-12cr2-max_pdbs\/"},"author":{"name":"Oracle Team","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"headline":"Oracle 12cR2: MAX_PDBS","datePublished":"2016-11-11T05:43:44+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-12cr2-max_pdbs\/"},"wordCount":579,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-12cr2-max_pdbs\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureCON_ID.png","keywords":["12.2","CDB","multitenant","Oracle","Oracle 12c","PDB","Pluggable Databases"],"articleSection":["Database Administration & Monitoring"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/oracle-12cr2-max_pdbs\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/oracle-12cr2-max_pdbs\/","url":"https:\/\/www.dbi-services.com\/blog\/oracle-12cr2-max_pdbs\/","name":"Oracle 12cR2: MAX_PDBS - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-12cr2-max_pdbs\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-12cr2-max_pdbs\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureCON_ID.png","datePublished":"2016-11-11T05:43:44+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-12cr2-max_pdbs\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/oracle-12cr2-max_pdbs\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/oracle-12cr2-max_pdbs\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureCON_ID.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureCON_ID.png","width":803,"height":518},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/oracle-12cr2-max_pdbs\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Oracle 12cR2: MAX_PDBS"}]},{"@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\/9292","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=9292"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/9292\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/8636"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=9292"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=9292"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=9292"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=9292"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}