{"id":12123,"date":"2018-12-03T09:50:55","date_gmt":"2018-12-03T08:50:55","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/oem-13c-repository-view-gcmetric_values_daily\/"},"modified":"2018-12-03T09:50:55","modified_gmt":"2018-12-03T08:50:55","slug":"oem-13c-repository-view-gcmetric_values_daily","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/oem-13c-repository-view-gcmetric_values_daily\/","title":{"rendered":"OEM 13c Repository view gc$metric_values_daily"},"content":{"rendered":"

Oracle OEM 13c offers the possibility to generate reports about Oracle Database Tablespace Monthly Space Usage. The displayed information is quite useful and display a lot of information:<\/p>\n

\"Screen<\/a><\/p>\n

 <\/p>\n

\"Screen<\/a><\/p>\n

 <\/p>\n

The report displays the details for each month and for each tablespace, but the GUI is sometimes painful: you have a nice report but many tablespaces and many numbers :=(<\/p>\n

At a client\u2019s site, I had the following behavior: a production database had its data files distributed across three file system \/u01 \/u01 and \/u03. And I wanted to know the evolution of the data files available size for each disk.<\/p>\n

My first idea was to write sql requests querying the tablespace history view dba_hist_tbspc_space_usage, but this view does not contain any information about the file system, and as a consequence it is not possible to know how much space will be needed by each file system in the future.<\/p>\n

OEM 13c offers the capability of viewing graphs for most of the metrics within OEM, but forecasting and trending capabilities are not present, and most of the category of metrics are set up for real time alerting, not for historical trending.<\/p>\n

And I did not find any views like dba_hist_datafiles_space_usage :=)<\/p>\n

So I checked in EM13c to verify that the file system space usage is correctly monitored. Naturally each file system is monitored and triggers a warning when the available space is below 20%, or a critical alert when it is below 5%.<\/p>\n

As a consequence I had the idea to query the OEM 13c repository views, and this was the good solution.<\/p>\n

At first we can query the mgmt.$alert_current to display the alerts generated on the metric_name Filesystems over target of type host:<\/p>\n

SQL> select target_name , target_type, metric_name, metric_column, column_label,alert_state, violation_level\n  2  FROM MGMT$ALERT_CURRENT\n  3  where metric_name ='Filesystems'\n  4  and target_guid in (SELECT target_guid\n  5  FROM mgmt$target\n  6* WHERE target_type ='host');\n\nem13c.localdomain\nhost\nFilesystems\npctAvailable\nFilesystem Space Available (%)\nWarning \t\t\t20\n\n<\/pre>\n
There is a lot of management repository views providing access to target, metrics and monitoring information stored in the Management Repository. Those views offer the possibility to create your own scripts to query historical data from those views.<\/p>\n
In my case I used the gc$metric_values_daily view corresponding to the data in the EM_METRIC_VALUES_DAILY table:<\/p>\n
SQL> desc gc$metric_values_daily\n Name\t\t\t\t\t   Null?    Type\n ----------------------------------------- -------- ----------------------------\n ENTITY_TYPE\t\t\t\t   NOT NULL VARCHAR2(64)\n ENTITY_NAME\t\t\t\t   NOT NULL VARCHAR2(256)\n ENTITY_GUID\t\t\t\t   NOT NULL RAW(16)\n PARENT_ME_TYPE \t\t\t\t    VARCHAR2(64)\n PARENT_ME_NAME \t\t\t\t    VARCHAR2(256)\n PARENT_ME_GUID \t\t\t   NOT NULL RAW(16)\n TYPE_META_VER\t\t\t\t   NOT NULL VARCHAR2(8)\n METRIC_GROUP_NAME\t\t\t   NOT NULL VARCHAR2(64)\n METRIC_COLUMN_NAME\t\t\t   NOT NULL VARCHAR2(64)\n COLUMN_TYPE\t\t\t\t   NOT NULL NUMBER(1)\n COLUMN_INDEX\t\t\t\t   NOT NULL NUMBER(3)\n DATA_COLUMN_TYPE\t\t\t   NOT NULL NUMBER(2)\n METRIC_GROUP_ID\t\t\t   NOT NULL NUMBER(38)\n METRIC_GROUP_LABEL\t\t\t\t    VARCHAR2(64)\n METRIC_GROUP_LABEL_NLSID\t\t\t    VARCHAR2(64)\n METRIC_COLUMN_ID\t\t\t   NOT NULL NUMBER(38)\n METRIC_COLUMN_LABEL\t\t\t\t    VARCHAR2(64)\n METRIC_COLUMN_LABEL_NLSID\t\t\t    VARCHAR2(64)\n DESCRIPTION\t\t\t\t\t    VARCHAR2(1024)\n SHORT_NAME\t\t\t\t\t    VARCHAR2(40)\n UNIT\t\t\t\t\t\t    VARCHAR2(64)\n IS_FOR_SUMMARY \t\t\t\t    NUMBER\n IS_STATEFUL\t\t\t\t\t    NUMBER\n NON_THRESHOLDED_ALERTS \t\t\t    NUMBER\n METRIC_KEY_ID\t\t\t\t   NOT NULL NUMBER(38)\n KEY_PART_1\t\t\t\t   NOT NULL VARCHAR2(256)\n KEY_PART_2\t\t\t\t   NOT NULL VARCHAR2(256)\n KEY_PART_3\t\t\t\t   NOT NULL VARCHAR2(256)\n KEY_PART_4\t\t\t\t   NOT NULL VARCHAR2(256)\n KEY_PART_5\t\t\t\t   NOT NULL VARCHAR2(256)\n KEY_PART_6\t\t\t\t   NOT NULL VARCHAR2(256)\n KEY_PART_7\t\t\t\t   NOT NULL VARCHAR2(256)\n COLLECTION_TIME\t\t\t   NOT NULL DATE\n COLLECTION_TIME_UTC\t\t\t\t    DATE\n COUNT_OF_COLLECTIONS\t\t\t   NOT NULL NUMBER(38)\n AVG_VALUE\t\t\t\t\t    NUMBER\n MIN_VALUE\t\t\t\t\t    NUMBER\n MAX_VALUE\t\t\t\t\t    NUMBER\n STDDEV_VALUE\t\t\t\t\t    NUMBER\n\n<\/pre>\n
The main column signification:<\/p>\n\n\n\n\n\n\n\n\n\n\n\n\n
ENTITY_TYPE<\/td>\nThe type of the target. Host, oracle_database<\/td>\n<\/tr>\n
ENTITY_NAME<\/td>\nThe target or component name for example the hostname<\/td>\n<\/tr>\n
METRIC_GROUP_NAME<\/td>\nName of the metric group for example filesystems<\/td>\n<\/tr>\n
METRIC_COLUMN_NAME<\/td>\nName of the metric column for example available, pct<\/td>\n<\/tr>\n
KEY_PART_1<\/td>\nKey part 1 of composite key for example name of the file system<\/td>\n<\/tr>\n
KEY_PART_2<\/td>\nKey part 2 of composite key<\/td>\n<\/tr>\n
COLLECTION_TIME<\/td>\nCollection time in target time zone<\/td>\n<\/tr>\n
AVG_VALUE<\/td>\nAverage value of metric for the day<\/td>\n<\/tr>\n
MIN_VALUE<\/td>\nMinimum value of metric for the day<\/td>\n<\/tr>\n
MAX_VALUE<\/td>\nMaximum value of metric for the day<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
So in my case I only have to execute the following SQL request:<\/p>\n
select entity_name, \nkey_part_1,\ncollection_time, \navg_value as avg, \navg_value\/1000000 as percent  from gc$metric_values_daily\nwhere metric_group_name='Filesystems' \nand metric_column_name= 'available' \nand key_part_1='\/u01' \nand entity_name ='oraprod.com'\norder by 1,2\n\/\n\noraprod.com     \/u01          04-OCT-16  169545.44  \t.380928435\noraprod.com     \/u01          05-OCT-16  169572.44\t    .380928435\noraprod.com     \/u01          06-OCT-16  169583.44\t    .380928435\n\u2026\noraprod.com     \/u01           17-NOV-18  169538.44 \t.172295163\noraprod.com     \/u01           18-NOV-18  169538.44 \t.172295163\noraprod.com     \/u01           19-NOV-18  169525.94 \t.172282459\noraprod.com     \/u01           20-NOV-18  169498.44 \t.172254512<\/pre>\n
With this result I can easily know how much space is consumed by each file system during the time. We can use Excel\u2019s capabilities to determine the trend of the file system available size.<\/p>\n
Conclusion:<\/p>\n
We often forget that OEM is not only a graphical administration tool, the main interesting part of OEM is that OEM stores date at regular intervals for important metrics into the management repository. If you understand the management repository views structure, you will have extraordinary possibilities to extract historical data, build graphs in order to analyze more precisely your infrastructure.<\/p>\n","protected":false},"excerpt":{"rendered":"
Oracle OEM 13c offers the possibility to generate reports about Oracle Database Tablespace Monthly Space Usage. The displayed information is quite useful and display a lot of information:     The report displays the details for each month and for each tablespace, but the GUI is sometimes painful: you have a nice report but many […]<\/p>\n","protected":false},"author":27,"featured_media":12124,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[229],"tags":[215],"type_dbi":[],"class_list":["post-12123","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database-administration-monitoring","tag-oracle-enterprise-manager"],"acf":[],"yoast_head":"\nOEM 13c Repository view gc$metric_values_daily - 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\/oem-13c-repository-view-gcmetric_values_daily\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"OEM 13c Repository view gc$metric_values_daily\" \/>\n<meta property=\"og:description\" content=\"Oracle OEM 13c offers the possibility to generate reports about Oracle Database Tablespace Monthly Space Usage. The displayed information is quite useful and display a lot of information:     The report displays the details for each month and for each tablespace, but the GUI is sometimes painful: you have a nice report but many […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/oem-13c-repository-view-gcmetric_values_daily\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2018-12-03T08:50:55+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Screen-Shot-2018-11-23-at-12.09.37.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1566\" \/>\n\t<meta property=\"og:image:height\" content=\"1182\" \/>\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=\"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\/oem-13c-repository-view-gcmetric_values_daily\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oem-13c-repository-view-gcmetric_values_daily\/\"},\"author\":{\"name\":\"Oracle Team\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\"},\"headline\":\"OEM 13c Repository view gc$metric_values_daily\",\"datePublished\":\"2018-12-03T08:50:55+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oem-13c-repository-view-gcmetric_values_daily\/\"},\"wordCount\":574,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oem-13c-repository-view-gcmetric_values_daily\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Screen-Shot-2018-11-23-at-12.09.37.png\",\"keywords\":[\"Oracle Enterprise Manager\"],\"articleSection\":[\"Database Administration & Monitoring\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/oem-13c-repository-view-gcmetric_values_daily\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oem-13c-repository-view-gcmetric_values_daily\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/oem-13c-repository-view-gcmetric_values_daily\/\",\"name\":\"OEM 13c Repository view gc$metric_values_daily - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oem-13c-repository-view-gcmetric_values_daily\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oem-13c-repository-view-gcmetric_values_daily\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Screen-Shot-2018-11-23-at-12.09.37.png\",\"datePublished\":\"2018-12-03T08:50:55+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oem-13c-repository-view-gcmetric_values_daily\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/oem-13c-repository-view-gcmetric_values_daily\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oem-13c-repository-view-gcmetric_values_daily\/#primaryimage\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Screen-Shot-2018-11-23-at-12.09.37.png\",\"contentUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Screen-Shot-2018-11-23-at-12.09.37.png\",\"width\":1566,\"height\":1182},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oem-13c-repository-view-gcmetric_values_daily\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"OEM 13c Repository view gc$metric_values_daily\"}]},{\"@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":"OEM 13c Repository view gc$metric_values_daily - 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\/oem-13c-repository-view-gcmetric_values_daily\/","og_locale":"en_US","og_type":"article","og_title":"OEM 13c Repository view gc$metric_values_daily","og_description":"Oracle OEM 13c offers the possibility to generate reports about Oracle Database Tablespace Monthly Space Usage. The displayed information is quite useful and display a lot of information:     The report displays the details for each month and for each tablespace, but the GUI is sometimes painful: you have a nice report but many […]","og_url":"https:\/\/www.dbi-services.com\/blog\/oem-13c-repository-view-gcmetric_values_daily\/","og_site_name":"dbi Blog","article_published_time":"2018-12-03T08:50:55+00:00","og_image":[{"width":1566,"height":1182,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Screen-Shot-2018-11-23-at-12.09.37.png","type":"image\/png"}],"author":"Oracle Team","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Oracle Team","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/oem-13c-repository-view-gcmetric_values_daily\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/oem-13c-repository-view-gcmetric_values_daily\/"},"author":{"name":"Oracle Team","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"headline":"OEM 13c Repository view gc$metric_values_daily","datePublished":"2018-12-03T08:50:55+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/oem-13c-repository-view-gcmetric_values_daily\/"},"wordCount":574,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/oem-13c-repository-view-gcmetric_values_daily\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Screen-Shot-2018-11-23-at-12.09.37.png","keywords":["Oracle Enterprise Manager"],"articleSection":["Database Administration & Monitoring"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/oem-13c-repository-view-gcmetric_values_daily\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/oem-13c-repository-view-gcmetric_values_daily\/","url":"https:\/\/www.dbi-services.com\/blog\/oem-13c-repository-view-gcmetric_values_daily\/","name":"OEM 13c Repository view gc$metric_values_daily - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/oem-13c-repository-view-gcmetric_values_daily\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/oem-13c-repository-view-gcmetric_values_daily\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Screen-Shot-2018-11-23-at-12.09.37.png","datePublished":"2018-12-03T08:50:55+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/oem-13c-repository-view-gcmetric_values_daily\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/oem-13c-repository-view-gcmetric_values_daily\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/oem-13c-repository-view-gcmetric_values_daily\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Screen-Shot-2018-11-23-at-12.09.37.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Screen-Shot-2018-11-23-at-12.09.37.png","width":1566,"height":1182},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/oem-13c-repository-view-gcmetric_values_daily\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"OEM 13c Repository view gc$metric_values_daily"}]},{"@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\/12123","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=12123"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/12123\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/12124"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=12123"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=12123"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=12123"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=12123"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}