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.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.