Execution of DBMS_AUDIT_MGMT.SET_AUDIT_TRAIL_LOCATION results in Deadlock in 11.2.0.3 Database
BEGIN
DBMS_AUDIT_MGMT.SET_AUDIT_TRAIL_LOCATION
(audit_trail_type => DBMS_AUDIT_MGMT.AUDIT_TRAIL_DB_STD,
audit_trail_location_value => 'USERS');
END;
/
in a unbusy test database 11.2.0.3 caused
ORA-02002: error while writing to audit trail ORA-00060: deadlock detected while waiting for resource ORA-06512: at "SYS.DBMS_AUDIT_MGMT", line 1659.. .
Only after disable the Audit with NOAUDIT CREATE SESSION the execution was successful.
There is no hint in actual documentation Oracle Database PL/SQL Packages and Types Reference 11g Release 2(11.2), Chap.27-25 to do this, only "... Oracle recommends that you invoke the procedure during non-peak hours ..." !