{"id":2251,"date":"2011-08-04T12:33:00","date_gmt":"2011-08-04T10:33:00","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/oracle-space-management-a-recycle-bin\/"},"modified":"2011-08-04T12:33:00","modified_gmt":"2011-08-04T10:33:00","slug":"oracle-space-management-a-recycle-bin","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/oracle-space-management-a-recycle-bin\/","title":{"rendered":"Oracle space management & recycle bin"},"content":{"rendered":"

This post describes some basic Oracle database management issues database administrators might be confronted with. It is about space management and differences observed while monitoring the available space from several point of views (tablespace\/datafile) in Grid Control 11g. It also relates and explains an issue (ORA-01652) observed on pre 11.2 Oracle releases (targets) concerning the tablespace\/datafile space management and the recycle bin.<\/p>\n

First of all, a simple example: let’s check the used and available space in a tablespace (e. g. a Grid 11g repository database):<\/p>\n

\"\"<\/p>\n

Let\u2019s focus on the MGMT_AD4J_TF tablespace which is not automatically extensible (\u201cAuto Extend\u201d : NO) since the unique datafile has been set on \u201cautoextend off\u201d:<\/p>\n

SQL> alter database datafile '\/u01\/oradata\/GRIDREP\/mgmt_ad4j.dbf' autoextend off;\n\u00a0\nDatabase altered.<\/pre>\n
As for the tablespace, the datafile, has of course also 24.3 MB of used size (see the \u201cdatafile\u201d view in the grid below):<\/p>\n
\"\"<\/p>\n
In order to see the space allocation, you simply need to create a table \u201cNEW_TABLE\u201d with the following statement, connected as \u201cSYSTEM\u201d (simply join two existing tables\/views in order to create a \u201csignificant\u201d table):<\/p>\n
SQL> create table new_table tablespace MGMT_AD4J_TS as select * from v$parameter, user_tables;\nTable created.<\/pre>\n
As expected, the used space at datafile and tablespace level climbed up to 47.3 MB (focus on MGMT_AD4J_TS):<\/p>\n
\"\"<\/p>\n
The datafile view reports the same value.
\nIf we now drop the table \u201cNEW_TABLE\u201d we will see the used space which will reduce at tablespace level:<\/p>\n
SQL> drop table new_table;\nTable dropped.<\/pre>\n<\/div>\n
We go back to 23.4 MB used for MGMT_AD4J_TS:<\/p>\n
\"\"<\/p>\n
However at datafile level, the Grid Control still shows 47.3 MB of used size:<\/p>\n
\"\"<\/p>\n
Oracle is not giving the space back to the datafile?
\nNo, in fact, the table NEW_TABLE has not been removed but was put in the reclycle bin:<\/p>\n
SQL> select SEGMENT_NAME,TABLESPACE_NAME,BYTES from dba_segments where segment_name like 'BIN%';\n\u00a0\nSEGMENT_NAME\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 TABLESPACE_NAME\u00a0\u00a0\u00a0 BYTES\n------------------------------\u00a0 ---------------\u00a0\u00a0\u00a0 ---------\nBIN$p4pKihyEmcXgQLQKRoE88A==$0\u00a0 MGMT_AD4J_TS\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 24117248\n\u00a0\nSQL> select OBJECT_NAME,ORIGINAL_NAME,TS_NAME,CAN_PURGE,SPACE from recyclebin where OBJECT_NAME = 'BIN$p4pKihyEmcXgQLQKRoE88A==$0';\n\u00a0\nOBJECT_NAME\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 ORIGINAL_NAME\u00a0 TS_NAME\u00a0\u00a0\u00a0\u00a0\u00a0 CAN\u00a0 SPACE\n---------------------------------------------------------------\nBIN$p4pKihyEmcXgQLQ....\u00a0 NEW_TABLE\u00a0\u00a0\u00a0\u00a0\u00a0 MGMT_AD4J_TS YES\u00a0\u00a0 2944<\/pre>\n<\/div>\n
The segment for the recycle bin object is in the tablespace MGMT_AD4J_TS itself.<\/p>\n
Now, let\u2019s create a much bigger object in the tablespace and observe the tablespace\/datafile used space. The following \u201ccreate table\u201d statement creates such a \u201cbig\u201d table:<\/p>\n
\n
SQL> create table new_table_2 tablespace MGMT_AD4J_TS as select * from v$parameter, dba_tables;\nTable created.<\/pre>\n<\/div>\n
As expected, the used space at tablespace level climbed up to 384.3 MB:<\/p>\n
\"\"<\/p>\n
We have a slight difference with the space reported at datafile level, since the datafile still contains the recycle bin object of the removed table (\u201cNEW_TABLE\u201d), therefore the consumption is 407.3 MB and not 384.3 as for the tablespace:<\/p>\n
\"\"<\/p>\n
We can now delete this large object (with \u201cdrop table\u201d) and observe the used space. At tablespace level the space has been given back (as free space):<\/p>\n
\"\"<\/p>\n
At datafile level, we are still using 407.31 MB!<\/p>\n
\"\"<\/p>\n
This is due to the Recycle Bin segments:<\/p>\n
\n
SQL> select SEGMENT_NAME,TABLESPACE_NAME,BYTES from dba_segments where segment_name like 'BIN%';\n\u00a0\nSEGMENT_NAME\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 TABLESPACE_NAME\u00a0\u00a0 BYTES\n-------------------------------------------------------------\nBIN$p4pKihyMmcXgQLQKRoE88A==$0 MGMT_AD4J_TS\u00a0\u00a0\u00a0\u00a0\u00a0 377487360\nBIN$p4pKihyJmcXgQLQKRoE88A==$0 MGMT_AD4J_TS\u00a0\u00a0\u00a0\u00a0\u00a0 24117248<\/pre>\n<\/div>\n
How does Oracle handle this situation?<\/p>\n
Can we create a new large object in this tablespace which will be 377 MB big, even if 143 MB only are available in the datafile (but 525MB are free at tablespace level)?<\/p>\n
Let\u2019s try.<\/p>\n
\n
SQL> create table new_table_3 tablespace MGMT_AD4J_TS\n\u00a0\u00a0\u00a0\u00a0 as select * from v$parameter, dba_tables;\n\u00a0\nTable created.<\/pre>\n<\/div>\n
As you can see, the object has been successfully created.<\/p>\n
What happened with the Recycle bin? Since Oracle had to create the tablespace with this new object, it decided to automatically purge the recycle bin during the creation of the new table to get the required space, therefore we have no more objects in the recycle bin:<\/p>\n
SQL> select SEGMENT_NAME,TABLESPACE_NAME,BYTES \n\u00a0\u00a0\u00a0\u00a0 from dba_segments where segment_name like 'BIN%';\n\u00a0\nno rows selected<\/pre>\n
Bug causing ORA-01652<\/strong><\/p>\n
Note however that in Oracle releases before 11.2 (any release might be affected), a bug occurred in this situation (tablespace full filled with Recycle Bin segments). The creation of new segments was not prevented but the following error occurred in the alert.log file:<\/p>\n
ORA-01652: unable to extend temp segment by 8 in tablespace TBS1
\nMon Jul 4 16:25:40 2011
\nErrors in file \/u00\/app\/oracle\/admin\/DB1\/udump\/chtx2_ora_27533.trc:
\nORA-01652: unable to extend temp segment by 8 in tablespace TBS1
\nMon Jul 4 16:34:47 2011<\/span><\/p>\n
This bug is referenced by the Oracle Support Note 6977045.8. If you are confronted with this bug, you have to follow one of these workarounds:<\/p>\n
    \n
  • Turn off the recycle bin by setting the Oracle init parameter \u201crecyclebin = off\u201d in the spfile
    \nor<\/li>\n
  • Purge the recycle bin regularly, for instance each day or week using the \u201cpurge recyclebin\u201d SQL statement<\/li>\n<\/ul>\n
    Note that, unfortunately, Grid Control 11g has no possibility to control the size of the recycle bin and does not even have a metric to monitor the recycle bin size.<\/p>\n","protected":false},"excerpt":{"rendered":"
    This post describes some basic Oracle database management issues database administrators might be confronted with. It is about space management and differences observed while monitoring the available space from several point of views (tablespace\/datafile) in Grid Control 11g. It also relates and explains an issue (ORA-01652) observed on pre 11.2 Oracle releases (targets) concerning the […]<\/p>\n","protected":false},"author":9,"featured_media":2252,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[198],"tags":[23,258,17,278,36],"type_dbi":[],"class_list":["post-2251","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database-management","tag-dba","tag-grid","tag-oracle-11g","tag-oracle-support","tag-tablespaces"],"acf":[],"yoast_head":"\nOracle space management & recycle bin - dbi Blog<\/title>\n<meta name=\"description\" content=\"Some basic Oracle database management issues (ORA-01652) database administrators (DBAs) might be confronted with.\" \/>\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-space-management-a-recycle-bin\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Oracle space management & recycle bin\" \/>\n<meta property=\"og:description\" content=\"Some basic Oracle database management issues (ORA-01652) database administrators (DBAs) might be confronted with.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/oracle-space-management-a-recycle-bin\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2011-08-04T10:33:00+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/i1.gif\" \/>\n\t<meta property=\"og:image:width\" content=\"702\" \/>\n\t<meta property=\"og:image:height\" content=\"238\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Yann Neuhaus\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Yann Neuhaus\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 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-space-management-a-recycle-bin\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/oracle-space-management-a-recycle-bin\\\/\"},\"author\":{\"name\":\"Yann Neuhaus\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/5bfc203607127a4915b7950c4a108681\"},\"headline\":\"Oracle space management & recycle bin\",\"datePublished\":\"2011-08-04T10:33:00+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/oracle-space-management-a-recycle-bin\\\/\"},\"wordCount\":681,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/oracle-space-management-a-recycle-bin\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/04\\\/i1.gif\",\"keywords\":[\"DBA\",\"Grid\",\"Oracle 11g\",\"Oracle support\",\"Tablespaces\"],\"articleSection\":[\"Database management\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/oracle-space-management-a-recycle-bin\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/oracle-space-management-a-recycle-bin\\\/\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/oracle-space-management-a-recycle-bin\\\/\",\"name\":\"Oracle space management & recycle bin - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/oracle-space-management-a-recycle-bin\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/oracle-space-management-a-recycle-bin\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/04\\\/i1.gif\",\"datePublished\":\"2011-08-04T10:33:00+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/5bfc203607127a4915b7950c4a108681\"},\"description\":\"Some basic Oracle database management issues (ORA-01652) database administrators (DBAs) might be confronted with.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/oracle-space-management-a-recycle-bin\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/oracle-space-management-a-recycle-bin\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/oracle-space-management-a-recycle-bin\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/04\\\/i1.gif\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/04\\\/i1.gif\",\"width\":702,\"height\":238},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/oracle-space-management-a-recycle-bin\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Oracle space management & recycle bin\"}]},{\"@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\\\/5bfc203607127a4915b7950c4a108681\",\"name\":\"Yann Neuhaus\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/d2729b4bbf77b0fe6f6d2b9fb1b2686404c89a16ce2701e860bfd1406212f796?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/d2729b4bbf77b0fe6f6d2b9fb1b2686404c89a16ce2701e860bfd1406212f796?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/d2729b4bbf77b0fe6f6d2b9fb1b2686404c89a16ce2701e860bfd1406212f796?s=96&d=mm&r=g\",\"caption\":\"Yann Neuhaus\"},\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/author\\\/yann-neuhaus\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Oracle space management & recycle bin - dbi Blog","description":"Some basic Oracle database management issues (ORA-01652) database administrators (DBAs) might be confronted with.","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-space-management-a-recycle-bin\/","og_locale":"en_US","og_type":"article","og_title":"Oracle space management & recycle bin","og_description":"Some basic Oracle database management issues (ORA-01652) database administrators (DBAs) might be confronted with.","og_url":"https:\/\/www.dbi-services.com\/blog\/oracle-space-management-a-recycle-bin\/","og_site_name":"dbi Blog","article_published_time":"2011-08-04T10:33:00+00:00","og_image":[{"width":702,"height":238,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/i1.gif","type":"image\/jpeg"}],"author":"Yann Neuhaus","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Yann Neuhaus","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/oracle-space-management-a-recycle-bin\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-space-management-a-recycle-bin\/"},"author":{"name":"Yann Neuhaus","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/5bfc203607127a4915b7950c4a108681"},"headline":"Oracle space management & recycle bin","datePublished":"2011-08-04T10:33:00+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-space-management-a-recycle-bin\/"},"wordCount":681,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-space-management-a-recycle-bin\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/i1.gif","keywords":["DBA","Grid","Oracle 11g","Oracle support","Tablespaces"],"articleSection":["Database management"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/oracle-space-management-a-recycle-bin\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/oracle-space-management-a-recycle-bin\/","url":"https:\/\/www.dbi-services.com\/blog\/oracle-space-management-a-recycle-bin\/","name":"Oracle space management & recycle bin - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-space-management-a-recycle-bin\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-space-management-a-recycle-bin\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/i1.gif","datePublished":"2011-08-04T10:33:00+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/5bfc203607127a4915b7950c4a108681"},"description":"Some basic Oracle database management issues (ORA-01652) database administrators (DBAs) might be confronted with.","breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-space-management-a-recycle-bin\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/oracle-space-management-a-recycle-bin\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/oracle-space-management-a-recycle-bin\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/i1.gif","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/i1.gif","width":702,"height":238},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/oracle-space-management-a-recycle-bin\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Oracle space management & recycle bin"}]},{"@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\/5bfc203607127a4915b7950c4a108681","name":"Yann Neuhaus","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/d2729b4bbf77b0fe6f6d2b9fb1b2686404c89a16ce2701e860bfd1406212f796?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/d2729b4bbf77b0fe6f6d2b9fb1b2686404c89a16ce2701e860bfd1406212f796?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/d2729b4bbf77b0fe6f6d2b9fb1b2686404c89a16ce2701e860bfd1406212f796?s=96&d=mm&r=g","caption":"Yann Neuhaus"},"url":"https:\/\/www.dbi-services.com\/blog\/author\/yann-neuhaus\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/2251","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\/9"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=2251"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/2251\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/2252"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=2251"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=2251"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=2251"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=2251"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}