Oracle Performance and Engineering
Random notes on database features, code, practice, optimization and techniques.Tuesday, April 26, 2005
A nice (and free!) resource profiler
I stumbled across this today. Tested with a few large trace files and guess what, it works very well. That it's free can only add to my excitement.
Hotsos profiler, designed by the Cary Millsap, however can provide bind variable histograms.
Read a very interesting, and deviant, comment regarding Cary's "Optimizing Oracle Performance" book here. I always rated Cary's book pretty highly - but not for the things it teaches you. It's good to have a great 30,000 ft view of performance analysis and tuning, specially when you read the first part. If I'm a starter, I would most definitely not read this book till I finish my Concepts manual, administrator's manual, hang around in the 'field' for a couple of years before I do that. If I am a 'mid-level' guy - I would still not carry this book with me everywhere I go. I would read this book, however, as soon as I finish with 'Practical Oracle 8i', 'Expert One-on-One on Oracle', 'Effective Oracle by Design' and 'Mastering Oracle PL/SQL'. If I am an instructor or performance 'evangelist', lead a team of 15 people doing performance stuff - this book will be much higher on my reading list though. But then, this would not be restricted to analyze Oracle specific issues *only*.
Hotsos profiler, designed by the Cary Millsap, however can provide bind variable histograms.
Read a very interesting, and deviant, comment regarding Cary's "Optimizing Oracle Performance" book here. I always rated Cary's book pretty highly - but not for the things it teaches you. It's good to have a great 30,000 ft view of performance analysis and tuning, specially when you read the first part. If I'm a starter, I would most definitely not read this book till I finish my Concepts manual, administrator's manual, hang around in the 'field' for a couple of years before I do that. If I am a 'mid-level' guy - I would still not carry this book with me everywhere I go. I would read this book, however, as soon as I finish with 'Practical Oracle 8i', 'Expert One-on-One on Oracle', 'Effective Oracle by Design' and 'Mastering Oracle PL/SQL'. If I am an instructor or performance 'evangelist', lead a team of 15 people doing performance stuff - this book will be much higher on my reading list though. But then, this would not be restricted to analyze Oracle specific issues *only*.
Archives
January 2005 February 2005 March 2005 April 2005 May 2005 March 2006 April 2006 August 2006 September 2006 October 2006 January 2007 May 2008
