DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 12

Thread: SQL tuning GOOD book recommendation ?

  1. #1
    Join Date
    Sep 2000
    Location
    Chicago, IL
    Posts
    316

    SQL tuning GOOD book recommendation ?

    Can anyone recommend a good SQL Tuning perf. book, that cover DBMS_STATS options in details, etc, etc.

    Most of the ones I have thumbed thru talk about how to gather stats, but not what all the options mean, and what is the preffered way to analyze: example: for all columns, or for all index columns, etc, etc.

  2. #2
    Join Date
    Jan 2002
    Location
    Netherlands
    Posts
    1,587
    A combination of these 2 books is the best that I can think of...
    http://www.amazon.com/exec/obidos/AS...246170-3273738
    Tarry Singh
    I'm a JOLE(JavaOracleLinuxEnthusiast)
    TarryBlogging
    --- Everything was meant to be---

  3. #3
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    I too would recommend Guy Harrison's book. (Tom Kyte's long-awaited, but yet unpublished, new book is likely to be a good bet.)

  4. #4
    Join Date
    Oct 2002
    Location
    Breda, The Netherlands
    Posts
    317
    mr DaPi:

    Which book of Tom Kyte are you referring to? A new version of Expert one-on-one? I would really want one that also covers Oracle9i...
    An expert is one who knows more and more about less and less until he knows absolutely everything about nothing.

  5. #5
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142

  6. #6
    Join Date
    Sep 2000
    Location
    Chicago, IL
    Posts
    316
    Guy Harrison's book "Oracle SQL High-Performance Tuning " was published in Dec 2000 ! Those who have it: Are you recommending it for the explaination of the concepts, not necessarily for the implementation of Oracle options ?

    Also, I have Tom Kyte's book, and it does not have what I am looking for either !

  7. #7
    Join Date
    Nov 2002
    Location
    Dublin, Ireland
    Posts
    133
    Originally posted by khussain

    Also, I have Tom Kyte's book, and it does not have what I am looking for either !
    That's why Tom Kyte's site exists to help him improving his book
    Giani

  8. #8
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    Originally posted by khussain
    Guy Harrison's book "Oracle SQL High-Performance Tuning " was published in Dec 2000 ! Those who have it: Are you recommending it for the explaination of the concepts, not necessarily for the implementation of Oracle options ?

    Also, I have Tom Kyte's book, and it does not have what I am looking for either !
    Go for the concepts; the details will come with a little RTFM. Three chapters of Harrison's book would have fixed nearly every performance prob I've seen posted here.

    Don't see how you can have Kyte's new book - it's not published yet!

  9. #9
    Join Date
    Sep 2000
    Location
    Chicago, IL
    Posts
    316
    Originally posted by DaPi
    Don't see how you can have Kyte's new book - it's not published yet!
    I did not say I had his NEW book, I am talking about his old book, Published 2001.

  10. #10
    Join Date
    Sep 2000
    Location
    Chicago, IL
    Posts
    316
    The asktom site is great... I was able to learn a lot from the examples that he gives - great.
    Last edited by khussain; 06-20-2003 at 12:36 PM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width