오라클 trace 로그

trace 로그

-- trace,incident,cdump 위치     
SELECT *
  FROM V$DIAG_INFO 
-- WHERE NAME LIKE 'Diag%'
 ;

Diag Trace	/oracle/app/oracle/diag/rdbms/SID/XXXX/trace
Diag Alert	/oracle/app/oracle/diag/rdbms/SID/XXXX/alert
Diag Incident	/oracle/app/oracle/diag/rdbms/SID/XXXX/incident
Diag Cdump	/oracle/app/oracle/diag/rdbms/SID/XXXX/cdump