Activer la trace 10053

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.

This entry was posted in Database, Trucs et Astuces, tuning. Bookmark the permalink.

Comments are closed.