0

I'm trying to generate workload from our production databases but rather than running a trace file in production, I would prefer using the AWR tables since we have a license for it.

Is it possible?

Thank you.

Nicolas de Fontenay
  • 1,875
  • 2
  • 18
  • 37

1 Answers1

1

In short I would say: NO.

If you want to invest lot's of time ... you could generate SQL's and usage frequencies from awr sql history tables but the parameters will be the same for all occurences of an SQL since the bind variables are not recorded for every execution. I am not sure about hammerora but from swingbench I know you can create your own transactions and for that you could use awr sql history as a guide on how many tx/s to generate. It still remains a synthetic load.

Smarter would be to capture the databases input from a proxy between the application server and the database.

Oracle Replay has a price, for a reason.