iReplay; Database workload capture

  • From: "Teehan, Mark" <mark.teehan@xxxxxxxxxxxxxxxxx>
  • To: "oracle-l-freelists" <oracle-l@xxxxxxxxxxxxx>
  • Date: Mon, 27 Apr 2009 17:32:41 +0800

Hello,

I am evaluating tools that capture and replay real database workload for
benchamarking and upgrade functionality testing; mostly for 9i to 10g
upgrade testing.
I have never seen a tool that can reproduce database workload; and at
first glance simulation is complex; given issues like intercepting all
statements that are issued by connected sessions; co-ordinating the
request timing for multiple sessions; handling the response data, etc.
Tricky. I am not clear on how it works; whether it snoops on processes
at the unix level, or logs into the database and trawl v$sql. 

I came across this : http://www.exact-solutions.com/products/ireplay
which is related to iWatch, which seems to have been around for a while.

Has anyone use iReplay? Does it do what it says on the box?

Thanks!
Mark

==============================================================================
Please access the attached hyperlink for an important electronic communications 
disclaimer: 

http://www.credit-suisse.com/legal/en/disclaimer_email_ib.html
==============================================================================

Other related posts: