Most recent version here(updated).
Added these two:
display_results(test_name,compared_to_test_name) - output results of testings in the two scenarios. List results from all queries that ran more than 3 times as long with one test or the other. Also summarize results with total elapsed time, number of queries executed, average elapsed time, and percent improvement. show_plan(test_name,sqlnumber) - extract plan from plan_table for given test name and sql statement.
Example usage:
execute test_select.display_results('PARALLEL 128','PARALLEL 8'); select test_select.show_plan('PARALLEL 128',57) from dual;
Give it a try.
– Bobby
Pingback: Different plan_hash_value same plan | Bobby Durrett's DBA Blog