dbTalk Databases Forums  

empower_checkpoint - free download oracle I/O stress test

comp.databases.oracle.marketplace comp.databases.oracle.marketplace


Discuss empower_checkpoint - free download oracle I/O stress test in the comp.databases.oracle.marketplace forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
noreply@dbcool.com
 
Posts: n/a

Default 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.

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.