11.2.0.3
Linux x86-64
The goal is to check usage of a particular table which is being decommissioned/renamed
- Auditing is enabled for said table
- One of the reporting user is accumulating audit table with millions of records
So how best to exclude this particular reporting user and continue to check usage of table
Below is the command that was used to enabling auditing:
AUDIT ALL ON TEST_TABLE BY ACCESS WHENEVER SUCCESSFUL;
What would be the best way to enable audit and exclude a particular user to keep the audit table growth under control?
Recently over the span of 1 hours 20 gb needed to be added to audit tablespace.