...And the Oracle7 Server Space Management paper, too! Tim's is a good one that I don't think I had seen. Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com * Nullius in verba * Upcoming events: - Performance Diagnosis 101: 2/24 San Diego, 3/23 Park City, 4/6 Seattle - SQL Optimization 101: 2/16 Dallas - Hotsos Symposium 2004: March 7-10 Dallas - Visit www.hotsos.com for schedule details... -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Bobak, Mark Sent: Monday, February 09, 2004 4:31 PM To: oracle-l@xxxxxxxxxxxxx Subject: RE: RE: Dead slow count(*) There is also "Performance Managment Myths and Facts", by Cary Millsap, = available from http://www.hotsos.com/. -Mark -----Original Message----- From: ryan.gaffuri@xxxxxxx [mailto:ryan.gaffuri@xxxxxxx] Sent: Monday, February 09, 2004 5:22 PM To: oracle-l@xxxxxxxxxxxxx Subject: RE: RE: Dead slow count(*) here is an old one by Gaja Vaidyanatha. He is a co-auther of perf tuning = 101.=20 http://www.quest-pipelines.com/newsletter-v3/0302_F.htm I think Niall Litchfield wrote a newer one?=20 >=20 > From: Nikhil Khimani <nkhimani@xxxxxxxxxxxxxxx> > Date: 2004/02/09 Mon PM 05:14:58 EST > To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx> > Subject: RE: RE: Dead slow count(*) >=20 > L&G, >=20 > Is there a URL for "Known Oracle Myth?" > Sometimes, it's difficult to argue with an individual when he/she = feeds you > the bs with a passion and by the time you learned the myth, it's too = late to > bark back :-( >=20 > Thanks, > =20 > Nikhil Khimani > Market Axess > 140 Broadway, 42nd Floor > New York, NY 10005 > =20 > (212) 813-6230 (W) > nkhimani@xxxxxxxxxxxxxxx >=20 >=20 > -----Original Message----- > From: ryan.gaffuri@xxxxxxx [mailto:ryan.gaffuri@xxxxxxx] > Sent: Monday, February 09, 2004 4:59 PM > To: oracle-l@xxxxxxxxxxxxx > Subject: Re: RE: Dead slow count(*) >=20 >=20 > number of extents does not matter in a query. common myth. I think = there is > a paper from about 5 years ago with common myths in it and that was = one of > them. Could be wrong.=20 >=20 > high water only matters if your not using an index.=20 > ---------------------------------------------------------------- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > ---------------------------------------------------------------- > To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx > put 'unsubscribe' in the subject line. > -- > Archives are at //www.freelists.org/archives/oracle-l/ > FAQ is at //www.freelists.org/help/fom-serve/cache/1.html > ----------------------------------------------------------------- >=20 ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------