Database Administration (MOSC)

MOSC Banner

Database created as oracle 19c, is Unified audit enabled by default?

Unified Auditing  = FALSE

>select * from gv$option where parameter like 'Unified Auditing';

  INST_ID PARAMETER      VALUE     CON_ID

---------- -------------------- ---------- ----------

     2 Unified Auditing   FALSE        0

     1 Unified Auditing   FALSE        0

 according The UNIFIED_AUDIT_TRAIL is Getting Populated even if Unified Auditing was not explicitly enabled  in 12c (Doc ID 1624051.1), the 2 policies is enabled

POLICY_NAME

------------------------------

ORA_SECURECONFIG

ORA_LOGON_FAILURES


unified_audit_trail has a lot data.

select count(*) from unified_audit_trail;

 COUNT(*)

----------

  114036


when user create a new policy and enabled, it works. GUARDIUM_ACTIONS_POL created by user.

select unified_audit_policies , count(*) from unified_audit_trail

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