{"id":6507,"date":"2024-03-14T04:20:57","date_gmt":"2024-03-14T04:20:57","guid":{"rendered":"https:\/\/www.silicloud.com\/blog\/what-are-awr-and-ash-in-oracle-database\/"},"modified":"2025-08-02T04:30:58","modified_gmt":"2025-08-02T04:30:58","slug":"what-are-awr-and-ash-in-oracle-database","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/blog\/what-are-awr-and-ash-in-oracle-database\/","title":{"rendered":"AWR &#038; ASH: Oracle Performance Tools"},"content":{"rendered":"<p>AWR (Automatic Workload Repository) and ASH (Active Session History) are crucial tools in Oracle databases for performance tuning and troubleshooting.<\/p>\n<p>AWR is a performance diagnostic tool in Oracle databases that automatically collects performance data of the database instance regularly, such as system activity, wait events, and SQL execution details. This data can assist DBAs in analyzing performance bottlenecks and optimizing database performance.<\/p>\n<p>ASH is a special table in the Oracle database that records relevant information about active sessions in the database instance, such as session wait events, SQL execution status, and execution plans. By analyzing ASH data, one can understand which sessions are currently executing, which sessions are waiting for resources, and the overall performance of the system.<\/p>\n<p>Utilizing both AWR and ASH together can assist DBAs in gaining a better understanding of a database instance&#8217;s performance status, enabling them to promptly identify and resolve performance issues, ultimately improving system stability and performance.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>AWR (Automatic Workload Repository) and ASH (Active Session History) are crucial tools in Oracle databases for performance tuning and troubleshooting. AWR is a performance diagnostic tool in Oracle databases that automatically collects performance data of the database instance regularly, such as system activity, wait events, and SQL execution details. This data can assist DBAs in [&hellip;]<\/p>\n","protected":false},"author":9,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_import_markdown_pro_load_document_selector":0,"_import_markdown_pro_submit_text_textarea":"","footnotes":""},"categories":[1],"tags":[4616,7924,7923,1079,7925],"class_list":["post-6507","post","type-post","status-publish","format-standard","hentry","category-uncategorized","tag-database-troubleshooting","tag-oracle-ash","tag-oracle-awr","tag-oracle-dba","tag-oracle-performance-tuning"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.5 (Yoast SEO v21.5) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>AWR &amp; ASH: Oracle Performance Tools - Blog - Silicon Cloud<\/title>\n<meta name=\"description\" content=\"Learn how AWR and ASH optimize Oracle database performance. Key tools for DBAs to diagnose bottlenecks and tune SQL.\" \/>\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.silicloud.com\/blog\/what-are-awr-and-ash-in-oracle-database\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"AWR &amp; ASH: Oracle Performance Tools\" \/>\n<meta property=\"og:description\" content=\"Learn how AWR and ASH optimize Oracle database performance. Key tools for DBAs to diagnose bottlenecks and tune SQL.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/blog\/what-are-awr-and-ash-in-oracle-database\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog - Silicon Cloud\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/SiliCloudGlobal\/\" \/>\n<meta property=\"article:published_time\" content=\"2024-03-14T04:20:57+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-08-02T04:30:58+00:00\" \/>\n<meta name=\"author\" content=\"Ava Mitchell\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@SiliCloudGlobal\" \/>\n<meta name=\"twitter:site\" content=\"@SiliCloudGlobal\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Ava Mitchell\" \/>\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:\/\/www.silicloud.com\/blog\/what-are-awr-and-ash-in-oracle-database\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/what-are-awr-and-ash-in-oracle-database\/\"},\"author\":{\"name\":\"Ava Mitchell\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/a3e2658c2cb9fb2be95ae0a8861f4a64\"},\"headline\":\"AWR &#038; ASH: Oracle Performance Tools\",\"datePublished\":\"2024-03-14T04:20:57+00:00\",\"dateModified\":\"2025-08-02T04:30:58+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/what-are-awr-and-ash-in-oracle-database\/\"},\"wordCount\":159,\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"keywords\":[\"database troubleshooting\",\"Oracle ASH\",\"Oracle AWR\",\"Oracle DBA\",\"Oracle Performance Tuning\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/what-are-awr-and-ash-in-oracle-database\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/what-are-awr-and-ash-in-oracle-database\/\",\"name\":\"AWR & ASH: Oracle Performance Tools - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\"},\"datePublished\":\"2024-03-14T04:20:57+00:00\",\"dateModified\":\"2025-08-02T04:30:58+00:00\",\"description\":\"Learn how AWR and ASH optimize Oracle database performance. Key tools for DBAs to diagnose bottlenecks and tune SQL.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/what-are-awr-and-ash-in-oracle-database\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/blog\/what-are-awr-and-ash-in-oracle-database\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/what-are-awr-and-ash-in-oracle-database\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.silicloud.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"AWR &#038; ASH: Oracle Performance Tools\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\",\"url\":\"https:\/\/www.silicloud.com\/blog\/\",\"name\":\"Silicon Cloud Blog\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\",\"name\":\"Silicon Cloud Blog\",\"url\":\"https:\/\/www.silicloud.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png\",\"contentUrl\":\"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png\",\"width\":1024,\"height\":1024,\"caption\":\"Silicon Cloud Blog\"},\"image\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/SiliCloudGlobal\/\",\"https:\/\/twitter.com\/SiliCloudGlobal\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/a3e2658c2cb9fb2be95ae0a8861f4a64\",\"name\":\"Ava Mitchell\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/15c63cd0564b4a2e07d611bcdffa296f6ea80e8db07c3091f43a84010514899d?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/15c63cd0564b4a2e07d611bcdffa296f6ea80e8db07c3091f43a84010514899d?s=96&d=mm&r=g\",\"caption\":\"Ava Mitchell\"},\"url\":\"https:\/\/www.silicloud.com\/blog\/author\/avamitchell\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"AWR & ASH: Oracle Performance Tools - Blog - Silicon Cloud","description":"Learn how AWR and ASH optimize Oracle database performance. Key tools for DBAs to diagnose bottlenecks and tune SQL.","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.silicloud.com\/blog\/what-are-awr-and-ash-in-oracle-database\/","og_locale":"en_US","og_type":"article","og_title":"AWR & ASH: Oracle Performance Tools","og_description":"Learn how AWR and ASH optimize Oracle database performance. Key tools for DBAs to diagnose bottlenecks and tune SQL.","og_url":"https:\/\/www.silicloud.com\/blog\/what-are-awr-and-ash-in-oracle-database\/","og_site_name":"Blog - Silicon Cloud","article_publisher":"https:\/\/www.facebook.com\/SiliCloudGlobal\/","article_published_time":"2024-03-14T04:20:57+00:00","article_modified_time":"2025-08-02T04:30:58+00:00","author":"Ava Mitchell","twitter_card":"summary_large_image","twitter_creator":"@SiliCloudGlobal","twitter_site":"@SiliCloudGlobal","twitter_misc":{"Written by":"Ava Mitchell","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.silicloud.com\/blog\/what-are-awr-and-ash-in-oracle-database\/#article","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/what-are-awr-and-ash-in-oracle-database\/"},"author":{"name":"Ava Mitchell","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/a3e2658c2cb9fb2be95ae0a8861f4a64"},"headline":"AWR &#038; ASH: Oracle Performance Tools","datePublished":"2024-03-14T04:20:57+00:00","dateModified":"2025-08-02T04:30:58+00:00","mainEntityOfPage":{"@id":"https:\/\/www.silicloud.com\/blog\/what-are-awr-and-ash-in-oracle-database\/"},"wordCount":159,"publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"keywords":["database troubleshooting","Oracle ASH","Oracle AWR","Oracle DBA","Oracle Performance Tuning"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/blog\/what-are-awr-and-ash-in-oracle-database\/","url":"https:\/\/www.silicloud.com\/blog\/what-are-awr-and-ash-in-oracle-database\/","name":"AWR & ASH: Oracle Performance Tools - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/#website"},"datePublished":"2024-03-14T04:20:57+00:00","dateModified":"2025-08-02T04:30:58+00:00","description":"Learn how AWR and ASH optimize Oracle database performance. Key tools for DBAs to diagnose bottlenecks and tune SQL.","breadcrumb":{"@id":"https:\/\/www.silicloud.com\/blog\/what-are-awr-and-ash-in-oracle-database\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/blog\/what-are-awr-and-ash-in-oracle-database\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/blog\/what-are-awr-and-ash-in-oracle-database\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.silicloud.com\/blog\/"},{"@type":"ListItem","position":2,"name":"AWR &#038; ASH: Oracle Performance Tools"}]},{"@type":"WebSite","@id":"https:\/\/www.silicloud.com\/blog\/#website","url":"https:\/\/www.silicloud.com\/blog\/","name":"Silicon Cloud Blog","description":"","publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.silicloud.com\/blog\/#organization","name":"Silicon Cloud Blog","url":"https:\/\/www.silicloud.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png","contentUrl":"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png","width":1024,"height":1024,"caption":"Silicon Cloud Blog"},"image":{"@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/SiliCloudGlobal\/","https:\/\/twitter.com\/SiliCloudGlobal"]},{"@type":"Person","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/a3e2658c2cb9fb2be95ae0a8861f4a64","name":"Ava Mitchell","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/15c63cd0564b4a2e07d611bcdffa296f6ea80e8db07c3091f43a84010514899d?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/15c63cd0564b4a2e07d611bcdffa296f6ea80e8db07c3091f43a84010514899d?s=96&d=mm&r=g","caption":"Ava Mitchell"},"url":"https:\/\/www.silicloud.com\/blog\/author\/avamitchell\/"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/6507","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/users\/9"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/comments?post=6507"}],"version-history":[{"count":2,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/6507\/revisions"}],"predecessor-version":[{"id":151268,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/6507\/revisions\/151268"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/media?parent=6507"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/categories?post=6507"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/tags?post=6507"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}