Conclusion

Fine-grained auditing provides an excellent tool for logging user accesses to your database by storing information that you can use to track user activities and enforce accountability. You can customize FGA logging to record accesses on specified tables by specified users and under certain conditions (e.g., whether particular columns are referenced or whether the access occurs at a particular time of the day). Although many DBAs think of FGA simply as a security-related tool for ensuring accountabil

ity, you can also use FGA to analyze data access patterns, examine SQL statement usage, and otherwise improve performance. It provides a way to eliminate, or at least ...

Get Oracle PL/SQL for DBAs now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.