Multiple choice

Where is the trace file generated, when a deadlock shutdown is detected by Oracle?

  1. SQL_TRACE

  2. TRACE_DEST

  3. USER_DUMP_DEST

  4. CORE_DUMP_DEST
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

When Oracle detects a deadlock and terminates a session, it writes a trace file to the directory specified by USER_DUMP_DEST, which contains diagnostic information about the deadlock (sessions involved, resources waited on, wait-for graph). SQL_TRACE is a facility, not a destination; TRACE_DEST is not a valid parameter; CORE_DUMP_DEST is for core dumps from crashes.

Keep practicing — related questions