How do you create an explain plan with a select, containing a global temporary table?
If you launch only the select request, SQL Optimizer will say that the session table does not exist.
Go to: Tools | User Define Temp Table:
Enter the create and insert statement and press execute
Now you can optimize a SQL with a temp table.