Plan SQL's

SELECT sql_id, plan_hash_value, executions, inst_id FROM gv$sql WHERE sql_id='bhwamkg4y2pxb';



SELECT inst_id, sql_id, plan_hash_value, executions, ROUND(elapsed_time/1000000,2) total_elapsed_sec, ROUND((elapsed_time/DECODE(executions,0,1,executions))/1000000,2) avg_elapsed_sec, ROUND(cpu_time/1000000,2) cpu_sec, buffer_gets, disk_reads, rows_processed FROM gv$sql WHERE sql_id='bhwamkg4y2pxb' ORDER BY avg_elapsed_sec;