How to get Trace File path in backend in oracle apps
By Jag - August 20, 2013
How to get Trace FileWhen you enable SQL trace in a session for the first time, the Oracle server process handling that session will create a trace file in the directory on the database server designated by the user_dump_dest initialization parameter. As the server is called by the application to perform database operations, the server process will append to the trace file.
Query:
------------
select name,value from V$PARAMETER where name = 'user_dump_dest';
0 comments