Re: iReplay; Database workload capture
Date: Mon, 27 Apr 2009 23:05:57 +1200
Hi Mark - Oracle's Real Application Testing was backported to 18.104.22.168, if that's the kind of thing you're after. HTH .
2009/4/27 Teehan, Mark <mark.teehan_at_credit-suisse.com>
> 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*<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?
> Please access the attached hyperlink for an important electronic communications disclaimer: