Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Unified Audit Trail (19c)

user5451943 days ago — edited 7 hours ago

Env. 19cSE2, Unified Audit Trail enabled.

Quick question: How long does it take for the UAT table to be updated after a DDL action?

We altered a table a few days ago, but still no information in the UAT table?

Our settings:

NAME                           TYPE    VALUE                              
------------------------------ ------- ---------------------------------- 
audit_file_dest                string  /u00/app/oracle/admin/db_name/adump 
audit_syslog_level             string                                     
audit_sys_operations           boolean TRUE                               
audit_trail                    string  DB                                 
unified_audit_common_systemlog string                                     
unified_audit_sga_queue_size   integer 1048576                            
unified_audit_systemlog        string
Comments
Post Details
Added 3 days ago
0 comments
36 views