Re: Write Complete Waits P1 P2

  • From: "Harish Kalra" <harish.kumar.kalra@xxxxxxxxx>
  • To: ray@xxxxxxxxxxxxxxxxxxxxx
  • Date: Thu, 28 Sep 2006 16:45:15 +0100

Hi Ray,

This could be a result of slow IO subsystem or DBWR is not performing well.
Sessions waits on this wait event when some process want to modify the data
blocks which are already marked by DBWR as "being written" and can not be
modified untill they are written to disk.

It would be useful to check frequency of DBWR writing blocks to disk.

Cheers,
-Harish Kalra


On 9/26/06, Ray Feighery <ray@xxxxxxxxxxxxxxxxxxxxx> wrote: 

 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:

  1. Home
  2. oracle-l
  3. Archive
  4. 09-2006