select * from table(dbms_xplan.display_awr('&sql_id'));

select to_char(begin_interval_time, 'yyyy-mm-dd hh24:mi:ss') begin_time, a.sql_id, a.plan_hash_value, a.instance_number, module, plan_hash_value, EXECUTIONS_DELTA exec, decode(EXECUTIONS_DELTA, 0, buffer_gets_deltA, round(BUFFER_GETS_DELTA / EXECUTIONS_DELTA)) per_get, decode(EXECUTIONS_DELTA, 0, ROWS_PROCESSED_DELTA, round(ROWS_PROCESSED_DELTA / EXECUTIONS_DELTA, 3)) per_rows, decode(EXECUTIONS_DELTA, 0, ELAPSED_TIME_DELTA, round(ELAPSED_TIME_DELTA / EXECUTIONS_DELTA / 1000, 2)) time_ms, decode(EXECUTIONS_DELTA, 0, DISK_READS_DELTA, round(DISK_READS_DELTA / EXECUTIONS_DELTA, 2)) per_read from dba_hist_sqlstat a, DBA_HIST_SNAPSHOT b where a.snap_id = b.snap_id and a.instance_number = b.instance_number and a.sql_id = '&sql_id' order by 1 desc;

看看这个

https://blog.csdn.net/weixin_42298817/article/details/113055970?utm_term=db2%20%E5%8E%86%E5%8F%B2sql&utm_medium=distribute.pc_aggpage_search_result.none-task-blog-2~all~sobaiduweb~default-1-113055970-null-null&spm=3001.4430

不好意思，是我搞错了