DB Wiki

By enabling an initialisation parameter you can now log all DDL commands

ALTER SYSTEM SET enable_ddl_logging=true;

The logs can be found in the following locations

$ADR_BASE/diag/rdbms/{dbname}/{SID}/log/ddl_{SID}.log
$ADR_BASE/diag/rdbms/{dbname}/{SID}/log/ddl/log.xml

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.

$ADR_BASE/diag/rdbms/{DB-name}/{SID}/log/debug

The debug log is included in any packages that are created for Oracle Support

adrci> show log -l ddl
adrci> show log -l debug