At my current client site, I use AIX on IBM PowerPC kit. There is a neat little systems monitoring tool called “nmon” on AIX, which I quite like. I noticed recently that it’s available on Linux now, so I installed it on my machine, which runs Fedora 12. There are a number of binaries prebuilt, [...]
Archive of posts tagged benchmarking
TPC-H Query 20 and optimizer_dynamic_sampling
I was working with Jason Garforth today on creating a TPC-H benchmark script which we can run on our warehouse to initially get a baseline of performance, and then, from time to time, rerun it to ensure things are still running with a comparable performance level. This activity was on our new warehouse platform of [...]
Scripts for loading up DBGEN TPC-H data
If you’re interested in creating a TPC-H schema for testing purposes, then the following scripts may be of use to you: Unix Scripts:Multi Load TPCHLoad TPCH Stream SQL*Loader Control files:REGION TableNATION TableSUPPLIER TableCUSTOMER TablePART TablePARTSUPP TableORDERS TableLINEITEM Table You may wish to read and check them before you use them – they’re not exactly rocket [...]
Creating a TPC-H schema with DBGEN on HP-UX
I wanted to try out this HammerOra product from Steve Shaw, both at work and on my box at home…but after playing with it at home, I realised that it takes quite some time to build even a small (scale factor 1) TPC-H schema…I know it runs serially, but I’m still not quite sure why [...]
PC for manly men?
So, after suffering a hard disk failure, I figured it was time to buy a new PC for (Oracle) research purposes and the choice seemed to boil down to: Buy a Dell or HP high end PC from their website and pay serious money for it. Pick a proper server off Ebay – cheaper but [...]