RE: write complete waits

 >
>How would the blocks of temporary tablespace get dirty when
>they are only used for sort segments etc.

that is by definition, dirty. Just be glad that this I/O burden is no longer backgrounded to DBWR...having the shadow processes do direct path writes is quite an improvement in Oracle.

If you gave us some info about the platform, and particularly where the TEMP files are (fs type, etc), we could likely help out. A general idea of processor utilization would help as well.

Kevin Closson
Chief Architect, Database Solutions
PolyServe
www.polyserve.com

>
>Naveen
>
>--- David Sharples <davidsharples_at_gmail.com> wrote:
>
>> http://www.ixora.com.au/tips/mystery.doc
>>
>> On 6/21/05, Naveen <new_dba_on_the_block_at_yahoo.com>
>> wrote:
>> > Hi All,
>>
>> >
>> > Please let me know what might be causing the high
>> wait
>> > times as well as high frequency of the wait.
>> >
>> > Naveen
>>
>
>
>
>
>__________________________________
>Yahoo! Mail
>Stay connected, organized, and protected. Take the tour:
>http://tour.mail.yahoo.com/mailtour.html
>
>--
>http://www.freelists.org/webpage/oracle-l
>

--
http://www.freelists.org/webpage/oracle-l