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 disks
>
That may give you far more performance gain than
anything else.
spindles == speed!
Ever read one of the TPC benchmark reports of Oracle?
Thousands of disks! Why? Spindles == speed!
--
Regards,
Frank van Bortel
Top-posting is one way to shut me up...
Received on Thu Nov 23 2006 - 01:07:37 CST
