{"id":53972,"date":"2023-03-01T09:55:45","date_gmt":"2023-03-01T09:55:45","guid":{"rendered":"https:\/\/dbtut.com\/?p=53972"},"modified":"2023-03-01T09:56:48","modified_gmt":"2023-03-01T09:56:48","slug":"most-used-sql-queries","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2023\/03\/01\/most-used-sql-queries\/","title":{"rendered":"Most Used SQL Queries"},"content":{"rendered":"<p>In today&#8217;s article we will cover how we can see the Most Used or Executed SQL Queries (Last 20).<\/p>\n<pre class=\"lang:default decode:true \">SELECT *\r\n  FROM (  SELECT ss.sql_text,\r\n                 a.SQL_ID,\r\n                 SUM (CPU_TIME_DELTA),\r\n                 SUM (DISK_READS_DELTA),\r\n                 COUNT (*)\r\n            FROM DBA_HIST_SQLSTAT a, dba_hist_snapshot s, v$sql ss\r\n           WHERE     s.snap_id = a.snap_id\r\n                 AND a.sql_id = ss.sql_id\r\n                 AND s.begin_interval_time &gt; SYSDATE - 1\r\n        GROUP BY ss.sql_text, a.SQL_ID\r\n        ORDER BY SUM (CPU_TIME_DELTA) DESC)\r\n WHERE ROWNUM &lt;= 20;<\/pre>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_53972\" class=\"pvc_stats all  \" data-element-id=\"53972\" 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>In today&#8217;s article we will cover how we can see the Most Used or Executed SQL Queries (Last 20). SELECT * FROM ( SELECT ss.sql_text, a.SQL_ID, SUM (CPU_TIME_DELTA), SUM (DISK_READS_DELTA), COUNT (*) FROM DBA_HIST_SQLSTAT a, dba_hist_snapshot s, v$sql ss WHERE s.snap_id = a.snap_id AND a.sql_id = ss.sql_id AND s.begin_interval_time &gt; SYSDATE &#8211; 1 GROUP BY &hellip;<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_53972\" class=\"pvc_stats all  \" data-element-id=\"53972\" 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":574,"featured_media":53973,"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-53972","post","type-post","status-publish","format-standard","has-post-thumbnail","","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>Most Used SQL Queries - Database Tutorials<\/title>\n<meta name=\"description\" content=\"In today&#039;s article we will cover how we can see the Most Used or Executed SQL Queries (Last 20).\" \/>\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\/2023\/03\/01\/most-used-sql-queries\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Most Used SQL Queries - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"In today&#039;s article we will cover how we can see the Most Used or Executed SQL Queries (Last 20).\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2023\/03\/01\/most-used-sql-queries\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-03-01T09:55:45+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-03-01T09:56:48+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/03\/Ekran-goruntusu-2023-03-01-125428.png\" \/>\n\t<meta property=\"og:image:width\" content=\"687\" \/>\n\t<meta property=\"og:image:height\" content=\"285\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Bu\u011fra PARLAYAN\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Bu\u011fra PARLAYAN\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/03\/01\/most-used-sql-queries\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/03\/01\/most-used-sql-queries\/\"},\"author\":{\"name\":\"Bu\u011fra PARLAYAN\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/f07abb2de370d35d6c93e90d8eb2b9f2\"},\"headline\":\"Most Used SQL Queries\",\"datePublished\":\"2023-03-01T09:55:45+00:00\",\"dateModified\":\"2023-03-01T09:56:48+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/03\/01\/most-used-sql-queries\/\"},\"wordCount\":22,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/03\/01\/most-used-sql-queries\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/03\/Ekran-goruntusu-2023-03-01-125428.png\",\"articleSection\":[\"ORACLE\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2023\/03\/01\/most-used-sql-queries\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/03\/01\/most-used-sql-queries\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2023\/03\/01\/most-used-sql-queries\/\",\"name\":\"Most Used SQL Queries - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/03\/01\/most-used-sql-queries\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/03\/01\/most-used-sql-queries\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/03\/Ekran-goruntusu-2023-03-01-125428.png\",\"datePublished\":\"2023-03-01T09:55:45+00:00\",\"dateModified\":\"2023-03-01T09:56:48+00:00\",\"description\":\"In today's article we will cover how we can see the Most Used or Executed SQL Queries (Last 20).\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/03\/01\/most-used-sql-queries\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2023\/03\/01\/most-used-sql-queries\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/03\/01\/most-used-sql-queries\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/03\/Ekran-goruntusu-2023-03-01-125428.png\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/03\/Ekran-goruntusu-2023-03-01-125428.png\",\"width\":687,\"height\":285},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/03\/01\/most-used-sql-queries\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Most Used SQL Queries\"}]},{\"@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\/f07abb2de370d35d6c93e90d8eb2b9f2\",\"name\":\"Bu\u011fra PARLAYAN\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/8fe63334d745f00f79f9f47b870aa143dd0f7615580c741a3b078aa4d09fa071?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/8fe63334d745f00f79f9f47b870aa143dd0f7615580c741a3b078aa4d09fa071?s=96&d=mm&r=g\",\"caption\":\"Bu\u011fra PARLAYAN\"},\"description\":\"Burgra Parlayan is an experienced Database and Weblogic Administrator. After completing his technical \/ relevant training he has got involved with a serious amount of projects. He successfully managed database upgrade, database migration, database performance tuning projects for various public institutions.Currently he has been employed by one of the leading financial institutions called Turkiye Hayat &amp; Emeklilik as responsible administrator for Oracle Database and Oracle Middleware. He has been sharing his experience and knowledge by face to face training, personal blog and various social networking accounts to support the Oracle ecosystem continuously since 2010.\",\"sameAs\":[\"http:\/\/www.bugraparlayan.com.tr\/\"],\"url\":\"https:\/\/dbtut.com\/index.php\/author\/bugraparlayan\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Most Used SQL Queries - Database Tutorials","description":"In today's article we will cover how we can see the Most Used or Executed SQL Queries (Last 20).","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\/2023\/03\/01\/most-used-sql-queries\/","og_locale":"en_US","og_type":"article","og_title":"Most Used SQL Queries - Database Tutorials","og_description":"In today's article we will cover how we can see the Most Used or Executed SQL Queries (Last 20).","og_url":"https:\/\/dbtut.com\/index.php\/2023\/03\/01\/most-used-sql-queries\/","og_site_name":"Database Tutorials","article_published_time":"2023-03-01T09:55:45+00:00","article_modified_time":"2023-03-01T09:56:48+00:00","og_image":[{"width":687,"height":285,"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/03\/Ekran-goruntusu-2023-03-01-125428.png","type":"image\/png"}],"author":"Bu\u011fra PARLAYAN","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Bu\u011fra PARLAYAN","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2023\/03\/01\/most-used-sql-queries\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2023\/03\/01\/most-used-sql-queries\/"},"author":{"name":"Bu\u011fra PARLAYAN","@id":"https:\/\/dbtut.com\/#\/schema\/person\/f07abb2de370d35d6c93e90d8eb2b9f2"},"headline":"Most Used SQL Queries","datePublished":"2023-03-01T09:55:45+00:00","dateModified":"2023-03-01T09:56:48+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2023\/03\/01\/most-used-sql-queries\/"},"wordCount":22,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2023\/03\/01\/most-used-sql-queries\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/03\/Ekran-goruntusu-2023-03-01-125428.png","articleSection":["ORACLE"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2023\/03\/01\/most-used-sql-queries\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2023\/03\/01\/most-used-sql-queries\/","url":"https:\/\/dbtut.com\/index.php\/2023\/03\/01\/most-used-sql-queries\/","name":"Most Used SQL Queries - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2023\/03\/01\/most-used-sql-queries\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2023\/03\/01\/most-used-sql-queries\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/03\/Ekran-goruntusu-2023-03-01-125428.png","datePublished":"2023-03-01T09:55:45+00:00","dateModified":"2023-03-01T09:56:48+00:00","description":"In today's article we will cover how we can see the Most Used or Executed SQL Queries (Last 20).","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2023\/03\/01\/most-used-sql-queries\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2023\/03\/01\/most-used-sql-queries\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2023\/03\/01\/most-used-sql-queries\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/03\/Ekran-goruntusu-2023-03-01-125428.png","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/03\/Ekran-goruntusu-2023-03-01-125428.png","width":687,"height":285},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2023\/03\/01\/most-used-sql-queries\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"Most Used SQL Queries"}]},{"@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\/f07abb2de370d35d6c93e90d8eb2b9f2","name":"Bu\u011fra PARLAYAN","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/8fe63334d745f00f79f9f47b870aa143dd0f7615580c741a3b078aa4d09fa071?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/8fe63334d745f00f79f9f47b870aa143dd0f7615580c741a3b078aa4d09fa071?s=96&d=mm&r=g","caption":"Bu\u011fra PARLAYAN"},"description":"Burgra Parlayan is an experienced Database and Weblogic Administrator. After completing his technical \/ relevant training he has got involved with a serious amount of projects. He successfully managed database upgrade, database migration, database performance tuning projects for various public institutions.Currently he has been employed by one of the leading financial institutions called Turkiye Hayat &amp; Emeklilik as responsible administrator for Oracle Database and Oracle Middleware. He has been sharing his experience and knowledge by face to face training, personal blog and various social networking accounts to support the Oracle ecosystem continuously since 2010.","sameAs":["http:\/\/www.bugraparlayan.com.tr\/"],"url":"https:\/\/dbtut.com\/index.php\/author\/bugraparlayan\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/53972","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\/574"}],"replies":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/comments?post=53972"}],"version-history":[{"count":1,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/53972\/revisions"}],"predecessor-version":[{"id":53974,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/53972\/revisions\/53974"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media\/53973"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=53972"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=53972"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=53972"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}