Patch Reviews - DB (MOSC)

MOSC Banner

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center