Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Statspack Book Reference - Recommendation?

Re: Statspack Book Reference - Recommendation?

From: Oradba Linux <oradba_linux_at_attbi.com>
Date: Thu, 30 Jan 2003 23:57:17 GMT
Message-ID: <pan.2003.01.30.23.58.26.79812@attbi.com>


On Thu, 30 Jan 2003 11:27:25 +0300, John Gordon wrote:

> See
> 
> http://www.statsviewer.narod.ru/
> 
> 
> "Casi Schmid" <casimir.schmid_at_swisscom.com> wrote in message
> news:1043885238.771738_at_exnews...

>> Dear all
>>
>> I'm experiencing with Oracle Statspack on 8, 8i and 9i databases running
>> under RedHat Linux, Sun Solaris, HP-UX, Windows NT 4.0 and Windows 2000
>> Advanced Server.
>>
>> Can you recommend me any good books about how to interpret the results
>> getting from the StatsPack reports as well as from the html-output from
>> www.oraperf.com? I'd like to use a tool like StatsPack to get fast
>> results with tuning - I do not have enough time to go deep into the
>> rdbms.
>>
>>
>> I quick found these...
>>
>> Oracle High-Performance Tuning with STATSPACK by Donald Keith
>> Burleson, Don Burleson
>> Paperback: 674 pages ; Dimensions (in inches): 1.60 x 9.14 x 7.42
>> Publisher: McGraw-Hill Osborne Media; ; (April 20, 2001) ISBN:
>> 0072133783
>>
>> --> seems to be old
>>
>>
>> Oracle9i High-Performance Tuning with STATSPACK by Donald K. Burleson,
>> Don Burleson
>> Paperback: 645 pages ; Dimensions (in inches): 1.62 x 9.12 x 7.40
>> Publisher: McGraw-Hill Osborne Media; ; (March 22, 2002) ISBN:
>> 007222360X
>>
>> --> seems to be the second edtition of the one above, does it also cover
>> 8 and 8i?
>>
>>
>> Oracle SQL High-Performance Tuning (2nd Edition) by Guy Harrison
>> Paperback: 656 pages ; Dimensions (in inches): 1.80 x 9.18 x 6.98
>> Publisher: Prentice Hall PTR; ; 2nd edition (December 29, 2000) ISBN:
>> 0130123811
>>
>> --> seems to be good (amazon user reviews), does it also cover
>> StatsPack?
>>
>>
>> Oracle Performance Tuning (Nutshell Handbook) [BARGAIN PRICE] by Mark
>> Gurry, Peter Corrigan
>> Paperback: 964 pages
>> Publisher: O'Reilly & Associates; ; 2nd edition (November 1996) ISBN:
>> B00007FYAO
>>
>> --> Oreilly normally stands for quality, but this is rather old -
>> covering 9i or just 8 and 8i? What about StatsPack?
>>
>>
>> Oracle Performance Tuning 101
>> by Gaja Krishna Vaidyanatha, Kirtikumar Deshpande, Jr. John A. Kostelac
>> Paperback: 404 pages ; Dimensions (in inches): 1.17 x 9.18 x 7.42
>> Publisher: McGraw-Hill Osborne Media; ; (May 29, 2001) ISBN: 0072131454
>>
>> --> again, does it also cover StatsPack?
>>
>>
>> Oracle Performance Tuning Tips and Techniques by Richard J. Niemiec, Joe
>> Trezzo, Rich Niemiec, Bradley D. Brown, Joseph
> C.

>> Trezzo
>> Paperback: 894 pages ; Dimensions (in inches): 2.21 x 9.12 x 7.41
>> Publisher: McGraw-Hill Osborne Media; ; (April 1, 1999) ISBN: 0078824346
>>
>> --> again, does it also cover StatsPack?
>>
>>
>> Oracle8i and Unix Performance Tuning
>> by Ahmed Alomari
>> Paperback: 448 pages ; Dimensions (in inches): 1.10 x 9.28 x 7.03
>> Publisher: Prentice Hall PTR; ; 1st edition (September 15, 2000) ISBN:
>> 0130187062
>>
>> --> optimal for Unix? which distribution? Linux too?
>>
>>
>> Oracle9i Performance Tuning Tips & Techniques by Rich Niemiec, Richard
>> J. Niemiec, Bradley D. Brown, Raymond J. Lane Paperback: 750 pages
>> Publisher: McGraw-Hill Osborne Media; ; (April 18, 2003) ISBN:
>> 0072224738
>>
>> --> Tuning in general - additional book to a good StatsPack book?
>>
>>
>> I found also this article, what is your opinion about it?
>> http://www.dba-oracle.com/review_hp_tuning_statspack.htm
>>
>>
>>
>> thanks in advance for your replies
>>
>> Casi Schmid
>> Oracle DBA - Swisscom Switzerland
>>
>>
>>
>>
>>
>>
>>
>>
>>

Did you read tom kyte's book ? It has a section about interpreting statspack report . I thought it was pretty good though i have not read don burleson's statspack book . Received on Thu Jan 30 2003 - 17:57:17 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US