Viewing Explain Plan for current SQL statement in Session Browser.
To display the Explain Plan for the current statement:
1) Verify that the schema has privileges for these objects:
V$SQLTEXT_WITH_NEWLINES
V$SESSION
2) Verify that a plan table has been created and is referenced in View | Options | Oracle | General.
3) Now go to DBA | Session Browser.
4) Select the current session to view.
5) Select the "Current Statement" tab corresponding to the selected session.
6) Select the "Explain Plan" tab for the selected statement.
