How to audit

10g
audit_trail = db_extended

Limit aud$ size using:

PCTUSED    40
PCTFREE    10
INITRANS   1
MAXTRANS   255
STORAGE    (
            INITIAL          16K
            NEXT             64K
            MINEXTENTS       1
            MAXEXTENTS       505
            PCTINCREASE      50
            FREELISTS        1
            FREELIST GROUPS  1
            BUFFER_POOL      DEFAULT
           )
LOGGING 
NOCACHE
NOPARALLEL;

Fill the table with a custom procedure after build

Select all objects with explicitly defined audit

select * from DBA_OBJ_AUDIT_OPTS
where
alt||aud||com||del||gra||ind||loc||ren||sel||upd||ref||exe||cre||rea||wri <> '-/--/--/--/--/--/--/--/--/--/--/--/--/--/--/-'
and owner not in ('SYS', 'SYSTEM', 'WMSYS')

Notice that the view returns information about all the audit options for the specified object. The information in the view is interpreted as follows:

The character "-" indicates that the audit option is not set.

The character "S" indicates that the audit option is set, BY SESSION.

The character "A" indicates that the audit option is set, BY ACCESS.

Each audit option has two possible settings, WHENEVER SUCCESSFUL and WHENEVER NOT SUCCESSFUL, separated by "/".

For example A/- means whenever successful and not oterwhise

All statements by user

select * from DBA_STMT_AUDIT_OPTS    

See all the trail

select * from dba_audit_trail

Disable audit

NOAUDIT ALL on VPO.RICH_ELABORAZIONI;

NOAUDIT ALL by BATCHUSER;

noaudit UPDATE TABLE by batchuser

Purge audit trail

truncate table SYS.AUD$;

Others
select * from sys.AUDIT$
#fga
select * from DBA_AUDIT_POLICIES
select * from DBA_AUDIT_EXISTS
select * from DBA_AUDIT_SESSION
select * from DBA_AUDIT_STATEMENT
...

fga
select * from fga_log$
#fga
select * from DBA_FGA_AUDIT_TRAIL

10g
select * from DBA_COMMON_AUDIT_TRAIL
--includes DBA_AUDIT_TRAIL and DBA_FGA_AUDIT_TRAIL