| 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
Jeez,
Seagate Cheeta 18 and 36, 10k RPM ahhh
UNFORMATTED CAPACITY (GB)
________________22.54 FORMATTED CAPACITY (GB) __________________18.21 AVERAGE SECTORS PER TRACK ________________213 roundeddown ACTUATOR TYPE
____________________________ROTARY VOICECOIL TRACKS
___________________________________167,008 CYLINDERS ________________________________6,962user HEADS
______PHYSICAL______________________24DISCS (3 in)
_____________________________12 MEDIA TYPE _______________________________THINFILM/MR RECORDING METHOD
_________________________PRML 8/9 PR4INTERNAL TRANSFER RATE (mbits/sec)________152 to 231 EXTERNAL TRANSFER RATE (mbyte/sec) _______40
______________________10,025 AVERAGE LATENCY (mSEC) ___________________2.99BUFFER (/optional)
_______________________1MB/4MB
I believe the only problem is
that they are on one controller. However, this is not a huge database,
only about 3-4 users connected at a time, but lots of DML. The machine is
a Dell Precision 410 with a gig of Ram and dual PIII 450's. I don't think
that it's a huge problem, but it does keep coming up. There are three log
file groups of 32 MB's each and yes the database is also spread accross these
two platters.
Oh and the
results......YOINK!
rdbms
ipc
message14980809SQL*Net message from
client9595869pmon
timer1880177virtual circuit
status1877869smon
timer1875449dispatcher
timer1874318SQL*Net break/reset to
client49746control file parallel
write18026db file sequential
read3947log file
sync1456db file scattered
read1017
size=2>EVENT TIME_WAITED---------------------------------------------------------------------------log file parallel
write616Null
event411library cache
pin315refresh controlfile
command292reliable
message273rdbms ipc
reply146control file sequential
read108log file switch
completion58SQL*Net more data to
client 45enqueue27file
identify24
size=2>EVENT TIME_WAITED---------------------------------------------------------------------------log file single
write23latch
free19SQL*Net message to
client17file
open16buffer busy
waits13SQL*Net more data from
client6direct path
read5log file sequential
read0db file parallel
write0instance state
change0direct path
write0
size=2>EVENT TIME_WAITED---------------------------------------------------------------------------LGWR wait for redo
copy0
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
 |
 |