Detecting Unwanted Schema Changes in Real Time – Grid Control 11g R1 – Video Demo

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



Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s