Thinking about CPU

Doug's Oracle Blog

  • Home
  • Papers
  • Books
  • C.V.
  • Fun
  • Oracle Blog
  • Personal Blog

Feb 9: Thinking about CPU

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 issues to people and even pointing out that

"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 – at any one instant a CPU cannot be 75% busy."

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.

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 about optimum post-length but I hope I'm wrong in this case and people give it a chance.

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

I'll rest happy when 'CPU utilisation is still below 100%' has stopped being the golden metric!

(... and, no, this is not the long-awaited technical posts starting, but Charles is saving me the bother of all that stuff! ;-)
Posted by Doug Burns Comment: (1) Trackbacks: (0)

Trackbacks
Trackback specific URI for this entry

No Trackbacks

Comments
Display comments as (Linear | Threaded)

#1 - Martin Widlake said:
2010-02-11 15:15 - (Reply)

I have to write long blogs Doug, its my only chance to make up for all the time I spend in the pub listening to you and failing to get a word in edgeways :-)

Seriously though, I'm looking forward to the technical series you are working up to.


Add Comment

Standard emoticons like :-) and ;-) are converted to images.
E-Mail addresses will not be displayed and will only be used for E-Mail notifications.
BBCode format allowed
 
 

Statistics on Partitioned Tables

Contents

Part 1 - Default options - GLOBAL AND PARTITION
Part 2 - Estimated Global Stats
Part 3 - Stats Aggregation Problems I
Part 4 - Stats Aggregation Problems II
Part 5 - Minimal Stats Aggregation
Part 6a - COPY_TABLE_STATS - Intro
Part 6b - COPY_TABLE_STATS - Mistakes
Part 6c - COPY_TABLE_STATS - Bugs and Patches
Part 6d - COPY_TABLE_STATS - A Light-bulb Moment
Part 6e - COPY_TABLE_STATS - Bug 10268597

A couple of posts about Incremental Stats confusion

Part 1
Part 2

Comments

personal blog about Moving Sideways
Wed, 01.06.2016 18:34
That is a good tip particularl y to those fresh to the blogos phere. Short [...]
odziezprestige.pl about Moving Sideways
Wed, 01.06.2016 17:07
Please let me know if you're l ooking for a article writer fo r your site. [...]
Doug Burns about Moving Sideways
Tue, 10.05.2016 22:43
Oh, I won't give it that long unless I enjoy it ;-)

Bookmark

Open All | Close All

Syndicate This Blog

  • XML RSS 2.0 feed
  • ATOM/XML ATOM 1.0 feed
  • XML RSS 2.0 Comments
  • Feedburner Feed

Powered by

Serendipity PHP Weblog

Show tagged entries

xml 11g
xml ACE
xml adaptive thresholds
xml ASH
xml Audit Vault
xml AWR
xml Blogging
xml conferences
xml Cuddly Toys
xml Database Refresh
xml dbms_stats
xml Direct Path Reads
xml Fun
xml Grid Control
xml hotsos 2010
xml listener
xml locking
xml oow
xml oow2009
xml optimiser
xml OTN
xml Parallel
xml partitions
xml Patching
xml Swingbench
xml The Reality Gap
xml Time Matters
xml ukoug
xml ukoug2009
xml Unix/Shell
xml Useful Links

Disclaimer

For the avoidance of any doubt, all views expressed here are my own and not those of past or current employers, clients, friends, Oracle Corporation, my Mum or, indeed, Flatcat. If you want to sue someone, I suggest you pick on Tigger, but I hope you have a good lawyer. Frankly, I doubt any of the former agree with my views or would want to be associated with them in any way.

Design by Andreas Viklund | Conversion to s9y by Carl