From MohanR@STARS-SMI.com Thu, 22 Mar 2001 13:47:24 -0800 From: "Mohan, Ross" Date: Thu, 22 Mar 2001 13:47:24 -0800 Subject: RE: Log writer Message-ID: MIME-Version: 1.0 Content-Type: text/plain Title: RE: Log writer buffer size > redo log size.     That in itself is painful. -----Original Message-----From: Kevin Kostyszyn [mailto:kevin@dulcian.com]Sent: Thursday, March 22, 2001 3:42 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Log writer So was it that the buffer was too big and the log files themeselves were too big for the disk to handle? -----Original Message-----From: root@fatcity.com [mailto:root@fatcity.com]On Behalf Of Mohan, RossSent: Thursday, March 22, 2001 11:02 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Log writer Disk mfr? rpm? seek/access times? diskperf -y set already? CPU,I/O, or diskbound system? log buffer size? log file size? what else is on the "separate" disks? anything? separate disks share a controller? select event, time_waited from v$system_event order by 2 desc; results? just a few questions that come to mind.... -----Original Message----- From: Kevin Kostyszyn [mailto:kevin@dulcian.com] Sent: Thursday, March 22, 2001 8:50 AM To: Multiple recipients of list ORACLE-L Subject: Log writer Hi all,         I am testing out Spotlight on Oracle from Quest Software.  It is telling me that my log writer process is slow.  What it looks like it is saying is that most disks take about 20ms to right the data and mine is taking on average about 40ms.  I don't know why, they are scsi drives and there isn't that much stress on the syste.  Anyway, I moved the redo logs to seperate disks, but I fear I may have made an error.  Instead of moving each "group" to seperate hard disks, I moved the members of each group to seperate hard disks.  Anyway, I am wondering if anyone has advice on this problem. Sincerely, Kevin Kostyszyn DBA Dulcian, Inc www.dulcian.com kevin@dulcian.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Kostyszyn   INET: kevin@dulcian.com Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051 San Diego, California        -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from).  You may also send the HELP command for other information (like subscribing).