nn

 SELECT 

SQL_ID,pian_hash_value,SQL_PROFILE,SQL_PLAN_BASELINE,ROUND(SUM(etapsed tirne)/SUM(exec utions)/1e6, 3) 

avg_et_secs,ROUN D(SUM(cpu_time)/SUM(executions)/1e6, 

3 avg_cpu_secs,ROUNDiSUM(user_io_wa it_time)/SU M (exec uti o ns)/1 e6, 3) 

avg_io_secs, ROUND(SUM (bu ffer_g et s)/SU M (executions)) avg_buffer gets,

ROUND(SUM (disk_reads)/SUM (executions)) avg_disk reads,ROUND(SUM(rows_processed)/SUM(executions))

 avg_rows,SUM(executions) executions,Substr(sql_text1,100)

 "SQL Text"FROM gvSsqIWHERE executions > O 

 GROUP BY sql_id,plan_hash value,sql_text,SQL_PROFILE,SQL_PLAN_BASELINE ORDER 

BY 1;