Neither are really straightforward. I have run the statement in SQLPLUS. If it runs long, I'll just cancel it. It will still be recorded. In 10G EM go to your databases home page. Click on the PERFORMANCE tab on top, drop down until you see TOP SQL. Click on TOP SQL, then click on PERIOD SQL on top of page. Find statement. Click radio button to select it. Create a single statement SQL Tuning Set.

Go back to database's PERFORMANCE main page. Click on ADVISOR CENTRAL, then SQL ACCESS ADVISOR. Choose use SQL TUNING SET as input.


OR, you can do it this way. Create a table that has at least two columns in it. One for the text of the SQL statement and the other for the username. Name the columns SQL_TEXT and USERNAME. Insert your SQL statement and username information. Go to the SQL Access advisor and choose the IMPORT SQL FROM TABLE option.