You are correct. db_files is set to 200 and there are 2 tempfiles. It turns out to be caused by PL/SQL parsing a clob to change one character string with another. Only it scans the entire lob every time it has to change a single character. Thanks for the responses. Ray -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Jonathan Lewis Sent: Thursday, September 28, 2006 2:40 PM To: oracle-l@xxxxxxxxxxxxx Subject: Re: Write Complete Waits P1 P2 Just a little addition to that: Check the db_files parameter in your spfile and subtract from 202 (the 'odd' file number you saw) and the result is the tempfile number Regards Jonathan Lewis http://www.oracle.com/technology/community/oracle_ace/ace1.html#lewis The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html Cost Based Oracle: Fundamentals http://www.jlcomp.demon.co.uk/cbo_book/ind_book.html -- //www.freelists.org/webpage/oracle-l
