| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> 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?
<FONT face=Tahoma
size=2>-----Original Message-----From: root_at_fatcity.com
[mailto:root_at_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? <FONT
size=2>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 [<A
href="mailto:kevin_at_dulcian.com">mailto:kevin_at_dulcian.com] <FONT
size=2>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 <FONT
size=2>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, <FONT
size=2>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 <FONT
size=2>www.dulcian.com kevin_at_dulcian.com
 |
 |