{"id":1561,"date":"2010-02-09T12:00:00","date_gmt":"2010-02-09T12:00:00","guid":{"rendered":"http:\/\/orcldoug.com\/blog\/?p=1561"},"modified":"2010-02-09T12:00:00","modified_gmt":"2010-02-09T12:00:00","slug":"thinking-about-cpu","status":"publish","type":"post","link":"http:\/\/orcldoug.com\/blog\/2010\/02\/09\/thinking-about-cpu\/","title":{"rendered":"Thinking about CPU"},"content":{"rendered":"

Charles Hooper<\/a> has written a number of impressive blog posts in a fairly short space of time (the man is a blogging machine<\/em>!) but I really wanted to draw attention to one in particular.

Fault Quotes 6 – CPU Utilization<\/a><\/p>\n

Why? Well I seem to be spending more and more of my time talking about these issues to people and even pointing out that <\/p>\n

“It is important to keep in mind that at any one instant, a CPU (or core or CPU instruction thread) is either 100% busy or 0% busy \u2013 at any one instant a CPU cannot be 75% busy.<\/em>“<\/p>\n

is a good start (let’s not start getting into multi-threaded cores or weird architectures until people get the basics right). I immediately passed the link around several good people at my current customer site and Twittered about it (which won’t be happening again 😉) but figured I should mention it here too.<\/p>\n

If I have one slight criticism, it’s that the post is *long* and you’ll need to put some time aside to read it, particularly if you click through all the links. I’ve had an ongoing discussion with Martin Widlake<\/a> about optimum post-length but I hope I’m wrong in this case and people give it a chance. <\/p>\n

Without offering any absolute answers, it’s thought-provoking stuff and if it does<\/em> make you think about queuing, throughput, CPU utilisation, averages or whatever, can I recommend Cary Millsap and Jeff Holt’s Optimizing Oracle Performance<\/a> (again)? It covers these subjects in more depth and with an Oracle slant.<\/p>\n

I’ll rest happy when ‘CPU utilisation is still below 100%’ has stopped being the golden metric!<\/p>\n

(… and, no, this is not the long-awaited technical posts starting, but Charles is saving me the bother of all that stuff! 😉<\/p>\n","protected":false},"excerpt":{"rendered":"

Charles Hooper has written a number of impressive blog posts in a fairly short space of time (the man is a blogging machine!) but I really wanted to draw attention to one in particular.Fault Quotes 6 – CPU Utilization Why? Well I seem to be spending more and more of my time talking about these… Continue reading Thinking about CPU<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-1561","post","type-post","status-publish","format-standard","hentry","category-uncategorized","entry"],"jetpack_featured_media_url":"","jetpack-related-posts":[{"id":1432,"url":"http:\/\/orcldoug.com\/blog\/2008\/09\/01\/time-matters-db-cpu\/","url_meta":{"origin":1561,"position":0},"title":"Time Matters – DB CPU","date":"September 1, 2008","format":false,"excerpt":"In his comment on the last post, John Beresniewicz mentioned the following property of DB CPU :-\"... 'DB time' fully contains 'DB CPU' and both are measured values (which means in particular that 'DB CPU' is not inflated by runq time)\"I'd like to talk about the end of that sentence\u2026","rel":"","context":"With 24 comments","img":{"alt_text":"","src":"https:\/\/i0.wp.com\/18.133.199.212\/wp-content\/uploads\/recovered\/DBCPU4.png?resize=350%2C200","width":350,"height":200},"classes":[]},{"id":1604,"url":"http:\/\/orcldoug.com\/blog\/2010\/05\/17\/resource-manager-and-11g\/","url_meta":{"origin":1561,"position":1},"title":"Resource Manager and 11g","date":"May 17, 2010","format":false,"excerpt":"I will get back to the stats stuff at some point, but I'm quite busy at the moment working on something that I can't talk too much about, but which is throwing up enough generic issues to talk about. This is one that I meant to blog about ages ago\u2026","rel":"","context":"With 5 comments","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1156,"url":"http:\/\/orcldoug.com\/blog\/2006\/12\/07\/a-more-complex-statspack-example-part-2\/","url_meta":{"origin":1561,"position":2},"title":"A More Complex Statspack Example – Part 2","date":"December 7, 2006","format":false,"excerpt":"So far we're barely into the comparison of the Statspack reports from the two different test environments and they look quite different already.Next up, the Instance Efficiency Percentages. I have to confess that I rarely find these very useful because the numbers are always near 100% on most databases I\u2026","rel":"","context":"With 13 comments","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":835,"url":"http:\/\/orcldoug.com\/blog\/2006\/03\/14\/px-and-the-magic-of-2\/","url_meta":{"origin":1561,"position":3},"title":"PX and “the Magic of 2”","date":"March 14, 2006","format":false,"excerpt":"Now that I've had time to sit back and relax and absorb things a little, I thought I should fix a couple of outright bugs in the recent PX paper (Later update - link to the paper) and revisit the conclusions before moving on to testing different aspects. First, the\u2026","rel":"","context":"With 2 comments","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1377,"url":"http:\/\/orcldoug.com\/blog\/2008\/01\/16\/cpus-again\/","url_meta":{"origin":1561,"position":4},"title":"CPUs again …","date":"January 16, 2008","format":false,"excerpt":"I'm pleased to see a few posts debating the (non)-application of quarterly Critical Patch Updates. Here are a few examples ...Is Poor Security Hygiene Rampant?Do DBAs care about Oracle\u2019s latest Critical Patch Update?Survey finds that 66% of Oracle users never install critical patchesAll of which seem to have been kicked\u2026","rel":"","context":"With 6 comments","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1428,"url":"http:\/\/orcldoug.com\/blog\/2008\/08\/14\/time-matters-an-infinite-capacity-for-waiting\/","url_meta":{"origin":1561,"position":5},"title":"Time Matters – An Infinite Capacity for Waiting*","date":"August 14, 2008","format":false,"excerpt":"When I was teaching the 10g Performance class at my last customer site, I remarked that the total number of seconds you see in the \"Top 5 Timed Events\" section of a Statspack or AWR report will often be greater than the total number of seconds between the snapshot intervals.\u2026","rel":"","context":"With 6 comments","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"_links":{"self":[{"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/posts\/1561","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/comments?post=1561"}],"version-history":[{"count":0,"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/posts\/1561\/revisions"}],"wp:attachment":[{"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/media?parent=1561"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/categories?post=1561"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/tags?post=1561"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}