RE: write complete waits
- From: "Kevin Closson" <kevinc@xxxxxxxxxxxxx>
- To: <new_dba_on_the_block@xxxxxxxxx>
- Date: Tue, 21 Jun 2005 09:48:23 -0700
>
>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@xxxxxxxxx> wrote:
>
>> http://www.ixora.com.au/tips/mystery.doc
>>
>> On 6/21/05, Naveen <new_dba_on_the_block@xxxxxxxxx>
>> 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
>
>--
>//www.freelists.org/webpage/oracle-l
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
