1 Reply Latest reply: May 17, 2014 9:29 AM by 885820 RSS

    SQL execution times


      Hi There,


      Wondering if someone could advise on the best way of capturing the following in an 11g database.


      Say we have;

      - a piece of SQL executing around 50 times a minute.

      - single execution times vary.


      Aside from going through dba_hist_sqlstat and generating some sort of average over a 30 min period.

      What would be the best way to obtain individual execution times of this piece of SQL in real-time.


      say I want the individual execution time of that last 100 executions.


      Any help would be appreciated