1.修改参数audit_trail=true,

alter system set audit_trail=true scopt=spfile

2.启动oracle服务。

3测试，建立表

create table t1 ( x int );

audit insert on t1 by access;

insert into t1 values (111);

4.查看sys.aud$,可以发现有记录。

SQL> alter session set audit_trail=true;
alter session set audit_trail=true
*
ERROR at line 1:
ORA-02095: specified initialization parameter cannot be modified

不能修改回话的参数。

SQL> alter system set audit_trail = true scope = spfile;

System altered.

SQL> startup force
ORACLE instance started.

Total System Global Area 1105756904 bytes
Fixed Size 729832 bytes
Variable Size 788529152 bytes
Database Buffers 314572800 bytes
Redo Buffers 1925120 bytes
Database mounted.
Database opened.
SQL> create table t1(c1 number);

Table created.
SQL> audit insert on t1 by access;

Audit succeeded.

SQL> insert into t1 values (2);

1 row created.

SQL> select * from aud$;

no rows selected

SQL> commit;

Commit complete.

SQL> select * from aud$;

no rows selected

SQL> show parameter audit

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
audit_file_dest string ?/rdbms/audit
audit_sys_operations boolean FALSE
audit_trail string TRUE
transaction_auditing boolean TRUE