ORACLE AUDITING 01

I was seeing this on my OEM and try to remember what was it for 

These raised a couple of questions

1.  What are the current settings of audit in my database?

 Answer: show parameter audit

2. What can you audit?

• Statements
• Privileges
• Objects

3. How do you turn on auditing?

To set the audit trail to OS, use the following and then restart the database:

SQL> alter system set audit_trail='os' scope=spfile;

To enable (or disable) the audit trail you need to set the AUDIT_TRAIL initialization parameter. You then need to restart the database. For example:
SQL> alter system set audit_trail=db scope=spfile;




4. What is being audited?



Seeing What is Being Audited

There are three views that show you what is currently being audited by the standard audit facility. DBA_STMT_AUDIT_OPTS shows you what statement auditing is enabled, DBA_PRIV_AUDIT_OPTS shows you what privilege auditing is enabled, and DBA_OBJ_AUDIT_OPTS shows you what object auditing is enabled.





SQL> select * from dba_stmt_audit_opts;








Reference

https://www.dbsec2.com/oracle-auditing-part-1-3-standard-auditing/