Read the Trace file from SQL Plus

Find trace file in Oracle The following script returns the path to the trace file that the current session writes. It returns the path whether or not tracing is enabled.

Check the value for user_dump_dest

Create a directory

Create a function

Now just the select the trace file name.

Thank you for giving your valuable […]

Read More