how to track sql statement run duration
We have a oracle database version 10.2.0.3.0 with OEM grid control 10.2.0.4.0.
Recently I have a request from application team, to capture all sql statement together with each sql execution duration during their stress test run on development environment. Anyone know what is the best approach to capturing all the sql?
Appreciate of any advise give.
Thanks in advance
best regards