Here are some queries that can be used to check the best execution plan using the tables dba_hist_sqlstat, dba_hist_sqltext, and dba_hist_snapshot:
1. List the SQL statements with the highest CPU usage in the last hour:
SELECT sql_id, elapsed_time_delta/1000000 as elapsed_