FFM(DBADMIN)> alter session set events '10046 trace name context forever, level 12'; Session altered. FFM(DBADMIN)> select count(*) from dba_objects; COUNT(*) ---------- 10280 FFM(DBADMIN)> alter session set events '10046 trace name context off'; Session altered. FFM(DBADMIN)> FFM(DBADMIN)> SELECT d.VALUE || '/' || LOWER (RTRIM (i.INSTANCE, CHR (0))) || '_ora_' || p.spid || '.trc' trace_file_name