write complete waits
- From: Naveen <new_dba_on_the_block@xxxxxxxxx>
- To: ORACLE-L@xxxxxxxxxxxxx
- Date: Tue, 21 Jun 2005 06:58:58 -0700 (PDT)
Hi All,
I traced a couple of slow running sessions, and also
got the information from statspack and v$session_wait
views.
I saw a lot of "write complete waits" and the
seconds_in_wait column as high as 41 (state=waiting)
for that particular wait.
All the files for which the wait is happening (p1) are
files of temporary tablespace.
Please let me know what might be causing the high wait
times as well as high frequency of the wait.
Naveen
__________________________________
Discover Yahoo!
Stay in touch with email, IM, photo sharing and more. Check it out!
http://discover.yahoo.com/stayintouch.html
--
//www.freelists.org/webpage/oracle-l
Other related posts:
