From the course: Oracle Database 12c: Security
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Manage the audit trail - Oracle Database Tutorial
From the course: Oracle Database 12c: Security
Manage the audit trail
- [Instructor] There is one additional and very crucial aspect to database auditing that you need to be familiar with, and that is maintenance of the database audit trail. Making sure that you either archive or purge the various database audit trails on a regular basis. If auditing is enabled and no space is available for the audit trails, then the database will actually freeze. This can sometimes even be used as a database denial of service attack. That's because the database audit trails can grow to become very large, depending on how many and how wide your auditing policies are. Actually, since audit trails are stored in database tablespaces, a huge one can fill up your database pretty quickly. It's even worse because by default, the tablespace used to store the audit trail is your database system tablespace. But luckily for us, Oracle has built-in audit trail purge mechanisms. We'll start by opening a SQL Plus connection as the sysdba user. So I'll type sqlplus sys/oracle@orcl as…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.