Re: On AIX, blocksize an DataWarehouses

From: Frank R. <trek1s_at_gmail.com>
Date: 22 Nov 2006 12:27:23 -0800
Message-ID: <1164227243.285040.202910@m73g2000cwd.googlegroups.com>

On Nov 23, 2:07 am, Frank van Bortel <frank.van.bor..._at_gmail.com> wrote:
> Frank R. schreef:
> [snip!]
>
> > Top 5 Timed Events
> > ~~~~~~~~~~~~~~~~~~
> > % Total
> > Event Waits Time (s)
> > Ela Time
> > -------------------------------------------- ------------ -----------
> > --------
> > PX Deq Credit: send blkd 98,776 13,100
> > 51.44
> > db file sequential read 341,578 6,892
> > 27.06
> > PX Deq Credit: need buffer 53,359 3,447
> > 13.53
> > buffer busy waits 23,228 968
> > 3.80
> > log buffer space 1,012 333
> > 1.31
>
> > Also, 600 ms datafile read access seemed bad so, right now the data is
> > being redistributed between all disksThat may give you far more performance gain than
> anything else.
> spindles == speed!

No doubt on that! After finishing data reorganization the overall performance has increased a lot.

>
> Ever read one of the TPC benchmark reports of Oracle?

Any link to it? :)

> Thousands of disks! Why? Spindles == speed!
>
> --
> Regards,
> Frank van Bortel
>
> Top-posting is one way to shut me up...
Received on Wed Nov 22 2006 - 14:27:23 CST