Return-Path: Received: from ensim.rackshack.net (root@localhost) by orafaq.net (8.11.6/8.11.6) with ESMTP id h0DLPHv28892 for ; Mon, 13 Jan 2003 15:25:17 -0600 X-ClientAddr: 209.68.248.164 Received: from newsfeed.cts.com (newsfeed.cts.com [209.68.248.164]) by ensim.rackshack.net (8.11.6/8.11.6) with ESMTP id h0DLPHc28886 for ; Mon, 13 Jan 2003 15:25:17 -0600 Received: from fatcity.UUCP (uucp@localhost) by newsfeed.cts.com (8.9.3/8.9.3) with UUCP id KAA43388; Mon, 13 Jan 2003 10:06:59 -0800 (PST) Received: by fatcity.com (26-Feb-2001/v1.0g-b72/bab) via UUCP id 0052DDC7; Mon, 13 Jan 2003 09:25:28 -0800 Message-ID: Date: Mon, 13 Jan 2003 09:25:28 -0800 To: Multiple recipients of list ORACLE-L X-Comment: Oracle RDBMS Community Forum X-Sender: "Cary Millsap" Sender: root@fatcity.com Reply-To: ORACLE-L@fatcity.com Errors-To: ML-ERRORS@fatcity.com From: "Cary Millsap" Subject: RE: Recommendation for SQL Tuning Book Organization: Fat City Network Services, San Diego, California X-ListServer: v1.0g, build 72; ListGuru (c) 1996-2001 Bruce A. Bergman Precedence: bulk Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit The Pocket Reference has been helpful to many people. The book appears to be at least a handy summary of some relevant aspects of Oracle's documentation. However, various colleagues have convinced me that there are many statements in the book that you can disprove using careful tests. Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - Steve Adams's Miracle Master Class, Jan 13-15 Copenhagen - 2003 Hotsos Symposium, Feb 9-12 Dallas -----Original Message----- David Sent: Monday, January 13, 2003 3:39 AM To: Multiple recipients of list ORACLE-L Question for those who have gone before... Is there a consensus on the best book to use to teach myself SQL tuning under the cost-based optimiser, particularly the use of hints. I have lots of experience under the rule-based optimiser, so I need hard-core info on use of hints and other features, not the general principles of SQL. I have found "Oracle SQL Tuning Pocket Reference by Mark Gurry" which looks like it will fit the bill. Does anyone have a better suggestion? Thanks in advance. David Jones -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jones, David INET: David.Jones@acnielsen.co.uk Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Cary Millsap INET: cary.millsap@hotsos.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).