以下SQL用于生成awr的以下部分。
select * from dba_hist_snapshot x ;
--提取&dbid
select * from v$database;
--提取$inst_num
select * from v$instance;
从dba_hist_sqlstat提取更多的指标,调整加粗部分,照葫芦画瓢就可以写出
SQL ordered by CPU Time
SQL ordered by Gets
SQL ordered by Reads
SQL ordered by Executions
SQL ordered by Parse Calls
SQL ordered by Sharable Memory