{"id":73320,"date":"2012-04-26T10:20:18","date_gmt":"2012-04-26T10:20:18","guid":{"rendered":"https:\/\/www.red-gate.com\/simple-talk\/uncategorized\/how-to-gather-sql-resource-consumption-metrics-in-oracle\/"},"modified":"2021-07-14T13:07:58","modified_gmt":"2021-07-14T13:07:58","slug":"how-to-gather-sql-resource-consumption-metrics-in-oracle","status":"publish","type":"post","link":"https:\/\/www.red-gate.com\/simple-talk\/databases\/oracle-databases\/how-to-gather-sql-resource-consumption-metrics-in-oracle\/","title":{"rendered":"How to Gather SQL Resource Consumption Metrics in Oracle"},"content":{"rendered":"<p>The following video and set of resources are from the <a href=\"http:\/\/www.red-gate.com\/products\/oracle-development\/deployment-suite-for-oracle\/webinars\/webinar-karen-morton-oracle-sql-resource-consumption-metrics\" target=\"blank\">webinar<\/a> broadcast by <a href=\"http:\/\/www.red-gate.com\/products\/oracle-development\/\" target=\"blank\">Red Gate<\/a> on 8 May 2012.<\/p>\n<p><a href=\"http:\/\/www.red-gate.com\/products\/oracle-development\/deployment-suite-for-oracle\/education\/webinars\/webinar-karen-morton-oracle-sql-resource-consumption-metrics\" target=\"blank\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.red-gate.com\/simple-talk\/wp-content\/uploads\/oracle\/2012\/04\/oracle-sql-resource-consumption-metrics-karen-morton-video.png\" alt=\"\" title=\"How to Gather SQL Resource Consumption Metrics in Oracle by Karen Morton webinar recording\" width=\"500\" height=\"400\" \/><\/a><\/p>\n<p>The video above is accompanied by the following downloadable resources:<\/p>\n<ul>\n<li><a href=\"https:\/\/www.red-gate.com\/simple-talk\/wp-content\/uploads\/oracle\/2012\/05\/Oracle-SQL-Consumption-Metrcis-Webinar-Slides.pdf\" target=\"blank\">Presentation slides (.pdf)<\/a><\/li>\n<li><a href=\"https:\/\/www.red-gate.com\/simple-talk\/wp-content\/uploads\/oracle\/2012\/05\/resource-consumption-metrics-examples.txt\" target=\"blank\">Resource Consumption Metrics Examples (.txt)<\/a><\/li>\n<li><a href=\"https:\/\/www.red-gate.com\/simple-talk\/wp-content\/uploads\/oracle\/2012\/05\/awrsqlrpt_1_16411_16412.html\" target=\"blank\">Workload Repository SQL Report (awrsqlrpt_1_16411_16412.html)<\/a><\/li>\n<li><a href=\"https:\/\/www.red-gate.com\/simple-talk\/wp-content\/uploads\/oracle\/2012\/05\/0-6x2sh0kvzac0t-2.html\" target=\"blank\">SQL Monitoring Report (0-6x2sh0kvzac0t-2.html)<\/a><\/li>\n<li><a href=\"https:\/\/www.red-gate.com\/simple-talk\/wp-content\/uploads\/oracle\/2012\/05\/ashrpt_1_0505_1117.html\" target=\"blank\">ASH Report for BIUAT\/biuat1 (ashrpt_1_0505_1117.html)<\/a><\/li>\n<li><a href=\"https:\/\/www.red-gate.com\/simple-talk\/wp-content\/uploads\/oracle\/2012\/05\/Oracle-SQL-Consumption-Metrics-Webinar-Resources.zip\" target=\"blank\">Download all resources (.zip)<\/a><\/li>\n<\/ul>\n<p>SQL is utilized to return data via our applications to service user requests. Whether it&#8217;s a single customer lookup or a huge month end summary report, the SQL we write must gather the correct data and return it to the user.<\/p>\n<p>Ensuring that the SQL you write can do this in a timely and efficient manner, both now and in the future, requires that you measure and evaluate what resources your query must use.<\/p>\n<p>In this webinar, we&#8217;ll cover several methods for how to collect data that show you precisely how your SQL consumes resources:<\/p>\n<ul>\n<li>Using AUTOTRACE<\/li>\n<li>Using DBMS_XPLAN.DISPLAY_CURSOR<\/li>\n<li>Using Report SQL Monitor<\/li>\n<li>Using ASH (Active Session History) and AWR (Automatic Workload Repository) data<\/li>\n<\/ul>\n<p>You&#8217;ll learn how to utilize the data to understand the work your SQL is doing and the resources it consumes; identify currently evident performance issues as well as areas that could be problematic in the future; and modify your SQL to use less resources more efficiently while still returning the desired results.<\/p>\n<p>A live Q+A session with Karen Morton will follow the presentation.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>The following video and set of resources are from the webinar broadcast by Red Gate on 8 May 2012. The video above is accompanied by the following downloadable resources: Presentation slides (.pdf) Resource Consumption Metrics Examples (.txt) Workload Repository SQL Report (awrsqlrpt_1_16411_16412.html) SQL Monitoring Report (0-6x2sh0kvzac0t-2.html) ASH Report for BIUAT\/biuat1 (ashrpt_1_0505_1117.html) Download all resources (.zip) SQL is utilized to return&hellip;<\/p>\n","protected":false},"author":316199,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[143533],"tags":[],"coauthors":[],"class_list":["post-73320","post","type-post","status-publish","format-standard","hentry","category-oracle-databases"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts\/73320","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/users\/316199"}],"replies":[{"embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/comments?post=73320"}],"version-history":[{"count":1,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts\/73320\/revisions"}],"predecessor-version":[{"id":91768,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts\/73320\/revisions\/91768"}],"wp:attachment":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/media?parent=73320"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/categories?post=73320"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/tags?post=73320"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/coauthors?post=73320"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}