empower_checkpoint - free download oracle I/O stress test -
07-30-2003
, 05:44 PM
download from http://www.linxcel.co.uk
available now for solaris and linux - will be open sourced soon.
How it works
------------
During an Oracle database checkpoint, dirty blocks from the buffer
cache are flushed to disk. Typically a checkpoint operation occurs at
a log switch - it's often the most write intensive operation in a busy
transaction processing database.
empower_checkpoint replays the writes captured from 4 real Oracle
checkpoints for tablespaces with different block sizes: 2K, 4K, 8K,
and 16K.
In each case the data loaded prior to the checkpoint is the same - a
250MB import of a TPC-C Customer table.
You don't even need an Oracle database to run the test.
In just a couple of minutes, empower_checkpoint will give you a
baseline for the performance of your storage for an Oracle I/O
intensive operation.
Disclaimer: if you run accidentally against a file with data you want
to keep, the file contents will be trashed.
Full usage details are in the readme file. |