To help diagnose performance issues, you can create a trace file for any job.
In the Output Description Suffix field of the Submission screen for the job in the Oracle Life Sciences Data Hub user interface, enter the following string: !enable_trace!
When you submit the job, the system creates a trace file for the job. The trace file name contains the identifier LSHJOBT.
(Optional) Enter a string in the Output Title Suffix field. The system adds that string to the trace file name immediately before the .trc extension.
Run the job.
Use the following query to find the location of the file:
select value from v$parameter where name='user_dump_dest'