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

Home -> Community -> Usenet -> c.d.o.misc -> Statspack Book Reference - Recommendation?

Statspack Book Reference - Recommendation?

From: Casi Schmid <casimir.schmid_at_swisscom.com>
Date: Thu, 30 Jan 2003 01:07:00 +0100
Message-ID: <1043885238.771738@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 Received on Wed Jan 29 2003 - 18:07:00 CST

Original text of this message

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