As a DBA, what is the best way to read the audit records on daily basis? Say, i'm the administrator and I would like to view the audit records made by the DBAs. I have enabled audit sys operatiosn to TRUE and and it creates records for the same but is there any easy readable format to clearly list out the changes made by the DBAs?
The audit records are written to the operating system's audit trail defined by the audit_file_dest parameter. You can change the format of to XML by changing the audit_trail parameter but the files will be still kept on the file system. This due to security reasons since DBAs shouldn't be able to access those files if they are being audited. You can play around with external tables or create a shell script for analyzing the files but there is no built in mechanism for analyzing the data.