Database Administration (MOSC)

MOSC Banner

audsys.aud$unified column explanation

Querying unified_audit_trail is a pain especially in 12c database due to performance. However, querying this internal audit table audsys.aud$unified, the performance is much faster, and a huge difference in performance. But I have difficulties to find out the object_name associated with actual database objects such as tables, indexes, etc.

For example, I am getting back the obj_name column as following:

CMP4$1372038

CMP1$909656

CMP4$1763197

CMP1$218930

But how could I associate the CMP<n>$<nnnnn> object name to an actual database object names.

Also I am getting the ACTION column as a code such as:

12

1

I have hard time to find out oracle documentation as to what's the corresponding database actions are.

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