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
