Patch 21493004 did not help in Oracle 12c (12.2) Windows x64
Auditing all statements seems to be a good possibility to monitor all actions of an application.
But it creates too much details and is so not helpful.
The Option "ONLY TOPLEVEL" is required and implemented in 19c but as the Support-Page states also backported to 12c.
After installing the Patch 31987852 containing the 21493004 nothing changed.
The Following statement does should create the desired policy:
CREATE AUDIT POLICY actions_all_pol ACTIONS ALL ONLY TOPLEVEL;
But after audit policy actions_all_pol again ALL statements are audited and not ONLY TOPLEVEL!
Whats wrong here?
Best Regards
Gert