{"id":3562,"date":"2014-02-07T00:16:00","date_gmt":"2014-02-06T23:16:00","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/oracle-is-hanging-dont-forget-hanganalyze-and-systemstate\/"},"modified":"2014-02-07T00:16:00","modified_gmt":"2014-02-06T23:16:00","slug":"oracle-is-hanging-dont-forget-hanganalyze-and-systemstate","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/oracle-is-hanging-dont-forget-hanganalyze-and-systemstate\/","title":{"rendered":"Oracle is hanging? Don’t forget hanganalyze and systemstate!"},"content":{"rendered":"

By Franck Pachot<\/h2>\n

.<\/p>\n

sqlplus \/ as sysdba\n oradebug setmypid\n oradebug unlimit\n oradebug hanganalyze 3\n oradebug dump ashdumpseconds 30\n oradebug dump systemstate 266\n oradebug tracefile_name\n<\/code><\/pre>\n
Your Oracle database – production DB, of course – is hanging. All users are blocked. You quickly check the obvious suspects (archivelog destination full, system swapping, etc.) but it’s something else. Even you, the Oracle DBA, cannot do anything: any select is hanging. And maybe you’re even not able to connect with a simple ‘sqlplus \/ as sysdba’.<\/p>\n
What do you do ? There may be several ways to investigate deeper (strace or truss for example) but it will take time. And your boss is clear: the only important thing is to get the production running again as soon as possible. No time to investigate.\u00a0SHUTDOWN ABORT and restart.<\/p>\n
Ok, but now that everything is back to normal, your boss rules has changed: the system was down for 15 minutes. We have to provide an explanation. Root Cause Analysis.<\/p>\n
But how will you investigate now ? You have restarted everything, so all V$ information is gone. You have Diagnostic Pack ? But the system was hanged: no ASH information went to disk. You can open an SR but what information will you give?<\/p>\n
Hang Analyze<\/h3>\n
The next time it happens, you need to have a way to get some information that can be analyzed post mortem. But you need to be able to do that very quickly just before your boss shouts ‘shutdown abort now’. And this is why I’ve put it at the begining of the post, so that you can find it quickly if you need it…<\/p>\n
That takes only a few seconds to generate all post-mortem necessary information. If you can take 1 more minute, you will even be able to read the first lines of hanganalyze output, and you will be able to identify a true hanging situation and maybe just kill the root of the blocking sessions instead of a merciless restart.<\/p>\n
In order to show you the kind of output you get, I’ve run a few jobs locking the same resources (TM locks) – which is not a true hanging situation because the blocking session can resolve the situation.
\n 
\nHere is the first lines from the oradebug hanganalyze:<\/p>\n
Chains most likely to have caused the hang:\n [a] Chain 1 Signature: 'PL\/SQL lock timer'Systemstate has all information about System Objects (sessions, processes, ...) but you have to navigate into it in order to understand the wait chain. In my example:<\/code><\/pre>\n
SO: 0x914ada70, type: 4, owner: 0x91990478, flag: INIT\/-\/-\/0x00 if: 0x3 c: 0x3\n proc=0x91990478, name=session, file=ksu.h LINE:13580, pg=0 conuid=0\n(session) sid: 23 ser: 7 trans: 0x8ea8e3e8, creator: 0x91990478\n...\nservice name: SYS$USERS\nclient details:\nO\/S info: user: oracle, term: UNKNOWN, ospid: 7929\nmachine: vboxora12c program: oracle@vboxora12c (J002)\nCurrent Wait Stack:\n 0: waiting for 'enq: TM - contention'\n    name|mode=0x544d0003, object #=0x1737c, table\/partition=0x0\n    wait_id=10 seq_num=11 snap_id=1\n    wait times: snap=15.991474 sec, exc=15.991474 sec, total=15.991474 sec\n    wait times: max=40.000000 sec, heur=15.991474 sec\n    wait counts: calls=6 os=6\n    in_wait=1 iflags=0x15a0\nThere is at least one session blocking this session.\nDumping 1 direct blocker(s):\n  inst: 1, sid: 254, ser: 5\nDumping final blocker: inst: 1, sid: 256, ser: 5\nThis is a session that is waiting, and we have the final blocker: inst: 1, sid: 256, ser: 5<\/code><\/pre>\n
Then we get to the final blocker by searching the sid: 256:<\/p>\n
SO: 0x9168a408, type: 4, owner: 0x9198d058, flag: INIT\/-\/-\/0x00 if: 0x3 c: 0x3\n proc=0x9198d058, name=session, file=ksu.h LINE:13580, pg=0 conuid=0\n(session) sid: 256 ser: 5 trans: 0x8ea6b618, creator: 0x9198d058\n...\nservice name: SYS$USERS\nclient details:\nO\/S info: user: oracle, term: UNKNOWN, ospid: 7925\nmachine: vboxora12c program: oracle@vboxora12c (J000)\nCurrent Wait Stack:\n 0: waiting for 'PL\/SQL lock timer'\n    duration=0x0, =0x0, =0x0\n    wait_id=0 seq_num=1 snap_id=1\n    wait times: snap=25.936165 sec, exc=25.936165 sec, total=25.936165 sec\n    wait times: max=50.000000 sec, heur=25.936165 sec\n    wait counts: calls=1 os=9\n    in_wait=1 iflags=0x5a0\nThere are 5 sessions blocked by this session.\nDumping one waiter:\n  inst: 1, sid: 254, ser: 5\n  wait event: 'enq: TM - contention'\n    p1: 'name|mode'=0x544d0004\n    p2: 'object #'=0x1737c\n    p3: 'table\/partition'=0x0\n  row_wait_obj#: 95100, block#: 0, row#: 0, file# 0\n  min_blocked_time: 19 secs, waiter_cache_ver: 44\n<\/code><\/pre>\n
Analysing the System State takes much longer than the hanganalyze, but it has more information.<\/p>\n
V$WAIT_CHAINS<\/h3>\n
When the blocking situation is not so desesperate, but you just want to see what is blocking, the hanganalyze information is also available online in V$WAIT_CHAINS. The advantage over ASH is that you see all processes (not only foreground, not only active ones).<\/p>\n
Here is an example:<\/p>\n\n\n\n\n\n\n\n\n\n
CHAIN_ID<\/th>\nCHAIN<\/th>\nCHAIN_SIGNATURE<\/th>\nINSTANCE<\/th>\nOSID<\/th>\nPID<\/th>\nSID<\/th>\nBLOCK<\/th>\n<\/tr>\n
1<\/td>\nFALSE<\/td>\n‘PL\/SQL lock timer’ <=’enq: TM
\n– contention’ <=’enq: TM – contention’<\/td>\n		1<\/td>\n7929<\/td>\n42<\/td>\n23<\/td>\nTRUE<\/td>\n<\/tr>\n
1<\/td>\nFALSE<\/td>\n‘PL\/SQL lock timer’ <=’enq: TM
\n– contention’ <=’enq: TM – contention’<\/td>\n		1<\/td>\n7927<\/td>\n41<\/td>\n254<\/td>\nTRUE<\/td>\n<\/tr>\n
1<\/td>\nFALSE<\/td>\n‘PL\/SQL lock timer’ <=’enq: TM
\n– contention’ <=’enq: TM – contention’<\/td>\n		1<\/td>\n7925<\/td>\n39<\/td>\n256<\/td>\nFALSE<\/td>\n<\/tr>\n
2<\/td>\nFALSE<\/td>\n‘PL\/SQL lock timer’ <=’enq: TM
\n– contention’ <=’enq: TM – contention’<\/td>\n		1<\/td>\n7933<\/td>\n46<\/td>\n25<\/td>\nTRUE<\/td>\n<\/tr>\n
3<\/td>\nFALSE<\/td>\n‘PL\/SQL lock timer’ <=’enq: TM
\n– contention’ <=’enq: TM – contention’<\/td>\n		1<\/td>\n7931<\/td>\n45<\/td>\n260<\/td>\nTRUE<\/td>\n<\/tr>\n
4<\/td>\nFALSE<\/td>\n‘PL\/SQL lock timer’ <=’enq: TM
\n– contention’ <=’enq: TM – contention’<\/td>\n		1<\/td>\n7935<\/td>\n47<\/td>\n262<\/td>\nTRUE<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
ASH Dump<\/h3>\n
There is something else that you can get if you have Diagnostic Pack. The ASH information can be dumped to trace file even if it cannot be collected in the database.<\/p>\n
oradebug dump ashdumpseconds 30<\/code><\/pre>\n
that will gather ASH from latest 30 seconds, and the trace file will even have the sqlldr ctl file to load it in an ASH like table.<\/p>\n
sqlplus -prelim<\/h3>\n
But what can you do if you can’t even connect \/ as sysdba ?
\nThere is the ‘preliminary connection’ that does not create a session:<\/p>\n
sqlplus -prelim \/ as sysdba<\/code><\/pre>\n
With that you will be able to get a systemstate. You will be able to get a ashdump.
\nBut unfortunately, since 11.2.0.2 you cannot get a hanganalyze:<\/p>\n
ERROR: Can not perform hang analysis dump without a process state object and a session state object.\n<\/code><\/pre>\n
But there is a workaround for that (from Tanel Poders’s blog): try to use a session that is already connected.<\/p>\n
For exemple I use the DIAG background process (it’s better not to use vital processes for that)<\/p>\n
SQL> oradebug setorapname diag\nOracle pid: 8, Unix process pid: 7805, image: oracle@vboxora12c (DIAG)\n<\/code><\/pre>\n
Core message<\/h3>\n
Even in hurry,<\/p>\n
    \n
  • Always check an hanganalyze to understand the problem.<\/li>\n
  • Always get a systemstate before a shutdown abort.<\/li>\n<\/ul>\n
    and you will have information to investigate later, or to provide to Oracle Support.<\/p>\n","protected":false},"excerpt":{"rendered":"
    By Franck Pachot . sqlplus \/ as sysdba oradebug setmypid oradebug unlimit oradebug hanganalyze 3 oradebug dump ashdumpseconds 30 oradebug dump systemstate 266 oradebug tracefile_name Your Oracle database – production DB, of course – is hanging. All users are blocked. You quickly check the obvious suspects (archivelog destination full, system swapping, etc.) but it’s something […]<\/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":[198,59],"tags":[427,17,209,428,44],"type_dbi":[],"class_list":["post-3562","post","type-post","status-publish","format-standard","hentry","category-database-management","category-oracle","tag-hanganalyze","tag-oracle-11g","tag-oracle-12c","tag-systemstate","tag-troubleshooting"],"acf":[],"yoast_head":"\nOracle is hanging? Don't forget hanganalyze and systemstate! - dbi Blog<\/title>\n<meta name=\"description\" content=\"Your Oracle database - production DB, of course - is hanging. All users are blocked. You quickly check the obvious suspects (archivelog destination full, system swapping, etc.) but it's something else. Even you, the Oracle DBA, cannot do anything: any select is hanging. And maybe you're even not able to connect with a simple 'sqlplus \/ as sysdba'.\" \/>\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-is-hanging-dont-forget-hanganalyze-and-systemstate\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Oracle is hanging? Don't forget hanganalyze and systemstate!\" \/>\n<meta property=\"og:description\" content=\"Your Oracle database - production DB, of course - is hanging. All users are blocked. You quickly check the obvious suspects (archivelog destination full, system swapping, etc.) but it's something else. Even you, the Oracle DBA, cannot do anything: any select is hanging. And maybe you're even not able to connect with a simple 'sqlplus \/ as sysdba'.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/oracle-is-hanging-dont-forget-hanganalyze-and-systemstate\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2014-02-06T23:16:00+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=\"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-is-hanging-dont-forget-hanganalyze-and-systemstate\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-is-hanging-dont-forget-hanganalyze-and-systemstate\/\"},\"author\":{\"name\":\"Oracle Team\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\"},\"headline\":\"Oracle is hanging? Don’t forget hanganalyze and systemstate!\",\"datePublished\":\"2014-02-06T23:16:00+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-is-hanging-dont-forget-hanganalyze-and-systemstate\/\"},\"wordCount\":734,\"commentCount\":0,\"keywords\":[\"Hanganalyze\",\"Oracle 11g\",\"Oracle 12c\",\"Systemstate\",\"Troubleshooting\"],\"articleSection\":[\"Database management\",\"Oracle\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/oracle-is-hanging-dont-forget-hanganalyze-and-systemstate\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-is-hanging-dont-forget-hanganalyze-and-systemstate\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/oracle-is-hanging-dont-forget-hanganalyze-and-systemstate\/\",\"name\":\"Oracle is hanging? Don't forget hanganalyze and systemstate! - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"datePublished\":\"2014-02-06T23:16:00+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\"},\"description\":\"Your Oracle database - production DB, of course - is hanging. All users are blocked. You quickly check the obvious suspects (archivelog destination full, system swapping, etc.) but it's something else. Even you, the Oracle DBA, cannot do anything: any select is hanging. And maybe you're even not able to connect with a simple 'sqlplus \/ as sysdba'.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-is-hanging-dont-forget-hanganalyze-and-systemstate\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/oracle-is-hanging-dont-forget-hanganalyze-and-systemstate\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-is-hanging-dont-forget-hanganalyze-and-systemstate\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Oracle is hanging? Don’t forget hanganalyze and systemstate!\"}]},{\"@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 is hanging? Don't forget hanganalyze and systemstate! - dbi Blog","description":"Your Oracle database - production DB, of course - is hanging. All users are blocked. You quickly check the obvious suspects (archivelog destination full, system swapping, etc.) but it's something else. Even you, the Oracle DBA, cannot do anything: any select is hanging. And maybe you're even not able to connect with a simple 'sqlplus \/ as sysdba'.","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-is-hanging-dont-forget-hanganalyze-and-systemstate\/","og_locale":"en_US","og_type":"article","og_title":"Oracle is hanging? Don't forget hanganalyze and systemstate!","og_description":"Your Oracle database - production DB, of course - is hanging. All users are blocked. You quickly check the obvious suspects (archivelog destination full, system swapping, etc.) but it's something else. Even you, the Oracle DBA, cannot do anything: any select is hanging. And maybe you're even not able to connect with a simple 'sqlplus \/ as sysdba'.","og_url":"https:\/\/www.dbi-services.com\/blog\/oracle-is-hanging-dont-forget-hanganalyze-and-systemstate\/","og_site_name":"dbi Blog","article_published_time":"2014-02-06T23:16:00+00:00","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-is-hanging-dont-forget-hanganalyze-and-systemstate\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-is-hanging-dont-forget-hanganalyze-and-systemstate\/"},"author":{"name":"Oracle Team","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"headline":"Oracle is hanging? Don’t forget hanganalyze and systemstate!","datePublished":"2014-02-06T23:16:00+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-is-hanging-dont-forget-hanganalyze-and-systemstate\/"},"wordCount":734,"commentCount":0,"keywords":["Hanganalyze","Oracle 11g","Oracle 12c","Systemstate","Troubleshooting"],"articleSection":["Database management","Oracle"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/oracle-is-hanging-dont-forget-hanganalyze-and-systemstate\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/oracle-is-hanging-dont-forget-hanganalyze-and-systemstate\/","url":"https:\/\/www.dbi-services.com\/blog\/oracle-is-hanging-dont-forget-hanganalyze-and-systemstate\/","name":"Oracle is hanging? Don't forget hanganalyze and systemstate! - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"datePublished":"2014-02-06T23:16:00+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"description":"Your Oracle database - production DB, of course - is hanging. All users are blocked. You quickly check the obvious suspects (archivelog destination full, system swapping, etc.) but it's something else. Even you, the Oracle DBA, cannot do anything: any select is hanging. And maybe you're even not able to connect with a simple 'sqlplus \/ as sysdba'.","breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-is-hanging-dont-forget-hanganalyze-and-systemstate\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/oracle-is-hanging-dont-forget-hanganalyze-and-systemstate\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/oracle-is-hanging-dont-forget-hanganalyze-and-systemstate\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Oracle is hanging? Don’t forget hanganalyze and systemstate!"}]},{"@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\/3562","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=3562"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/3562\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=3562"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=3562"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=3562"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=3562"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}