Wednesday, April 3, 2013

Enable DDL auditing in 11GR2 Database:

Found intresting audit parameter in 11Gr2, enable_ddl_logging will allow the tracking of all ddl's in the alert log using the following:

Enable it by using the below command.

ALTER SYSTEM SET enable_ddl_logging=TRUE

All the DDL commands executed against the database will be recorded in the alert<SID>.log

More details of the DDL of the command executed can be found in the XML file in the alert directory


  1. Regards
    Sridevi Koduru (Senior Oracle Apps Trainer
    LinkedIn profile -
    Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, Oracle Manufacturing, OAF, ADF, SQL, PL/SQL, D2K at | +91 - 9581017828.