Hi guys
When I want to get the elapsed time for a sql statement in 10g, I prefer to take snapshots before and after executing the sql and then make an AWR report to find the elapsed time for the certain sql. Howerver, when it comes to get elapsed time list for a sql(or get the long-running sqls) in a period of time, it is difficult for me.
Could you please help to give some scripts on how to find the sql execution time by sql_id? Thanks!
Regads
Li