Protected by Copyscape Web Copyright Protection Software

Search This Blog

Wednesday, May 29, 2013

How to get Trace File path in backend in oracle apps?

Here is the detailed process for 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';