How to get Trace File
When 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.
When 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';
1 comment:
Highly descriptive post, I loved that bit. Will there be a part 2?
Stop by my weblog; This Web site
Post a Comment