RE: Website that contains materials about performance tuning of S
You might be able to find what you need at this site. http://web.singnet.com.sg/~petermag/oracle.html Dave -Original Message- Sent: Tuesday, October 22, 2002 8:39 PM To: Multiple recipients of list ORACLE-L S Hi, Does anyone know of any web site that contains materials about performance tuning of SQL (oracle or any other database) ? TIA Regds, New Bee -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: CHAN Chor Ling Catherine (CSC) INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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.com -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Website that contains materials about performance tuning of S
Wow. Thanks, Dave! I dropped this msg in the wastebasket, then for some reason went back and gave it a second look. Glad I did. Nicely organized. Barb -- From: Farnsworth, Dave[SMTP:[EMAIL PROTECTED]] Reply To: [EMAIL PROTECTED] Sent: Wednesday, October 23, 2002 8:43 AM To: Multiple recipients of list ORACLE-L Subject: RE: Website that contains materials about performance tuning of S You might be able to find what you need at this site. http://web.singnet.com.sg/~petermag/oracle.html Dave -Original Message- Sent: Tuesday, October 22, 2002 8:39 PM To: Multiple recipients of list ORACLE-L S Hi, Does anyone know of any web site that contains materials about performance tuning of SQL (oracle or any other database) ? TIA Regds, New Bee -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: CHAN Chor Ling Catherine (CSC) INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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.com -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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.com -- Author: Baker, Barbara INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: Website that contains materials about performance tuning of S
same here! thanks Dave! - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, October 23, 2002 9:15 AM Wow. Thanks, Dave! I dropped this msg in the wastebasket, then for some reason went back and gave it a second look. Glad I did. Nicely organized. Barb -- From: Farnsworth, Dave[SMTP:[EMAIL PROTECTED]] Reply To: [EMAIL PROTECTED] Sent: Wednesday, October 23, 2002 8:43 AM To: Multiple recipients of list ORACLE-L Subject: RE: Website that contains materials about performance tuning of S You might be able to find what you need at this site. http://web.singnet.com.sg/~petermag/oracle.html Dave -Original Message- Sent: Tuesday, October 22, 2002 8:39 PM To: Multiple recipients of list ORACLE-L S Hi, Does anyone know of any web site that contains materials about performance tuning of SQL (oracle or any other database) ? TIA Regds, New Bee -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: CHAN Chor Ling Catherine (CSC) INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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.com -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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.com -- Author: Baker, Barbara INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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.com -- Author: Tim Gorman INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Website that contains materials about performance tuning of S
New Bee If I understand your question, you are looking for information on how to tune SQL statements. Actually, I've been searching for something like this for quite a while. I glanced at the web link in Dave's reply, but I didn't see anything that directly addressed SQL statement tuning. If I overlooked something, maybe someone will point it out. Great list though, thanks Dave! I'm pretty sure you won't find a resource that is generic to all relational databases. Each database is free to choose how to execute a given SQL statement, so from what I've seen, SQL statement performance tuning tends to be very database-specific. For Oracle, the best resource I've found is a book (not free, but pretty inexpensive) Oracle SQL Tuning Pocket Reference by Mark Gurry from O'Reilly $12.95 U.S. However, it tries to cover both RBO and CBO. Also, it has been criticized for inaccuracies. Also, you may find more on basic SQL statement tuning if you search for EXPLAIN PLAN. Overall, I expected someone to publish a checklist of things to tune a SQL statement in the form: look for this, try this, then try this, etc. Since I haven't found such a checklist, maybe my expectations are unrealistic. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, October 22, 2002 8:39 PM To: Multiple recipients of list ORACLE-L S Hi, Does anyone know of any web site that contains materials about performance tuning of SQL (oracle or any other database) ? TIA Regds, New Bee -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: CHAN Chor Ling Catherine (CSC) INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Website that contains materials about performance tuning of S
Title: RE: Website that contains materials about performance tuning of S -Original Message- From: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED]] For Oracle, the best resource I've found is a book (not free, but pretty inexpensive) Oracle SQL Tuning Pocket Reference by Mark Gurry from O'Reilly $12.95 U.S. However, it tries to cover both RBO and CBO. Also, it has been criticized for inaccuracies. Any idea of where to find the inaccuracies? I recommended that book to several of the developers here.