This content has been marked as final. Show 3 replies
it looks like the auditing took place but the xml file may not have been immediately flushed to disk,
something that would then happen after a reboot as you observed, when the audit file is not
yet flushed other sessions checking DBA_COMMON_AUDIT_TRAIL (which for the XML part
will dynamically list the files in the audit_file_dest) will not see it.
If you want audit info to be flushed to the XML files immediately, issue:
ALTER SYSTEM SET
EVENT='46349 trace name context forever, level 1'
COMMENT='re-enable flush of audit files' SCOPE=SPFILE;
Reference: note 1358183.1 Audit Files Are Not Immediately Flushed To Disk
Please note we are currently actively promoting the new support communities also, so if you want to get some
feedback from your peers as well as the attention of Oracle support engineers, please go to
This will put you in the Database Products Security community , but you can select others also from the left,
Harm ten Napel