Write Complete Waits P1 P2
- From: "Ray Feighery" <ray@xxxxxxxxxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 26 Sep 2006 17:43:48 +1000
Oracle 9.2.0.6
Solaris 8
I've got a dbms_job that hangs. Tracing the job shows massive amounts of
write complete waits:
*** 2006-09-26 13:08:01.500
WAIT #5: nam='write complete waits' ela= 976709 p1=202 p2=55183 p3=0
WAIT #5: nam='write complete waits' ela= 986042 p1=202 p2=55183 p3=0
WAIT #5: nam='write complete waits' ela= 986163 p1=202 p2=55185 p3=0
WAIT #5: nam='write complete waits' ela= 986249 p1=202 p2=55185 p3=0
Now I thought that the p1 and p2 values pointed to the file# and block#
values. However, there is no file with an id of 202 in this database:
SQL> select file# from file$;
FILE#
----------
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
20 rows selected.
What am I missing? And what could cause a process to wait for hours for
write complete waits
Ray
Other related posts:
