Solved: Write Complete Waits P1 P2

  • From: "Ray Feighery" <ray@xxxxxxxxxxxxxxxxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 28 Sep 2006 15:24:47 +1000

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.


-----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


Jonathan Lewis

The Co-operative Oracle Users' FAQ

Cost Based Oracle: Fundamentals


Other related posts:

  • » Solved: Write Complete Waits P1 P2