| 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
buffer
size > redo log size.
<FONT face=Arial color=#0000ff
size=2>
That
in itself is painful.
<FONT face="Times New Roman"
size=2>-----Original Message-----From: Kevin Kostyszyn
[mailto:kevin_at_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?
<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? <FONT
size=2>what else is on the "separate" disks? anything? <FONT
size=2>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]
Sent: Thursday, March 22, 2001 8:50 AM <FONT
size=2>To: Multiple recipients of list ORACLE-L <FONT
size=2>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 <FONT
size=2>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 <FONT
size=2>www.dulcian.com kevin_at_dulcian.com
 |
 |