oracle trace files, 오라클 트레이스 파일 위치

less than 1 minute read

To find the trace file for your current session:

  • Submit the following query:

SELECT VALUE FROM V$DIAG_INFO WHERE NAME = ‘Default Trace File’;The full path to the trace file is returned.

To find all trace files for the current instance:

  • Submit the following query:

SELECT VALUE FROM V$DIAG_INFO WHERE NAME = ‘Diag Trace’;The path to the ADR trace directory for the current instance is returned.

To determine the trace file for each Oracle Database process:

  • Submit the following query:

SELECT PID, PROGRAM, TRACEFILE FROM V$PROCESS;

XXXX SQL>show parameter user_dump_dest;
 
 NAME TYPE VALUE
 ------------------------------------ ----------- ------------------------------
 user_dump_dest string /oracle/~~~~~

🔗original-link

Updated: