SELECT value from v$parameter where name='audit_trail';

VALUE

DB, EXTENDED;

AUDIT ALTER ANY TABLE, CREATE ANY TABLE , DROP ANY TABLE , DELETE ANY TABLE , INSERT ANY TABLE , UPDATE ANY TABLE BY MYUSER BY ACCESS;