.
\nDo you think that online operations are available only on Enterprise Edition?
\nThat changed in 12c, there is an operation that is online (without the need for the ONLINE keyword) and available in Standard Edition and a very important feature for performance tuning: invisible indexes.
\n<\/p>\n
I’ll show it from the SCOTT schema where I’ve added an index on EMP(HIREDATE):<\/p>\n
\nSQL> info+ EMP\nTABLE: EMP\n LAST ANALYZED:\n ROWS :\n SAMPLE SIZE :\n INMEMORY :DISABLED\n COMMENTS :\n \nColumns\nNAME DATA TYPE NULL DEFAULT LOW_VALUE HIGH_VALUE NUM_DISTINCT HISTOGRAM\n---------- ------------------- ---- --------- ----------- ----------- ------------- ---------\n*EMPNO NUMBER(4,0) No\n ENAME VARCHAR2(10 BYTE) Yes\n JOB VARCHAR2(9 BYTE) Yes\n MGR NUMBER(4,0) Yes\n HIREDATE DATE Yes ..... .....\n SAL NUMBER(7,2) Yes\n COMM NUMBER(7,2) Yes\n DEPTNO NUMBER(2,0) Yes\n \nIndexes\nINDEX_NAME UNIQUENESS STATUS FUNCIDX_STATUS COLUMNS COLUMN_EXPRESSION\n------------------ ---------- ------ -------------- -------- -----------------\nSCOTT.PK_EMP UNIQUE VALID EMPNO\nSCOTT.EMP_HIREDATE NONUNIQUE VALID HIREDATE\n<\/code><\/pre>\nIf you don’t know where that ‘info+’ is coming from, then you should read about sqlcl<\/a>.<\/p>\nIt’s always good to remove unnecessary indexes<\/h1>\n
Ok, imagine that you think that this EMP_HIREDATE index is not useful. Do you drop it? Or the fear of unexpected regression wins against the will to clean up. If you drop it and you see a regression, then you will have to create it back. It can take a lot of time on a big table. Do you choose to create it offline, blocking everybody, but trying to have the index back as quickly as possible?
\nHow long will it take? Are you sure that you have enough temp space?<\/p>\n
Well, since 11g you have a very nice feature: invisible index. It’s still maintained but invisible to the optimizer. Just make the index invisible and if you see any regression you can bring it back in seconds. But are you sure of that? <\/p>\n
In 11g, ALTER INDEX VISIBLE requires an exclusive lock. It can be quick and nobody see it. But imagine that you have a lot of DML activity on the table, and on tables linked to it by referential integrity. That DML activity acquires Row-X locks. Your ALTER INDEX VISIBLE will wait. But it requests an exclusive lock. Then all new sessions that wants to have activity on those tables will be blocked. This is not good. Especially in that situation: if you want to bring back the index as visible, that’s probably because you had some performance problems. It not the right time to add lock issues…<\/p>\n
12c<\/h1>\n
In 12c, new feature, it’s online. which means that we don’t need any Share or Exclusive lock.
\nLet’s prove it.
\nI’m tracing sql_trace and enqueues<\/p>\n
\nSQL> alter session set events='10046 trace name context forever, level 1 : 10704 trace name context forever, level 3' tracefile_identifier='InvisibleIndex';\nSession altered.\n<\/code><\/pre>\nI have some queries using the index:<\/p>\n
\nSQL> select count(*) from EMP where HIREDATE>sysdate-1;\n \nCOUNT(*)\n--------\n0\n \nSQL> select * from table(dbms_xplan.display_cursor);\n \nPLAN_TABLE_OUTPUT\nSQL_ID gy8sag39zkrxr, child number 0\n-------------------------------------\nselect count(*) from EMP where HIREDATE>sysdate-1\n \nPlan hash value: 3798098543\n \n----------------------------------------------------------------------------------\n| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time |\n----------------------------------------------------------------------------------\n| 0 | SELECT STATEMENT | | | | 1 (100)| |\n| 1 | SORT AGGREGATE | | 1 | 9 | | |\n|* 2 | INDEX RANGE SCAN| EMP_HIREDATE | 1 | 9 | 1 (0)| 00:00:01 |\n----------------------------------------------------------------------------------\n \nPredicate Information (identified by operation id):\n---------------------------------------------------\n 2 - access(\"HIREDATE\">SYSDATE@!-1)\n<\/code><\/pre>\nthe query is here:<\/p>\n
\nSQL> select sql_id,child_number,invalidations,plan_hash_value from V$SQL where plan_hash_value=3798098543;\n \nSQL_ID CHILD_NUMBER INVALIDATIONS PLAN_HASH_VALUE\n------------- ------------ ------------- ---------------\ngy8sag39zkrxr 0 0 3,798,098,543\n<\/code><\/pre>\nBut I didn’t noticed it and think the index is not useful.
\nI minimize the risks: I make it invisible.<\/p>\n
\nSQL> alter index EMP_HIREDATE invisible;\n \nIndex EMP_HIREDATE altered.\n<\/code><\/pre>\nNow future queries are doing a full table scan:<\/p>\n
\nSQL> select count(*) from EMP where HIREDATE>sysdate-1;\n \nCOUNT(*)\n--------\n0\n \nSQL> select * from table(dbms_xplan.display_cursor);\n \nPLAN_TABLE_OUTPUT\nSQL_ID gy8sag39zkrxr, child number 0\n-------------------------------------\nselect count(*) from EMP where HIREDATE>sysdate-1\n \nPlan hash value: 2083865914\n \n---------------------------------------------------------------------------\n| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time |\n---------------------------------------------------------------------------\n| 0 | SELECT STATEMENT | | | | 3 (100)| |\n| 1 | SORT AGGREGATE | | 1 | 9 | | |\n|* 2 | TABLE ACCESS FULL| EMP | 1 | 9 | 3 (0)| 00:00:01 |\n---------------------------------------------------------------------------\n \nPredicate Information (identified by operation id):\n---------------------------------------------------\n 2 - filter(\"HIREDATE\">SYSDATE@!-1)\n<\/code><\/pre>\nWe see that the cursor has been invalidated:<\/p>\n
\nSQL> select sql_id,child_number,invalidations,plan_hash_value from V$SQL where sql_id='gy8sag39zkrxr';\n \nSQL_ID CHILD_NUMBER INVALIDATIONS PLAN_HASH_VALUE\n------------- ------------ ------------- ---------------\ngy8sag39zkrxr 0 1 2,083,865,914\n<\/code><\/pre>\nIf I have any issue with that, I can bring back the index visible:<\/p>\n
\nSQL> alter index EMP_HIREDATE visible;\n \nIndex EMP_HIREDATE altered.\n<\/code><\/pre>\nand after running the query again, I can check that the cursor has been invalidated again and is now using the range scan:<\/p>\n
\nSQL> select sql_id,child_number,invalidations,plan_hash_value from V$SQL where sql_id='gy8sag39zkrxr';\n \nSQL_ID CHILD_NUMBER INVALIDATIONS PLAN_HASH_VALUE\n------------- ------------ ------------- ---------------\ngy8sag39zkrxr 0 2 3,798,098,543\n<\/code><\/pre>\nIt’s online<\/h3>\n
Nothing new here if you know the 12c new features (and if you don’t we have a training<\/a> for that). But let’s stop the trace and grep the ‘get lock’ from the dump:<\/p>\n\nSQL> alter session set events='10046 trace name context off : 10704 trace name context off ';\n \nSession altered.\n<\/code><\/pre>\nI need the OBJECT_ID of my table in hexadecimal to find it in the dump:<\/p>\n
\nSQL> column object_id new_value object_id\nSQL> select object_name,to_char(object_id,'FM0XXXXXXX') object_id from dba_objects where owner='SCOTT';\n \nOBJECT_NAME OBJECT_ID\n------------ ---------\nPK_DEPT 0001677D\nDEPT 0001677C\nEMP 0001677E\nPK_EMP 0001677F\nBONUS 00016780\nSALGRADE 00016781\nEMP_HIREDATE 00016782\n<\/code><\/pre>\nGet the tracefile<\/p>\n
\nSQL> column tracefile new_value tracefile\nSQL> select tracefile from v$process where addr=(select paddr from v$session where sid=sys_context('USERENV','SID'));\n \nTRACEFILE\n------------------------------------------------------------------------\n\/u01\/app\/oracle\/diag\/rdbms\/se2\/SE2\/trace\/SE2_ora_6710_InvisibleIndex.trc\n \nSQL> host mv &tracefile last.trc\n<\/code><\/pre>\nand filter what I’m looking for: ‘get lock’ for my tables:<\/p>\n
\nhost grep -A 0 -E 'ksqgtl [*]{3} TM-000167|ksqrcl: TM-000167|ksqcnv: TM-000167|^alter' last.trc\nksqgtl *** TM-0001677E-00000000-00000003-00000000 mode=2 flags=0x400 timeout=0 ***\nalter index EMP_HIREDATE invisible\nksqrcl: TM-0001677E-00000000-00000003-00000000\nksqgtl *** TM-0001677E-00000000-00000003-00000000 mode=2 flags=0x400 timeout=0 ***\nalter index EMP_HIREDATE visible\nksqrcl: TM-0001677E-00000000-00000003-00000000\n<\/code><\/pre>\nThis is the proof that both statements require only the lowest table lock: mode=2 is Row-S which is compatible with all concurrent DML.
\nthis is an only operation. But there is more.<\/p>\n
It’s available in SE<\/h3>\n
Yes, I’m in Standard Edition here:<\/p>\n
\nSQL> exit\nDisconnected from Oracle Database 12c Standard Edition Release 12.1.0.2.0 - 64bit Production\n<\/code><\/pre>\n11g<\/h1>\n
If you want to see the behaviour in 11g:<\/p>\n
\nksqgtl *** TM-0001bf64-00000000 mode=6 flags=0x401 timeout=0 ***\nalter index EMP_HIREDATE invisible\nksqgtl *** TM-0001bf64-00000000 mode=6 flags=0x401 timeout=0 ***\nalter index EMP_HIREDATE visible\n<\/code><\/pre>\nmode=6 is exclusive lock. You don’t want to do that when DML is running, especially when you already have a problem to fix – and this is the goal of ALTER INDEX VISIBLE.<\/p>\n
DROP INDEX ONLINE<\/h1>\n
Still in the 12c new features, you can drop an index online, requiring only a Row-S lock on the table instead of eXclusive lock.
\nHere is the 10704 trace:<\/p>\n
\ndrop index EMP_HIREDATE online\nksqgtl *** TM-0001677E-00000000-00000003-00000000 mode=2 flags=0x400 timeout=0 ***\nksqrcl: TM-0001677E-00000000-00000003-00000000\nksqrcl: TM-0001677E-00000000-00000003-00000000\n<\/code><\/pre>\nAnd you know what? I’m still in Standard Edition.<\/p>\n
So what?<\/h1>\n
We can get rid of indexes that are not needed. We can make them invisible for a while and then drop them.
\nAnd we can do it online, even it Standard Edition.
\nHowever, be careful. Indexes are not used only by the optimizer. They serve as a structure to lock a range of values when you delete from a parent table, in order to prevent any current insert to become orphans. If you make the index invisible, they are still used for that. When you drop them, a table lock will be needed for those cases. More about that at #DOAG2015<\/a> or at #TECH15<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"By Franck Pachot . Do you think that online operations are available only on Enterprise Edition? That changed in 12c, there is an operation that is online (without the need for the ONLINE keyword) and available in Standard Edition and a very important feature for performance tuning: invisible indexes.<\/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":[229,59],"tags":[91,654,209,68],"type_dbi":[],"class_list":["post-5553","post","type-post","status-publish","format-standard","hentry","category-database-administration-monitoring","category-oracle","tag-index","tag-online","tag-oracle-12c","tag-standard-edition"],"acf":[],"yoast_head":"\n
Invisible indexes: it's online in 12c - even in Standard Edition - 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\/invisible-indexes-its-online-in-12c-even-in-standard-edition\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Invisible indexes: it's online in 12c - even in Standard Edition\" \/>\n<meta property=\"og:description\" content=\"By Franck Pachot . Do you think that online operations are available only on Enterprise Edition? That changed in 12c, there is an operation that is online (without the need for the ONLINE keyword) and available in Standard Edition and a very important feature for performance tuning: invisible indexes.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/invisible-indexes-its-online-in-12c-even-in-standard-edition\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2015-09-14T14:35:37+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=\"7 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\\\/invisible-indexes-its-online-in-12c-even-in-standard-edition\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/invisible-indexes-its-online-in-12c-even-in-standard-edition\\\/\"},\"author\":{\"name\":\"Oracle Team\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/66ab87129f2d357f09971bc7936a77ee\"},\"headline\":\"Invisible indexes: it’s online in 12c – even in Standard Edition\",\"datePublished\":\"2015-09-14T14:35:37+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/invisible-indexes-its-online-in-12c-even-in-standard-edition\\\/\"},\"wordCount\":768,\"commentCount\":0,\"keywords\":[\"index\",\"online\",\"Oracle 12c\",\"Standard Edition\"],\"articleSection\":[\"Database Administration & Monitoring\",\"Oracle\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/invisible-indexes-its-online-in-12c-even-in-standard-edition\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/invisible-indexes-its-online-in-12c-even-in-standard-edition\\\/\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/invisible-indexes-its-online-in-12c-even-in-standard-edition\\\/\",\"name\":\"Invisible indexes: it's online in 12c - even in Standard Edition - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\"},\"datePublished\":\"2015-09-14T14:35:37+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/66ab87129f2d357f09971bc7936a77ee\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/invisible-indexes-its-online-in-12c-even-in-standard-edition\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/invisible-indexes-its-online-in-12c-even-in-standard-edition\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/invisible-indexes-its-online-in-12c-even-in-standard-edition\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Invisible indexes: it’s online in 12c – even in Standard Edition\"}]},{\"@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":"Invisible indexes: it's online in 12c - even in Standard Edition - 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\/invisible-indexes-its-online-in-12c-even-in-standard-edition\/","og_locale":"en_US","og_type":"article","og_title":"Invisible indexes: it's online in 12c - even in Standard Edition","og_description":"By Franck Pachot . Do you think that online operations are available only on Enterprise Edition? That changed in 12c, there is an operation that is online (without the need for the ONLINE keyword) and available in Standard Edition and a very important feature for performance tuning: invisible indexes.","og_url":"https:\/\/www.dbi-services.com\/blog\/invisible-indexes-its-online-in-12c-even-in-standard-edition\/","og_site_name":"dbi Blog","article_published_time":"2015-09-14T14:35:37+00:00","author":"Oracle Team","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Oracle Team","Est. reading time":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/invisible-indexes-its-online-in-12c-even-in-standard-edition\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/invisible-indexes-its-online-in-12c-even-in-standard-edition\/"},"author":{"name":"Oracle Team","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"headline":"Invisible indexes: it’s online in 12c – even in Standard Edition","datePublished":"2015-09-14T14:35:37+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/invisible-indexes-its-online-in-12c-even-in-standard-edition\/"},"wordCount":768,"commentCount":0,"keywords":["index","online","Oracle 12c","Standard Edition"],"articleSection":["Database Administration & Monitoring","Oracle"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/invisible-indexes-its-online-in-12c-even-in-standard-edition\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/invisible-indexes-its-online-in-12c-even-in-standard-edition\/","url":"https:\/\/www.dbi-services.com\/blog\/invisible-indexes-its-online-in-12c-even-in-standard-edition\/","name":"Invisible indexes: it's online in 12c - even in Standard Edition - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"datePublished":"2015-09-14T14:35:37+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/invisible-indexes-its-online-in-12c-even-in-standard-edition\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/invisible-indexes-its-online-in-12c-even-in-standard-edition\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/invisible-indexes-its-online-in-12c-even-in-standard-edition\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Invisible indexes: it’s online in 12c – even in Standard Edition"}]},{"@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\/5553","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=5553"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/5553\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=5553"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=5553"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=5553"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=5553"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}