<< Click to Display Table of Contents >>


Top Previous Next

Oracle's Auditing features allow the database administrator to monitor selected aspects of database activity. Auditing facilitates database tuning and may also enhance database security.

The three types of auditing are:

Object Auditing

Statement Auditing

Privilege Auditing

Auditing is turned on or off by the AUDIT_TRAIL parameter in the initialization file. Permissible values include:

DB enables auditing and stores audit trail in the database.

OS enable auditing and stores audit trail in the file system.

NONE disables auditing.