User Tools

Site Tools


adrenhancements

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Next revision
Previous revision
adrenhancements [2015/07/23 11:19] – created z0hpvkadrenhancements [2025/03/08 22:24] (current) – external edit 127.0.0.1
Line 4: Line 4:
 <code>ALTER SYSTEM SET enable_ddl_logging=true;</code> <code>ALTER SYSTEM SET enable_ddl_logging=true;</code>
 The logs can be found in the following locations The logs can be found in the following locations
-<code>$ADR_BASE/diag/rdbms/{DB-name}/{SID}/log/ddl_{SID}.log +<code>$ADR_BASE/diag/rdbms/{dbname}/{SID}/log/ddl_{SID}.log 
-$ADR_BASE/diag/rdbms/{DB-name}/{SID}/log/ddl/log.xml</code>+$ADR_BASE/diag/rdbms/{dbname}/{SID}/log/ddl/log.xml</code> 
 + 
 +==== Debug Log ==== 
 +Warnings are written to the debug log when they are not serious enough for an incident.\\ 
 +This happens automatically and is located at the following location.\\ 
 +<code>$ADR_BASE/diag/rdbms/{DB-name}/{SID}/log/debug</code> 
 +The debug log is included in any packages that are created for Oracle Support 
 +<code>adrci> show log -l ddl 
 +adrci> show log -l debug</code>
adrenhancements.1437650360.txt.gz · Last modified: 2025/03/08 22:23 (external edit)