Database Trace
You can trace a session connected to the Oracle Clinical Database and generate a log file. The following example explains how to run a trace while in the Maintain DCM form.
-
Start a SQL*Plus session as SYS, or another user with the DBMS_SYSTEM role.
-
Find the session ID and serial number of the Oracle Clinical user working in the Maintain DCM form:
select sid, serial# FROM v$session where username = '
userid
';
-
Assume that 8 and 12 are returned for sid and serial#, enable SQL trace for the user as follows:
exec dbms_system.set_sql_trace_in_session(8,12,TRUE)
-
Have user perform the operation that causes the error. After the error is returned disable SQL trace:
exec dbms_system.set_sql_trace_in_session(8,12,FALSE)
-
Find the trace file out in your USER_DUMP_DEST directory. For example,
select value from v$parameter where name = 'user_dump_dest';
where value is the path, something like, /ind/oraclelogs/maria/db/udump. The trace file is placed in this directory.
Parent topic: Troubleshooting