ORA-04021: timeout occurred while waiting to lock object
693765Nov 12 2009 — edited Nov 16 2009Hi,
I try to create a trigger (using 11g) and I get the following error after few minutes:
ORA-04021: timeout occurred while waiting to lock object
The trigger I'm trying to create is the following:
CREATE OR REPLACE TRIGGER logon_audit
AFTER LOGON ON DATABASE
BEGIN
INSERT INTO connection_audit
(login_date, user_name)
VALUES
(SYSDATE, USER);
END logon_audit;
Does anybody know what is the problem?
Is there any way to discover what is the problem?
Thanks
dyahav
Edited by: dyahav_ on 08:54 12/11/2009