Re: very (I repeat) slow DBWR: SOCKETS???

Hi Gerard,

As far as I have been able to find out they are used for interprocess communication (IPC). If this is true and your /tmp filesystem is slow, you should be able to see high waitrates on RDBMS IPC message in your utlbstat/utlestat reports. Oracle definitely uses IPC to sync processes like DBWR and LGWR (basically all the backgroundprocesses), so you may have found one end of the Gordian knot.
I have been working on AIX, and for some strange reason the average wait for IPC messages on that systems was 60! seconds.

Hth,

Sybrand Bakker, Oracle DBA
Gerard H. Pille wrote in message <7gssoa$1p8$1_at_news0.skynet.be>...
>Does someone know what the files in /tmp/.oracle are used for? They are
>called something like s#123465 and a unix file answers: socket.
>
>A trace a ran from AIX showed very long (3 seconds!!) delays in accessing
>the SCSI disk on which my /tmp is stored, and I was wondering what Oracle
>had lost on that disk. /tmp/.oracle was what I found.
>
>There were other and even longer delays, but I still have to look into
them.
>
>Thanks,
>
>Gerard
>
>
>
Received on Thu May 06 1999 - 15:57:05 CDT