Write Complete Waits P1 P2

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

--

http://www.freelists.org/webpage/oracle-l Received on Tue Sep 26 2006 - 02:43:48 CDT