Database Administration (MOSC)

MOSC Banner

Execution of DBMS_AUDIT_MGMT.SET_AUDIT_TRAIL_LOCATION results in Deadlock in 11.2.0.3 Database

edited Feb 14, 2013 3:17AM in Database Administration (MOSC) 1 comment
The execution of

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 ..." !

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center