{"id":9750,"date":"2017-02-03T22:06:13","date_gmt":"2017-02-03T21:06:13","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/exadata-express-cloud-service-max_pdb_storage\/"},"modified":"2017-02-03T22:06:13","modified_gmt":"2017-02-03T21:06:13","slug":"exadata-express-cloud-service-max_pdb_storage","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/exadata-express-cloud-service-max_pdb_storage\/","title":{"rendered":"Exadata Express Cloud Service: MAX_PDB_STORAGE"},"content":{"rendered":"

By Franck Pachot<\/h2>\n

.
\nThe separation of roles between system DBA and application DBA is the way to go for agile development and the PDBaaS managed service is an excellent way to play with this concept: You are PDB administrator but not the CDB administrator.
\nHere is an example about tablespace creation\/deletion, and the kind of problems that may arise with this architecture.
\n
\nThe PDB administrator manages all the PDB objects. He must be able to create users and tablespaces in order to deploy an application.<\/p>\n

Create tablespace<\/h3>\n

So yes, in Exadata Express Cloud Service we can create a tablespace and this is what I did:<\/p>\n

\nSQL> create tablespace IOPS datafile size 10G;\nTablespace created.\n<\/code><\/pre>\n
and you don’t need to specify the datafile location because db_create_file_dest is defined:<\/p>\n
\nSQL> show parameter db_create_file_dest\n \nNAME                TYPE   VALUE \n------------------- ------ ----- \ndb_create_file_dest string +DATA \n<\/code><\/pre>\n
Actually, this is something that I cannot change because it is set by the CDB administrator when creating the PDB:<\/p>\n
\nSQL> alter session set db_create_file_dest='\/var\/tmp'\n \nError report -\nORA-02097: parameter cannot be modified because specified value is invalid\nORA-01031: insufficient privileges\n<\/code><\/pre>\n
This is a 12.2 feature. Impossible to create a file outside:<\/p>\n
\ncreate tablespace IOPS datafile '\/var\/tmp\/franck.dbf' size 10G\nError report -\nORA-65250: invalid path specified for file - \/var\/tmp\/franck.dbf\n<\/code><\/pre>\n
I’ve already written about that 12cR2 feature: http:\/\/dbi-services.com\/blog\/12cr2-create_file_dest-for-pdb-isolation\/<\/a> and this is a rather nice feature.<\/p>\n
MAX_PDB_STORAGE<\/h3>\n
There’s another limit in PDBaaS: you have a limit on the storage you can use. And in this X20 service, the limit is 20G.<\/p>\n
When you have reached the maximum, you get the following error:<\/p>\n
SQL> create tablespace ANOTHERONE datafile size 30G;\n \ncreate tablespace ANOTHERONE datafile size 30G\nError report -\nORA-65114: space usage in container is too high\n65114. 00000 -  \"space usage in container is too high\"\n*Cause:    Space usage in the current container exceeded the value of  MAX_PDB_STORAGE for the container.\n*Action:   Specify a higher value for MAX_PDB_STORAGE using the ALTER  PLUGGABLE DATABASE statement.\n<\/code><\/pre>\n
Ok. This limit is visible as a property of my PDB:<\/p>\n
SQL> select property_name, property_value from database_properties where property_name ='MAX_PDB_STORAGE';\n \nPROPERTY_NAME    PROPERTY_VALUE  \n-------------    --------------\nMAX_PDB_STORAGE  24771223880  <\/code><\/pre>\n
And the current size is visible from V$PDBS:<\/p>\n
SQL> select con_id,total_size from v$pdbs;\n \nCON_ID  TOTAL_SIZE   \n------  -----------\n47      24766742528\n<\/code><\/pre>\n
Nothing hidden here, this is the sum of my PDB files, datafiles and tempfiles:<\/p>\n
SQL> select sum(bytes) from dba_data_files;\nSUM(BYTES)   \n----------\n21761523712 \n \nSQL> select sum(bytes) from dba_temp_files;\nSUM(BYTES)  \n----------\n 3005218816\n<\/code><\/pre>\n
Of course, I’m not authorized to increase my limit:<\/p>\n
\nSQL> alter pluggable database storage(maxsize 40G);\n \nalter pluggable database storage(maxsize 40G)\nError report -\nORA-01031: insufficient privileges\n01031. 00000 -  \"insufficient privileges\"\n*Cause:    An attempt was made to perform a database operation without the necessary privileges.\n*Action:   Ask your database administrator or designated security administrator to grant you the necessary privileges\n<\/code><\/pre>\n
And this is once again a very nice feature coming in 12c<\/em>R2 multitenant.<\/p>\n
So… I’ve filled my X20 service. There a need for some housekeeping. But…<\/p>\n
Drop tablespace<\/h3>\n
I’m allowed to create and drop tablespaces. Let’s drop that IOPS tablespace:<\/p>\n
\nSQL> drop tablespace iops;\n \ndrop tablespace iops\nError report -\nORA-01031: insufficient privileges\n01031. 00000 -  \"insufficient privileges\"\n*Cause:    An attempt was made to perform a database operation without the necessary privileges.\n*Action:   Ask your database administrator or designated security administrator to grant you the necessary privileges\n<\/code><\/pre>\n
With lockdown profiles, you have always the same message: no clue about what is not authorized. I know that there is a DROP_TABLESPACE_KEEP_DATAFILES feature that you can disable with lockdown profiles and this makes sense when the CDB administrator do not want that PDB administrators leave dead datafiles in the system. Here we are on ASM, with OMF, so the datafiles are automatically dropped. But the lockdown is working at statement syntax level, so we have to mention the clause:<\/p>\n
\nSQL> drop tablespace iops including contents and datafiles;\n \ndrop tablespace iops including contents and datafiles\nError report -\nORA-38881: Cannot drop tablespace IOPS on primary database due to guaranteed restore points.\n38881. 00000 -  \"Cannot drop tablespace %s on primary database due to guaranteed restore points.\"\n*Cause:    An attempt was made to drop a tablespace on a primary database while there are guaranteed restore points. You cannot do this because Flashback database cannot undo dropping of a tablespace.\n*Action:   Drop all guaranteed restore points first and retry, or delay dropping the tablespace until all guaranteed restore points are removed.\n<\/code><\/pre>\n
So the syntax is accepted, but here I have another problem. I have a guaranteed restore point and this prevents the drop of tablespace.<\/p>\n
Let’s have a look at restore points because I didn’t create one (this is something were are not allowed to do on Exadata Express Cloud Service, which would be a nice feature as this servie is focused at developers).<\/p>\n
\nSQL> select * from v$restore_point;\n \nSCN          DATABASE_INCARNATION#  GUARANTEE_FLASHBACK_DATABASE  STORAGE_SIZE  TIME                             RESTORE_POINT_TIME  PRESERVED  NAME        PDB_RESTORE_POINT  CLEAN_PDB_RESTORE_POINT  PDB_INCARNATION#  CON_ID\n---          ---------------------  ----------------------------  ------------  ----                             ------------------  ---------  ----        -----------------  -----------------------  ----------------  ------\n84602869122  2                      YES                           18253611008   28-JAN-17 03.23.08.000000000 AM                      YES        PRE_17_1_2  NO                 NO                       0                 0\n<\/code><\/pre>\n
The PDB has been created when I subscribed to the service, on 22-JAN-17 and we are now 03-Feb-17.<\/p>\n
So it seems that the CDB administrator (it is a managed service, CDB DBA is Oracle) has created a restore point last Saturday.
\nThe name, PRE_17_1_7, looks like something we do before a maintenance, in case something goes wrong. I had no notification about any maintenance. And anyway, we usually remove the restore point as soon as possible because this fills the FRA.<\/p>\n
I can see somme CDB structures, such as the FRA:<\/p>\n
\nSQL> select * from v$recovery_area_usage;\n \nFILE_TYPE                PERCENT_SPACE_USED  PERCENT_SPACE_RECLAIMABLE  NUMBER_OF_FILES  CON_ID\n---------                ------------------  -------------------------  ---------------  ------\nCONTROL FILE             0                   0                          1                0\nREDO LOG                 0                   0                          0                0\nARCHIVED LOG             0.81                0.81                       193              0\nBACKUP PIECE             0.2                 0                          26               0\nIMAGE COPY               0.33                0                          10               0\nFLASHBACK LOG            1.3                 0.98                       41               0\nFOREIGN ARCHIVED LOG     0                   0                          0                0\nAUXILIARY DATAFILE COPY  0                   0                          0                0\n<\/code><\/pre>\n
Ok, that’s not too much. There is not a lot of activity during one week here. And anyway, FRA is big:<\/p>\n
\nSQL> show parameter recovery\n \nNAME                       TYPE        VALUE \n-------------------------- ----------- ----- \ndb_recovery_file_dest      string      +RECO \ndb_recovery_file_dest_size big integer 6T \n<\/code><\/pre>\n
So far so good, but I’m stuck here. The restore point is at CDB level, so I cannot drop it:<\/p>\n
\nSQL> drop restore point PRE_17_1_2;\n \ndrop restore point PRE_17_1_2\nError report -\nORA-38780: Restore point 'PRE_17_1_2' does not exist.\n38780. 00000 -  \"Restore point '%s' does not exist.\"\n*Cause:    The restore point name of the DROP RESTORE POINT command does not exist.\n*Action:   No action required.\n<\/code><\/pre>\n
This means that I cannot drop my tablespace. And I cannot even resize the datafiles to their minimum:<\/p>\n
\nSQL> alter database datafile '+DATA\/CFCDBA1\/46AB9829A44EB2C1E0538846220A6F7D\/DATAFILE\/iops.1455.934053351' resize 10M;\n \nalter database datafile '+DATA\/CFCDBA1\/46AB9829A44EB2C1E0538846220A6F7D\/DATAFILE\/iops.1455.934053351' resize 10M\nError report -\nORA-38883: Cannot shrink data file +DATA\/CFCDBA1\/46AB9829A44EB2C1E0538846220A6F7D\/DATAFILE\/iops.1455.934053351 on primary database due to guaranteed restore points.\n38883. 00000 -  \"Cannot shrink data file %s on primary database due to guaranteed restore points.\"\n*Cause:    An attempt was made to shrink a data file on a primary database while there are guaranteed restore points. You cannot do this because Flashback database cannot undo the shrinking of a data file.\n*Action:   Drop all guaranteed restore points first and retry, or delay the data file resize until all guaranteed restore points are removed.\n<\/code><\/pre>\n
I have an empty tablespace that takes all my allocated storage and I cannot remove it.<\/p>\n
So what to do? Try to contact support? Or fill the FRA until raises an alert?
\nI would try the first one but I received a CSI with my order, but it’s not a valid one…<\/p>\n
Update 04-FEB-17<\/h3>\n
After reaching an admin (not through the official support) the restore point has been dropped and we can now do what we are allowed to do: create and drop user tablespaces.<\/p>\n
\nSQL> drop tablespace iops including contents and datafiles;\nTablespace IOPS dropped.\n<\/code><\/pre>\n
and I’m now below the MAX_PDB_STORAGE<\/p>\n
\nSQL> select con_id,total_size\/power(1024,3) from v$pdbs;\n \nCON_ID  TOTAL_SIZE\/POWER(1024,3)  \n------  ------------------------\n47            10.175201416015625        \n<\/code><\/pre>\n
So what?<\/h3>\n
Because I am a DBA, I prefer a DBaaS service where I have full administration rights. And this is something very nice which you can found only on Oracle Cloud: even in PaaS you have full system access (root) and database access (sysdba). However, managed services like this PDBaaS Exadata Express Cloud Service can be very nice for non-admins. They can provision a PDB easily and have most of admin rights on them.<\/p>\n","protected":false},"excerpt":{"rendered":"
By Franck Pachot . The separation of roles between system DBA and application DBA is the way to go for agile development and the PDBaaS managed service is an excellent way to play with this concept: You are PDB administrator but not the CDB administrator. Here is an example about tablespace creation\/deletion, and the kind […]<\/p>\n","protected":false},"author":27,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[955,229],"tags":[220,135,103,64,96,66,223],"type_dbi":[],"class_list":["post-9750","post","type-post","status-publish","format-standard","hentry","category-cloud","category-database-administration-monitoring","tag-cdb","tag-cloud","tag-exadata","tag-multitenant","tag-oracle","tag-pdb","tag-pluggable-databases"],"acf":[],"yoast_head":"\nExadata Express Cloud Service: MAX_PDB_STORAGE - 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\/exadata-express-cloud-service-max_pdb_storage\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Exadata Express Cloud Service: MAX_PDB_STORAGE\" \/>\n<meta property=\"og:description\" content=\"By Franck Pachot . The separation of roles between system DBA and application DBA is the way to go for agile development and the PDBaaS managed service is an excellent way to play with this concept: You are PDB administrator but not the CDB administrator. Here is an example about tablespace creation\/deletion, and the kind […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/exadata-express-cloud-service-max_pdb_storage\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2017-02-03T21:06:13+00:00\" \/>\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=\"8 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\\\/exadata-express-cloud-service-max_pdb_storage\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/exadata-express-cloud-service-max_pdb_storage\\\/\"},\"author\":{\"name\":\"Oracle Team\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/66ab87129f2d357f09971bc7936a77ee\"},\"headline\":\"Exadata Express Cloud Service: MAX_PDB_STORAGE\",\"datePublished\":\"2017-02-03T21:06:13+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/exadata-express-cloud-service-max_pdb_storage\\\/\"},\"wordCount\":779,\"commentCount\":0,\"keywords\":[\"CDB\",\"Cloud\",\"Exadata\",\"multitenant\",\"Oracle\",\"PDB\",\"Pluggable Databases\"],\"articleSection\":[\"Cloud\",\"Database Administration & Monitoring\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/exadata-express-cloud-service-max_pdb_storage\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/exadata-express-cloud-service-max_pdb_storage\\\/\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/exadata-express-cloud-service-max_pdb_storage\\\/\",\"name\":\"Exadata Express Cloud Service: MAX_PDB_STORAGE - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\"},\"datePublished\":\"2017-02-03T21:06:13+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/66ab87129f2d357f09971bc7936a77ee\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/exadata-express-cloud-service-max_pdb_storage\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/exadata-express-cloud-service-max_pdb_storage\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/exadata-express-cloud-service-max_pdb_storage\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Exadata Express Cloud Service: MAX_PDB_STORAGE\"}]},{\"@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":"Exadata Express Cloud Service: MAX_PDB_STORAGE - 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\/exadata-express-cloud-service-max_pdb_storage\/","og_locale":"en_US","og_type":"article","og_title":"Exadata Express Cloud Service: MAX_PDB_STORAGE","og_description":"By Franck Pachot . The separation of roles between system DBA and application DBA is the way to go for agile development and the PDBaaS managed service is an excellent way to play with this concept: You are PDB administrator but not the CDB administrator. Here is an example about tablespace creation\/deletion, and the kind […]","og_url":"https:\/\/www.dbi-services.com\/blog\/exadata-express-cloud-service-max_pdb_storage\/","og_site_name":"dbi Blog","article_published_time":"2017-02-03T21:06:13+00:00","author":"Oracle Team","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Oracle Team","Est. reading time":"8 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/exadata-express-cloud-service-max_pdb_storage\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/exadata-express-cloud-service-max_pdb_storage\/"},"author":{"name":"Oracle Team","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"headline":"Exadata Express Cloud Service: MAX_PDB_STORAGE","datePublished":"2017-02-03T21:06:13+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/exadata-express-cloud-service-max_pdb_storage\/"},"wordCount":779,"commentCount":0,"keywords":["CDB","Cloud","Exadata","multitenant","Oracle","PDB","Pluggable Databases"],"articleSection":["Cloud","Database Administration & Monitoring"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/exadata-express-cloud-service-max_pdb_storage\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/exadata-express-cloud-service-max_pdb_storage\/","url":"https:\/\/www.dbi-services.com\/blog\/exadata-express-cloud-service-max_pdb_storage\/","name":"Exadata Express Cloud Service: MAX_PDB_STORAGE - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"datePublished":"2017-02-03T21:06:13+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/exadata-express-cloud-service-max_pdb_storage\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/exadata-express-cloud-service-max_pdb_storage\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/exadata-express-cloud-service-max_pdb_storage\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Exadata Express Cloud Service: MAX_PDB_STORAGE"}]},{"@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\/9750","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=9750"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/9750\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=9750"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=9750"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=9750"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=9750"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}