12.1.0.2
Ive been asked to look at a schema with object counts going into the thousands. It was used over the years as s dumping ground with no standards on object creation. Lot better now but a lot of trash in there needs to be cleaned up.
We want to audit for 4 weeks and if no access to an object after that period, it will be considered for removal. A single access is enough for it to not be considered.
Some of the tables would be really chatty so as we dont want audit space filling up so thinking of some sort of cleanup job every evening whereby if a table has an audit record, its removed from the audit and its audit trail removed.
Whats the minimal amount of auditing that could be enabled for a schema in 12.1.0.2 that could accomplish this. thanks.