{"id":6214,"date":"2015-11-05T18:28:19","date_gmt":"2015-11-05T17:28:19","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/awr-when-ash-cpu-db-cpu\/"},"modified":"2015-11-05T18:28:19","modified_gmt":"2015-11-05T17:28:19","slug":"awr-when-ash-cpu-db-cpu","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/awr-when-ash-cpu-db-cpu\/","title":{"rendered":"AWR when ASH CPU &gt;&gt; DB CPU"},"content":{"rendered":"<h2>By Franck Pachot<\/h2>\n<p>.<br \/>\nI&#8217;ll present How to read an AWR report next month at UKOUG TECH15 and the first recommendation after checking Average Active Sessions is to verify that we are not in a CPU starvation situation. Here is a little demo to show how it looks like in an AWR report.<br \/>\n<!--more--><br \/>\nIn other words, I&#8217;ll demo the second line of:<\/p>\n<blockquote class=\"twitter-tweet\" data-width=\"500\" data-dnt=\"true\">\n<p lang=\"en\" dir=\"ltr\">Slide 21 provides an excellent summary!<a href=\"https:\/\/t.co\/jn64Sp8Plv\">https:\/\/t.co\/jn64Sp8Plv<\/a> <a href=\"https:\/\/t.co\/AQgq3cCMkh\">pic.twitter.com\/AQgq3cCMkh<\/a><\/p>\n<p>&mdash; Chris Antognini (@ChrisAntognini) <a href=\"https:\/\/twitter.com\/ChrisAntognini\/status\/661470038717808640?ref_src=twsrc%5Etfw\">November 3, 2015<\/a><\/p><\/blockquote>\n<p><script async src=\"https:\/\/platform.twitter.com\/widgets.js\" charset=\"utf-8\"><\/script><\/p>\n<h3>One session 100% in CPU<\/h3>\n<p>I&#8217;m doing the demo on a VM with 4 cores and I&#8217;m running a query that reads 15 million blocks from buffer cache, which means it run fully in CPU for nearly 5 minutes:<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Capture-l1-01.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Capture-l1-01.jpg\" alt=\"Capture-l1-01\" width=\"614\" height=\"290\" class=\"alignnone size-full wp-image-5182\" \/><\/a><\/p>\n<p>From the load profile above we are actually using 1 second of CPU per second, which confirms that my session was able to run in CPU 100% of the time.<\/p>\n<p>It&#8217;s the only activity in that database, so I see nearly 100% of the DB time spent in CPU:<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Capture-l1-02.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Capture-l1-02.jpg\" alt=\"Capture-l1-02\" width=\"620\" height=\"107\" class=\"alignnone size-full wp-image-5181\" \/><\/a><\/p>\n<p>From the host, it&#8217;s the only instance running there, using 1 of the 4 vCPU &#8211; which means 25% utilization:<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Capture-l1-03.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Capture-l1-03.jpg\" alt=\"Capture-l1-03\" width=\"615\" height=\"149\" class=\"alignnone size-full wp-image-5180\" \/><\/a><\/p>\n<p>I&#8217;ve set timed_os_statistics to gather OS statistics every 10 seconds. We can see that most context switches are voluntary ones (when doing a system call):<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Capture-l1-04.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Capture-l1-04.jpg\" alt=\"Capture-l1-04\" width=\"519\" height=\"147\" class=\"alignnone size-full wp-image-5179\" \/><\/a><\/p>\n<p>Finally I check ASH:<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Capture-l1-05.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Capture-l1-05.jpg\" alt=\"Capture-l1-05\" width=\"626\" height=\"154\" class=\"alignnone size-full wp-image-5178\" \/><\/a><\/p>\n<p>29 samples (taken every 10 seconds) are in CPU or Wait for CPU which covers nearly 100% of the 292.1 seconds of DB CPU.<\/p>\n<p>This is the &#8216;normal&#8217; case.<\/p>\n<h3>One session 100% + four processes in CPU<\/h3>\n<p>Now, in addition to my Oracle session I run 4 processes that also want to run on CPU all the time:<\/p>\n<pre><code>\ndd if=\/dev\/random of=\/dev\/null&amp;\ndd if=\/dev\/random of=\/dev\/null&amp;\ndd if=\/dev\/random of=\/dev\/null&amp;\ndd if=\/dev\/random of=\/dev\/null&amp;\n<\/code><\/pre>\n<p>I introduced contention on the server, thus the time to run the same workload in the database has increased:<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Capture-l5-01.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Capture-l5-01.jpg\" alt=\"Capture-l5-01\" width=\"610\" height=\"422\" class=\"alignnone size-full wp-image-5177\" \/><\/a><\/p>\n<p>You see here that DB time has increased because it includes the time to wait for CPU in runqueue, but the DB CPU(s) per second is now only 0.8 because my session was about 20% of its time waiting for CPU (5 processes sharing only 4 vCPUs).<\/p>\n<p>The main symptom of that is on the Top events where the total is far less than 100% because of the unaccounted time waiting in runqueue:<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Capture-l5-02.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Capture-l5-02.jpg\" alt=\"Capture-l5-02\" width=\"615\" height=\"131\" class=\"alignnone size-full wp-image-5176\" \/><\/a><\/p>\n<p>Look at the load average that is higher than the number of vCPUs:<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Capture-l5-03.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Capture-l5-03.jpg\" alt=\"Capture-l5-03\" width=\"608\" height=\"154\" class=\"alignnone size-full wp-image-5175\" \/><\/a><\/p>\n<p>Lot of time in context switching (system CPU) and my instance is using only 1\/5 of the total CPU used.<\/p>\n<p>The OS has to share the cpu among the processes. this is why we see more &#8216;involuntary context switches&#8217; than voluntary ones:<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Capture-l5-04.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Capture-l5-04.jpg\" alt=\"Capture-l5-04\" width=\"510\" height=\"150\" class=\"alignnone size-full wp-image-5174\" \/><\/a><\/p>\n<p>Now comparing with ASH:<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Capture-l5-05.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Capture-l5-05.jpg\" alt=\"Capture-l5-05\" width=\"626\" height=\"168\" class=\"alignnone size-full wp-image-5173\" \/><\/a><\/p>\n<p>460 seconds (46 samples taken every 10 seconds) in CPU is far more than the DB CPU (362.8) because 20% of the time was spent waiting for CPU, because of involuntary context switches, because of CPU starvation.<\/p>\n<p>Note that the time waiting in runqueue after a wait event (system call &#8211; voluntary context switch) is not accounted as &#8216;Wait for CPU&#8217; but is accounted in the wait event waiting time, for the simple reason that the accounting (which is done by a few CPU instructions) can&#8217;t be done before the process is back in CPU. A consequence of that is inflated wait time. I don&#8217;t have lot of waits here, but you can see that &#8216;db file sequential read&#8217; is on average less than one millisecond in the first case, but has been inflated to 6 milliseconds when CPU had to be shared by lot of processes.<\/p>\n<p>I usually don&#8217;t look at ADDM report, but there is a little clue about that in it &#8211; unfortunately not the Top-1 finding:<\/p>\n<pre><code>\nFinding 2: CPU Usage\nImpact is .06 active sessions, 5.7% of total activity.\n------------------------------------------------------\nHost CPU was a bottleneck and the instance was consuming 26% of the host CPU.\nAll wait times will be inflated by wait for CPU.\nHost CPU consumption was 100%.\n&nbsp;\n   Recommendation 1: Application Analysis\n   Estimated benefit is 1 active sessions, 100% of total activity.\n...\n   Recommendation 2: Host Configuration\n   Estimated benefit is .06 active sessions, 5.7% of total activity.\n...\n<\/code><\/pre>\n<p>The recommendations are not good either. My problem is on the host, outside of this database instance. It&#8217;s the rare case where we have to check at system level before looking at application&#8230;<\/p>\n<p>Conclusion: if you are CPU-bound, the most important numbers in the AWR report (wait events) are meaningless. I wanted to show that kind of report here. At TECH15 presentation I just warn about it and then show how I read a report that is relevant. Hope to see you <a href=\"http:\/\/www.tech15.ukoug.org\/default.asp?p=12861&amp;dlgact=shwprs&amp;prs_prsid=10652&amp;day_dayid=94\" target=\"_blank\" rel=\"noopener noreferrer\">there<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>By Franck Pachot . I&#8217;ll present How to read an AWR report next month at UKOUG TECH15 and the first recommendation after checking Average Active Sessions is to verify that we are not in a CPU starvation situation. Here is a little demo to show how it looks like in an AWR report.<\/p>\n","protected":false},"author":27,"featured_media":6225,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[229,59],"tags":[699,423,96],"type_dbi":[],"class_list":["post-6214","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database-administration-monitoring","category-oracle","tag-ash","tag-cpu","tag-oracle"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.2 (Yoast SEO v27.2) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>AWR when ASH CPU &gt;&gt; DB CPU - 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\/awr-when-ash-cpu-db-cpu\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"AWR when ASH CPU &gt;&gt; DB CPU\" \/>\n<meta property=\"og:description\" content=\"By Franck Pachot . I&#8217;ll present How to read an AWR report next month at UKOUG TECH15 and the first recommendation after checking Average Active Sessions is to verify that we are not in a CPU starvation situation. Here is a little demo to show how it looks like in an AWR report.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/awr-when-ash-cpu-db-cpu\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2015-11-05T17:28:19+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Capture-l5-05-1.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"626\" \/>\n\t<meta property=\"og:image:height\" content=\"168\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\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\/awr-when-ash-cpu-db-cpu\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/awr-when-ash-cpu-db-cpu\/\"},\"author\":{\"name\":\"Oracle Team\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\"},\"headline\":\"AWR when ASH CPU &gt;&gt; DB CPU\",\"datePublished\":\"2015-11-05T17:28:19+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/awr-when-ash-cpu-db-cpu\/\"},\"wordCount\":657,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/awr-when-ash-cpu-db-cpu\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Capture-l5-05-1.jpg\",\"keywords\":[\"ASH\",\"CPU\",\"Oracle\"],\"articleSection\":[\"Database Administration &amp; Monitoring\",\"Oracle\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/awr-when-ash-cpu-db-cpu\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/awr-when-ash-cpu-db-cpu\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/awr-when-ash-cpu-db-cpu\/\",\"name\":\"AWR when ASH CPU &gt;&gt; DB CPU - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/awr-when-ash-cpu-db-cpu\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/awr-when-ash-cpu-db-cpu\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Capture-l5-05-1.jpg\",\"datePublished\":\"2015-11-05T17:28:19+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/awr-when-ash-cpu-db-cpu\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/awr-when-ash-cpu-db-cpu\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/awr-when-ash-cpu-db-cpu\/#primaryimage\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Capture-l5-05-1.jpg\",\"contentUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Capture-l5-05-1.jpg\",\"width\":626,\"height\":168},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/awr-when-ash-cpu-db-cpu\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"AWR when ASH CPU &gt;&gt; DB CPU\"}]},{\"@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":"AWR when ASH CPU &gt;&gt; DB CPU - 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\/awr-when-ash-cpu-db-cpu\/","og_locale":"en_US","og_type":"article","og_title":"AWR when ASH CPU &gt;&gt; DB CPU","og_description":"By Franck Pachot . I&#8217;ll present How to read an AWR report next month at UKOUG TECH15 and the first recommendation after checking Average Active Sessions is to verify that we are not in a CPU starvation situation. Here is a little demo to show how it looks like in an AWR report.","og_url":"https:\/\/www.dbi-services.com\/blog\/awr-when-ash-cpu-db-cpu\/","og_site_name":"dbi Blog","article_published_time":"2015-11-05T17:28:19+00:00","og_image":[{"width":626,"height":168,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Capture-l5-05-1.jpg","type":"image\/jpeg"}],"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\/awr-when-ash-cpu-db-cpu\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/awr-when-ash-cpu-db-cpu\/"},"author":{"name":"Oracle Team","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"headline":"AWR when ASH CPU &gt;&gt; DB CPU","datePublished":"2015-11-05T17:28:19+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/awr-when-ash-cpu-db-cpu\/"},"wordCount":657,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/awr-when-ash-cpu-db-cpu\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Capture-l5-05-1.jpg","keywords":["ASH","CPU","Oracle"],"articleSection":["Database Administration &amp; Monitoring","Oracle"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/awr-when-ash-cpu-db-cpu\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/awr-when-ash-cpu-db-cpu\/","url":"https:\/\/www.dbi-services.com\/blog\/awr-when-ash-cpu-db-cpu\/","name":"AWR when ASH CPU &gt;&gt; DB CPU - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/awr-when-ash-cpu-db-cpu\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/awr-when-ash-cpu-db-cpu\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Capture-l5-05-1.jpg","datePublished":"2015-11-05T17:28:19+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/awr-when-ash-cpu-db-cpu\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/awr-when-ash-cpu-db-cpu\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/awr-when-ash-cpu-db-cpu\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Capture-l5-05-1.jpg","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Capture-l5-05-1.jpg","width":626,"height":168},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/awr-when-ash-cpu-db-cpu\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"AWR when ASH CPU &gt;&gt; DB CPU"}]},{"@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\/6214","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=6214"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/6214\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/6225"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=6214"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=6214"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=6214"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=6214"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}