Database Security Products (MOSC)

MOSC Banner

Unified Auditing view and table clarity

edited Jun 26, 2024 1:36PM in Database Security Products (MOSC) 1 commentAnswered ✓

Hello All,

Looking for some clarity and what if anything needs to be done. We have very slow query performance when slunk comes to collect the data every 5 min. the audit table is partitioned by day.

does the view in the PDB use the query in the CDB?

the view in the CDB & PDB UNIFIED_AUDIT_TRAIL is using tables that according to an oracle support should be moved. How To Transfer Unified Audit Records To An Internal Relational Table (Doc ID 2212196.1)

View UNIFIED_AUDIT_TRAIL objects used.

sys.gv_$unified_audit_trail uview, sys.all_unified_audit_actions act,

Tagged:

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