I see it about 50 times a year. Fortunately in this world of database self-management and (hence) = dwindling consulting opportunities, there are still some authors out there who are willing to put themselves on the line by writing career-threateningly = absurd articles that encourage readers to make plenty of profoundly bad = performance management mistakes so that we can all make a good living trying to fix them. :) [Let's see if THAT line-wraps funny...] Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com * Nullius in verba * Upcoming events: - Performance Diagnosis 101: 9/14 San Francisco, 10/5 Charlotte, 10/26 Toronto - SQL Optimization 101: 9/20 Hartford, 10/18 New Orleans - Hotsos Symposium 2005: March 6-10 Dallas - Visit www.hotsos.com for schedule details... -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx = [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of ryan gaffuri Sent: Wednesday, September 15, 2004 9:41 PM To: DGoulet@xxxxxxxx; Mark.Bobak@xxxxxxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx Subject: Re: Argh..... if your on a us government, bank, etc... project tell your boss there is = a 'security' issue with them. that should work. Tell him its reality to = that security patch oracle is releasing for 10g. My favorite database performance problem of all time.... A software = engineer called me over to tune a query. It was returning in between .2 and .6 seconds. He couldn't understand the fluctuations and was hoping I could = get it to return in less than .1 seconds. real problem was that he was retrieving 1 row at a time and running this from a loop 100,000 times. He said it was too much work to change the application. I can't be the only one who has had this one. ----- Original Message -----=20 From: "Goulet, Dick" <DGoulet@xxxxxxxx> To: <Mark.Bobak@xxxxxxxxxxxxxxx>; <oracle-l@xxxxxxxxxxxxx> Sent: Wednesday, September 15, 2004 5:35 PM Subject: RE: Argh..... > Mark, > > Wrong answer. Correct answer: > -- //www.freelists.org/webpage/oracle-l -- //www.freelists.org/webpage/oracle-l