+ Reply to Thread
Page 1 of 2 1 2 LastLast
Results 1 to 10 of 12
  1. 06-19-2003 04:56 PM #1
    khussain
    khussain is offline Senior Member
    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.
    Reply With Quote Reply With Quote
  2. 06-20-2003 03:00 AM #2
    Tarry's Avatar
    Tarry
    Tarry is offline Senior Advisor
    Join Date
    Jan 2002
    Location
    Netherlands
    Posts
    1,591
    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---
    Reply With Quote Reply With Quote
  3. 06-20-2003 03:21 AM #3
    DaPi's Avatar
    DaPi
    DaPi is offline Old Cranky Philosopher
    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.)
    Reply With Quote Reply With Quote
  4. 06-20-2003 05:22 AM #4
    efrijters's Avatar
    efrijters
    efrijters is offline humble grasshopper
    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.
    Reply With Quote Reply With Quote
  5. 06-20-2003 08:08 AM #5
    DaPi's Avatar
    DaPi
    DaPi is offline Old Cranky Philosopher
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    Here is a preview:
    http://asktom.oracle.com/pls/ask/f?p...8145042756282,
    Reply With Quote Reply With Quote
  6. 06-20-2003 09:23 AM #6
    khussain
    khussain is offline Senior Member
    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 !
    Reply With Quote Reply With Quote
  7. 06-20-2003 09:33 AM #7
    Giani's Avatar
    Giani
    Giani is offline Oracle DBA
    Join Date
    Nov 2002
    Location
    Dublin, Ireland
    Posts
    132
    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
    Reply With Quote Reply With Quote
  8. 06-20-2003 10:33 AM #8
    DaPi's Avatar
    DaPi
    DaPi is offline Old Cranky Philosopher
    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!
    Reply With Quote Reply With Quote
  9. 06-20-2003 10:43 AM #9
    khussain
    khussain is offline Senior Member
    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.
    Reply With Quote Reply With Quote
  10. 06-20-2003 11:56 AM #10
    khussain
    khussain is offline Senior Member
    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.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Bookmarks

Posting Permissions

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

Forum Rules

 Click Here to Expand Forum to Full Width