SQL>ALTER SESSION SET EVENTS '10053 trace name context forever, level 1';
SQL>explain plan for select * from SCOTT.EMP;
SQL>Explained
SQL>ALTER SESSION SET EVENTS '10053 trace name context off';
SQL>select value
from v$parameter
where name = 'user_dump_dest';
u01/app/oracle/diag/rdbms/orcl/orcl/trace
Aller au répertoire /u01/app/oracle/diag/rdbms/orcl/orcl/trace pour récupérer la trace générée.