Hello Tom,

After migrate our database to 12C, the output trace file is not generate, I would like to know if the process to generate the trace is not working for 12c?

Follow the procedure to execute the process trace.

SQL> EXEC DBMS_SYSTEM.SET_SQL_TRACE_IN_SESSION(&SID,&SERIAL,TRUE);
Enter value for sid: 1883
Enter value for serial: 13426

PL/SQL procedure successfully completed.

SQL> EXEC DBMS_SYSTEM.SET_SQL_TRACE_IN_SESSION(&SID,&SERIAL,FALSE);
Enter value for sid: 1883
Enter value for serial: 13426

PL/SQL procedure successfully completed.

####################################

SQL> select value from v$parameter where lower(name) = 'user_dump_dest';

VALUE
--------------------------------------------------------------------------------
D:\ORACLE\PRODUCT\12.1.0\MSAFPRD\RDBMS\TRACE

#####################################

SQL> show parameter USER_DUMP_DEST

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
user_dump_dest                       string      D:\ORACLE\PRODUCT\12.1.0\MSAFP
                                                 RD\RDBMS\TRACE

On the patchs above and in other drivers of the server the trace file was not created, before the upgrade the procedure working fine.

Thank you very much!
Eduardo

select * from v$diag_info
where  name = 'Diag Trace';