Reading from the AUDIT TRAIL table
Truncating the AUD$ table
Using the AUDIT_TRAIL view
Listing the AUDIT_TRAIL parameter
Setting the AUDIT_TRAIL parameter
Shutting down and startup a database using SPFILE
Using the AUD$ table
Auditing an auditor
Auditing who deletes a record
Viewing the AUD$ table
Stopping all auditing trail
TRUNCATE TABLE aud$
ALTER SYSTEM SET audit_trail=db SCOPE=spfile
CONNECT system/manager AS SYSDBA
AUDIT delete ON sys.aud$
AUDIT DELETE ON BY ACCESS WHENEVER SUCCESSFUL
View the SYS.AUD$ table to display the date and time who (username), and what (statement of an action) was done.
as "Date and Time", userid, name "Action by user"
FROM sys.aud$ JOIN sys.audit_actions
ON action = action#
Since auditing takes a lots of disk space be sure to stop auditing when it is not needed. Try, stop auditing.
SQL> NOAUDIT ALL
This is the WRONG forum for this type of question. This forum is for discussion of users passing or have questions on taking Oracle Certification exams.
MODERATORS: Please move this thread to the --> SQL-PL/SQL Community forum.