Call for Oracle support & training (800) 766-1884
Free Oracle Tips

Corporate Oracle Training
Custom Oracle Training
Oracle New Features Training
Advanced Oracle DBA Classes
Oracle Tuning Courses
Oracle Tips & Tricks
Oracle Training Links
Oracle Training Links
Oracle Training Links

We are top for USA Oracle Training Clients


Free Oracle Tips


Free Oracle App Server Tips


Oracle support

Oracle training

Oracle tuning


Remote Oracle

Custom Oracle Training


  Oracle Tips by Burleson

Chapter 3 Introducti

on to Oracle Auditing

types of triggers with scripts, which can be re-used in a real production environment.

Another way to capture the changes made to the database is from a tool called Log Miner. Any change in the Oracle database is written to a special type of file called a redo log. When a redo log file is filled up, it is stored as another type of file called an archived log file. These files are necessary when the database suffers a failure and the DBA needs to restore the data files up to the point of failure during a recovery.

Log Miner can go through these log files and capture the changes that occurred, along with the user ID, the timestamp, and a host of other information. This tool is more accurate in Oracle 9i than in Oracle 8i, nevertheless, it can offer valuable clues to data changes.

Log Miner auditing is explained in detail, along with scripts, in Chapter 9.

Use triggers to audit changes to sensitive data. These changes can also be recoded via Log Miner.

DDL Auditing

Oracle has two types of SQL statements. The statements that access data in any way, such as SELECT, INSERT, DELETE, and UPDATE etc. belong to a part of the SQL language known as Data Manipulation Language (DML). Developers and users accessing the data primarily use this. The other type of statements that define the database and its objects are known as Data Definition Language (DDL). The DDLs are used to create tables, views, procedures, etc. They are also used

The above text is an excerpt from:

Oracle Privacy Security Auditing

The Final Word on Oracle Security


This is the only authoritative book on Oracle Security, Oracle Privacy, and Oracle Auditing written by two of the world’s leading Oracle Security experts.

This indispensable book is only


 and has an immediate download of working security scripts:


Oracle performance tuning book



Oracle performance tuning software

Oracle performance tuning software
Oracle performance Tuning 10g reference poster
Oracle training in Linux commands
Oracle training Excel


email BC:

Copyright © 1996 -  2014 by Burleson Inc. All rights reserved.

Oracle® is the registered trademark of Oracle Corporation.