How to delete audit log in oracle

In Oracle, you can use the DELETE statement with "SYS.AUD$" to delete the audit log. The DELETE statement is used to delete records in the table. The syntax is "DELETE FROM SYS.AUD$;".

The operating environment of this tutorial: linux7.3 system, Oracle 11g version, Dell G3 computer.

How to delete the audit log in Oracle

Oracle 11g has launched an audit function, but this function will generate audit files.aud for many operations. Over time, there are many of these files. By default, the system In order to save resources and reduce I/0 operations, its audit function is turned off.

During this period, I found that auditing took up a lot of space, so the deletion process is recorded here.

Delete audit log

When a lot of logs have been formed, the records in them can be deleted. Currently, they are deleted directly without affecting the database.

Query the current log information: select * FROM SYS.AUD$;

Delete existing audit information: DELETE FROM SYS.AUD$;

Or quickly delete the table Information: truncate table SYS.AUD$;

Recommended tutorial: "Oracle Video Tutorial"

The above is the detailed content of How to delete audit log in oracle. For more information, please follow other related articles on the PHP Chinese website!