Re: write complete waits

From: Naveen <new_dba_on_the_block_at_yahoo.com>
Date: Tue, 21 Jun 2005 07:23:34 -0700 (PDT)
Message-ID: <20050621142334.83996.qmail@web53302.mail.yahoo.com>

Thanx David,

The document you sent is too good. But honestly it is too much for a new dba like me!

Anyways, I'll go through the document in detail but it will take some reading!

What is strange is that I see these waits for the temporary tablespace files and not for datafiles.

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

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

Received on Tue Jun 21 2005 - 10:28:47 CDT