We can get the all the execution plan details of an sql_id for a particular awr snapshot.

EXAMPLE:

sql_id – > 5vqy6cj4jr89k

Run the below script:

We need to pass below inputs while running the script.

REPORT_TYPE –
NUM_DAYS –
BEGIN_SNAP –
END_SNAP –
SQL_ID –