Detecting Unwanted Schema Changes in Real Time – Grid Control 11g R1 – Video DemoPosted: 24/11/2010
Very easy .. just enabling parameter
ENABLE_DDL_LOGGING. This Feature only on database 11g
ENABLE_DDL_LOGGING enables or disables the writing of DDL statements to the alert log.
As of Oracle database 11g we can have loggin information for DDL operations in the alert log files.
The traditional alert_<sid>.log as we had it ever since, the other one is an log.xml file which is located in the diagnostic directory in the alert folder.
Below Video Demo