Get SQL Details

If you know the SQL ID, or you choose specific SQL from top SQLs, current/history/top sessions or history SQLs, you will get all necessay details of the SQL for further investigation. 

Click "Show SQL" button or presss F8, then input the SQL ID, click OK.

You will get the SQL text, SQL performance statistics data, SQL Execution Plans and their statistics data.

If the target SQL has more than one execution plans associated, you can choose the plan hash value from the right top dropdown list to get different execution plan information.