{"id":4721,"date":"2018-11-06T10:36:25","date_gmt":"2018-11-06T10:36:25","guid":{"rendered":"https:\/\/dbtut.com\/?p=4721"},"modified":"2018-11-07T06:40:45","modified_gmt":"2018-11-07T06:40:45","slug":"dbtime-and-elapsed_time-percentage-information-from-all-awr-reports","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2018\/11\/06\/dbtime-and-elapsed_time-percentage-information-from-all-awr-reports\/","title":{"rendered":"DBTIME and ELAPSED_TIME Percentage Information From All AWR Reports"},"content":{"rendered":"<p>The Oracle Database produces reports that are called AWR at specific periods and that share the general status of the database. You can use the following script to examine the related AWRs in more detail.<\/p>\n<p>&nbsp;<\/p>\n<pre class=\"lang:default decode:true\">SELECT I.INSTANCE_NAME INSTANCE_NAME_PRINT,\r\nS.SNAP_ID SNAP_ID,\r\nTO_CHAR (S.STARTUP_TIME, 'mm\/dd\/yyyy HH24:MI:SS') STARTUP_TIME,\r\nTO_CHAR (S.BEGIN_INTERVAL_TIME, 'mm\/dd\/yyyy HH24:MI:SS')\r\nBEGIN_INTERVAL_TIME,\r\nTO_CHAR (S.END_INTERVAL_TIME, 'mm\/dd\/yyyy HH24:MI:SS')\r\nEND_INTERVAL_TIME,\r\nROUND (\r\nEXTRACT (DAY FROM S.END_INTERVAL_TIME - S.BEGIN_INTERVAL_TIME) * 1440\r\n+\u00a0\u00a0 EXTRACT (HOUR FROM S.END_INTERVAL_TIME - S.BEGIN_INTERVAL_TIME) * 60\r\n+ EXTRACT (MINUTE FROM S.END_INTERVAL_TIME - S.BEGIN_INTERVAL_TIME)\r\n+\u00a0\u00a0 EXTRACT ( SECOND FROM S.END_INTERVAL_TIME - S.BEGIN_INTERVAL_TIME) \/ 60, 2)\r\nELAPSED_TIME,\r\nROUND ( (E.VALUE - B.VALUE) \/ 1000000 \/ 60, 2) DB_TIME,\r\nROUND (\r\n(\u00a0 (\u00a0 ( (E.VALUE - B.VALUE) \/ 1000000 \/ 60)\r\n\/ (\u00a0\u00a0\u00a0 EXTRACT ( DAY FROM S.END_INTERVAL_TIME - S.BEGIN_INTERVAL_TIME)* 1440\r\n+\u00a0\u00a0 EXTRACT ( HOUR FROM S.END_INTERVAL_TIME - S.BEGIN_INTERVAL_TIME) * 60\r\n+ EXTRACT ( MINUTE FROM S.END_INTERVAL_TIME - S.BEGIN_INTERVAL_TIME)\r\n+\u00a0\u00a0 EXTRACT ( SECOND FROM\u00a0\u00a0 S.END_INTERVAL_TIME\u00a0 - S.BEGIN_INTERVAL_TIME) \/ 60)) * 100), 2)\r\nPCT_DB_TIME\r\nFROM DBA_HIST_SNAPSHOT S,\r\nGV$INSTANCE I,\r\nDBA_HIST_SYS_TIME_MODEL E,\r\nDBA_HIST_SYS_TIME_MODEL B\r\nWHERE\u00a0\u00a0\u00a0\u00a0 I.INSTANCE_NUMBER = S.INSTANCE_NUMBER\r\nAND E.SNAP_ID = S.SNAP_ID\r\nAND B.SNAP_ID = S.SNAP_ID - 1\r\nAND E.STAT_ID = B.STAT_ID\r\nAND E.INSTANCE_NUMBER = B.INSTANCE_NUMBER\r\nAND E.INSTANCE_NUMBER = S.INSTANCE_NUMBER\r\nAND E.STAT_NAME = 'DB time'\r\nORDER BY I.INSTANCE_NAME, S.SNAP_ID DESC;<\/pre>\n<p>This script was tested in 11gR1 and 11gR2. Please test the scripts on your test servers before running them in the production environment.<\/p>\n\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_4721\" class=\"pvc_stats all  \" data-element-id=\"4721\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/dbtut.com\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"excerpt":{"rendered":"<p>The Oracle Database produces reports that are called AWR at specific periods and that share the general status of the database. You can use the following script to examine the related AWRs in more detail. &nbsp; SELECT I.INSTANCE_NAME INSTANCE_NAME_PRINT, S.SNAP_ID SNAP_ID, TO_CHAR (S.STARTUP_TIME, &#8216;mm\/dd\/yyyy HH24:MI:SS&#8217;) STARTUP_TIME, TO_CHAR (S.BEGIN_INTERVAL_TIME, &#8216;mm\/dd\/yyyy HH24:MI:SS&#8217;) BEGIN_INTERVAL_TIME, TO_CHAR (S.END_INTERVAL_TIME, &#8216;mm\/dd\/yyyy HH24:MI:SS&#8217;) &hellip;<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_4721\" class=\"pvc_stats all  \" data-element-id=\"4721\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/dbtut.com\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[4],"tags":[],"class_list":["post-4721","post","type-post","status-publish","format-standard","","category-oracle"],"aioseo_notices":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>DBTIME and ELAPSED_TIME Percentage Information From All AWR Reports - Database Tutorials<\/title>\n<meta name=\"description\" content=\"DBTIME and ELAPSED_TIME Percentage Information From All AWR Reports\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/dbtut.com\/index.php\/2018\/11\/06\/dbtime-and-elapsed_time-percentage-information-from-all-awr-reports\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"DBTIME and ELAPSED_TIME Percentage Information From All AWR Reports - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"DBTIME and ELAPSED_TIME Percentage Information From All AWR Reports\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2018\/11\/06\/dbtime-and-elapsed_time-percentage-information-from-all-awr-reports\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2018-11-06T10:36:25+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2018-11-07T06:40:45+00:00\" \/>\n<meta name=\"author\" content=\"dbtut\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"dbtut\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/11\/06\/dbtime-and-elapsed_time-percentage-information-from-all-awr-reports\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/11\/06\/dbtime-and-elapsed_time-percentage-information-from-all-awr-reports\/\"},\"author\":{\"name\":\"dbtut\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408\"},\"headline\":\"DBTIME and ELAPSED_TIME Percentage Information From All AWR Reports\",\"datePublished\":\"2018-11-06T10:36:25+00:00\",\"dateModified\":\"2018-11-07T06:40:45+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/11\/06\/dbtime-and-elapsed_time-percentage-information-from-all-awr-reports\/\"},\"wordCount\":72,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"articleSection\":[\"ORACLE\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2018\/11\/06\/dbtime-and-elapsed_time-percentage-information-from-all-awr-reports\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/11\/06\/dbtime-and-elapsed_time-percentage-information-from-all-awr-reports\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2018\/11\/06\/dbtime-and-elapsed_time-percentage-information-from-all-awr-reports\/\",\"name\":\"DBTIME and ELAPSED_TIME Percentage Information From All AWR Reports - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"datePublished\":\"2018-11-06T10:36:25+00:00\",\"dateModified\":\"2018-11-07T06:40:45+00:00\",\"description\":\"DBTIME and ELAPSED_TIME Percentage Information From All AWR Reports\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/11\/06\/dbtime-and-elapsed_time-percentage-information-from-all-awr-reports\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2018\/11\/06\/dbtime-and-elapsed_time-percentage-information-from-all-awr-reports\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/11\/06\/dbtime-and-elapsed_time-percentage-information-from-all-awr-reports\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"DBTIME and ELAPSED_TIME Percentage Information From All AWR Reports\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/dbtut.com\/#website\",\"url\":\"https:\/\/dbtut.com\/\",\"name\":\"Database Tutorials\",\"description\":\"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux\",\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/dbtut.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/dbtut.com\/#organization\",\"name\":\"dbtut\",\"url\":\"https:\/\/dbtut.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"width\":223,\"height\":36,\"caption\":\"dbtut\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408\",\"name\":\"dbtut\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g\",\"caption\":\"dbtut\"},\"description\":\"We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.\",\"sameAs\":[\"http:\/\/NurullahCAKIR\"],\"url\":\"https:\/\/dbtut.com\/index.php\/author\/dbtut\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"DBTIME and ELAPSED_TIME Percentage Information From All AWR Reports - Database Tutorials","description":"DBTIME and ELAPSED_TIME Percentage Information From All AWR Reports","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:\/\/dbtut.com\/index.php\/2018\/11\/06\/dbtime-and-elapsed_time-percentage-information-from-all-awr-reports\/","og_locale":"en_US","og_type":"article","og_title":"DBTIME and ELAPSED_TIME Percentage Information From All AWR Reports - Database Tutorials","og_description":"DBTIME and ELAPSED_TIME Percentage Information From All AWR Reports","og_url":"https:\/\/dbtut.com\/index.php\/2018\/11\/06\/dbtime-and-elapsed_time-percentage-information-from-all-awr-reports\/","og_site_name":"Database Tutorials","article_published_time":"2018-11-06T10:36:25+00:00","article_modified_time":"2018-11-07T06:40:45+00:00","author":"dbtut","twitter_card":"summary_large_image","twitter_misc":{"Written by":"dbtut","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2018\/11\/06\/dbtime-and-elapsed_time-percentage-information-from-all-awr-reports\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/11\/06\/dbtime-and-elapsed_time-percentage-information-from-all-awr-reports\/"},"author":{"name":"dbtut","@id":"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408"},"headline":"DBTIME and ELAPSED_TIME Percentage Information From All AWR Reports","datePublished":"2018-11-06T10:36:25+00:00","dateModified":"2018-11-07T06:40:45+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/11\/06\/dbtime-and-elapsed_time-percentage-information-from-all-awr-reports\/"},"wordCount":72,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"articleSection":["ORACLE"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2018\/11\/06\/dbtime-and-elapsed_time-percentage-information-from-all-awr-reports\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2018\/11\/06\/dbtime-and-elapsed_time-percentage-information-from-all-awr-reports\/","url":"https:\/\/dbtut.com\/index.php\/2018\/11\/06\/dbtime-and-elapsed_time-percentage-information-from-all-awr-reports\/","name":"DBTIME and ELAPSED_TIME Percentage Information From All AWR Reports - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"datePublished":"2018-11-06T10:36:25+00:00","dateModified":"2018-11-07T06:40:45+00:00","description":"DBTIME and ELAPSED_TIME Percentage Information From All AWR Reports","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/11\/06\/dbtime-and-elapsed_time-percentage-information-from-all-awr-reports\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2018\/11\/06\/dbtime-and-elapsed_time-percentage-information-from-all-awr-reports\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2018\/11\/06\/dbtime-and-elapsed_time-percentage-information-from-all-awr-reports\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"DBTIME and ELAPSED_TIME Percentage Information From All AWR Reports"}]},{"@type":"WebSite","@id":"https:\/\/dbtut.com\/#website","url":"https:\/\/dbtut.com\/","name":"Database Tutorials","description":"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux","publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/dbtut.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/dbtut.com\/#organization","name":"dbtut","url":"https:\/\/dbtut.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","width":223,"height":36,"caption":"dbtut"},"image":{"@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408","name":"dbtut","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g","caption":"dbtut"},"description":"We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.","sameAs":["http:\/\/NurullahCAKIR"],"url":"https:\/\/dbtut.com\/index.php\/author\/dbtut\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/4721","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/comments?post=4721"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/4721\/revisions"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=4721"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=4721"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=4721"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}