AUDIT DDL IN EBS DATABASE

[satish]

Hi Erman,

Recently,one of our team mate has dropped a table and we are unable to find the exact time at which the table is dropped.

We are on 12.1.0.2 database and ebs with 12.2.5

We are unable to find an entry in alert log.I came to know if auditing is enabled for ddl,we can get the timestamp from dba_audit_trail tables.

Is it possible to enable audit only for DROP commands in oracle?
If not possible,can you please provide some reference to enable DDL auditing in our EBS database?
Will this have any performance costs?

Thank you

[ErmanArslansOracleBlog]

yes. you can enable auditing only for drop commands.

ex: audit drop table;

Auditing only the drop statements is as simple as that.
The performance affect changes according to the workload.
I mean if you have lots of "drop table" commands happening in the EBS database all the time, then yes it will have a negative performance effect.
However; as you only want to audit the drop table operations, I don't think there will be a significant performance effect.