BY SESSION and BY ACCESS options

The BY SESSION option stores only one audit record when the same type of statement is issued during the same user database session. The BY ACCESS option stores one audit record every time the same type of statement is issued, regardless.

AUDIT SELECT ON store.departments BY SESSION;
AUDIT DELETE ON store.employees BY ACCESS;
AUDIT INSERT, UPDATE ON store.employees BY ACCESS;

1. Auditing
2. WHENEVER SUCCESSFUL and WHENEVER NOT SUCCESSFUL options
3. BY SESSION and BY ACCESS options
4. Audit Views