Re: ADDM advices Oracle's application logic

From: Helma <helma.vinke_at_hotmail.com>
Date: Sat, 19 Jan 2008 05:13:01 -0800 (PST)
Message-ID: <9d75e21e-85ab-4143-a628-8f9ba1ab298b@z17g2000hsg.googlegroups.com>

On 18 jan, 19:16, Frank van Bortel <frank.van.bor..._at_gmail.com> wrote:
> Frank van Bortel wrote:
> > File size set to 1048576 KB
> > SYNC Mode.
> [snip!]
>
> Now, lets try async:
> [root_at_cs-frank03 ~]# iozone -a -s 1G
>
> KB reclen write rewrite read reread
> 1048576 4 504582 1146300 1713216 1763957
>
> random random bkwd record stride
> read write read rewrite read
> 1366258 1029497 1445332 1212665 1336920
>
> fwrite frewrite fread freread
> 483586 1026453 1101598 1657060
>
> --
>
> Regards,
> Frank van Bortel
>
> Top-posting in UseNet newsgroups is one way to shut me up

hi Frank,

OS and IO is a bit new to me, i didn't know the iozone tool, i hope to give the correct interpretation.
On my system:

./iozone -a -s 1G -b xcel

gave the following on the 4kb recordsize:

Writer Report                244166
Re-writer Report             681441
Reader Report              1340226
Re-reader Report          1384200

Random Read Report 1066901
Random Write Report 586944
Backward Read Report 1222318
Record Rewrite Report 1263385

Stride Read Report       1135547
Fwrite Report                 234427
Re-fwrite Report             616447
Fread Report               1297864
Re-fread Report           1332997

The write seems half of yours ( 504582 vs 244166). Rather big difference, and it seems you've got the slower hardware too... H. Received on Sat Jan 19 2008 - 07:13:01 CST