Solved: Write Complete Waits P1 P2

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_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Jonathan Lewis
Sent: Thursday, September 28, 2006 2:40 PM To: oracle-l_at_freelists.org
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

--

http://www.freelists.org/webpage/oracle-l Received on Thu Sep 28 2006 - 00:24:47 CDT