She thought they said trains and the duhveloper missed his. Ruth -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Nuno Souto Sent: Tuesday, August 31, 2004 7:19 AM To: oracle-l@xxxxxxxxxxxxx Subject: Re: So how big is your buffer cache ? How does "executed 3000000 times a day" strike you then? Just got one.... and had to explain why it was not a good idea to write a batch Java process as a loop of: objtype objvar = new objtype(PK); and let the constructor method do the same SQL for every row! Sometimes I wonder if God ran out of brains when He was making the Java developer.... Cheers Nuno Souto nsouto@xxxxxxxxxxxxxx ----- Original Message ----- From: "Cary Millsap" <cary.millsap@xxxxxxxxxx> > bad SELECT statement can have the same effect. A SQL statement that = > reads > 10,000x as many PIO blocks as it needs, executed thousands of times per = > day, > results in a much busier I/O subsystem than you need. A busy I/O = > subsystem > makes it more difficult for DBWR to keep up, and this causes 'free = > buffer > waits' waits. ---------------------------------------------------------------- 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 -----------------------------------------------------------------