Queries para analisar através do "Explain Plan"

exemplo:

SQL> explain plan for
UPDATE DAA.POOL_ID SET DB_LAST_UPD_SRC = :1, DB_LAST_UPD = sysdate,
LAST_UPD = :2, LAST_UPD_BY = :3, MODIFICATION_NUM = :4, AVAILABLE = :5
WHERE ROW_ID = :6 AND MODIFICATION_NUM = :7
/

Explicado.

SQL> SELECT PLAN_TABLE_OUTPUT FROM TABLE(DBMS_XPLAN.DISPLAY());
ou
SQL> select * from table(dbms_xplan.display);
ou
SQL> @?/rdbms/admin/utlxplsSQL>
SQL> @?/rdbms/admin/utlxplp (plan table output including parallel execution columns.)