iReplay; Database workload capture

From: Teehan, Mark <mark.teehan_at_credit-suisse.com>
Date: Mon, 27 Apr 2009 17:32:41 +0800
Message-ID: <82A20AE725E34B43B3F6C9DF5DBF1E340592E324_at_ESNG17P32003A.csfb.cs-group.com>

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

---

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Apr 27 2009 - 04:32:41 CDT