Yes sort of but you don't want to hear how they simulated it. Ugly! FYI...Timed_statistics were on. -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of ryan.gaffuri@xxxxxxx Sent: Thursday, June 03, 2004 4:27 AM To: oracle-l@xxxxxxxxxxxxx Subject: Re: RE: SQL*Net message from client From the way your update is written, it looks like it is running inside of a pl/sql loop. Am I correct? culprit number one, dml inside loops are hideously slow. Inspite of what several books say.... Not sure why that would cause sqlnet waits. > PARSING IN CURSOR #6 len=336 dep=0 uid=19 oct=6 lid=19 tim=1248377797 > hv=3885370321 ad='a7027a74' > UPDATE warehouse.summary_hits_fact shf > SET (hit_count) = > (SELECT count(*) > FROM hits_fact hf > WHERE shf.page_hit_key = hf.page_hit_key > AND shf.hit_date_key = hf.hit_date_key) > WHERE shf.page_hit_key = :p1 > AND shf.hit_date_key = :p2 ---------------------------------------------------------------- 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 -----------------------------------------------------------------