Introduction to FGA
To help you make the most of FGA, we will start this chapter with a review of general auditing requirements, and then move on to using FGA in a simple example.
Tip
For FGA to work correctly, your database must be in cost-based optimizer (CBO) mode; the queries must be using the cost-based optimizer (i.e., they must not be using RULE hints); and the tables (or views) in the query must have been analyzed, at least with estimates. If these conditions are not met, FGA might produce false positives , that is, might write an audit trail even if the necessary conditions have not been met. Note that Oracle Database 10g uses the cost-based optimizer by default, as described later.