I am evaluating tools that capture and replay real database workload for
benchamarking and upgrade functionality testing; mostly for 9i to 10g
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?
Please access the attached hyperlink for an important electronic communications disclaimer: