| Time out error [message #60032] |
Sun, 11 January 2004 20:26  |
Parag
Messages: 10
Registered: July 2002
|
Junior Member |
|
|
Hi,
I have one procedure which is schedule to run dialy. This procedure
Only fails on Saturday but run successfully other week days. Some times it also run on Saturday but it takes long time to execute, almost 3 hours.
I am geting the following below oracle error when the procedure failed to execute:
ERROR at line 1:
ORA-04021: timeout occurred while waiting to lock object DATA.T1_Trigger
ORA-06512: at "DATA.MISSING_ITEM", line 34
ORA-06512: at line 1
DATA.MISSING_ITEM is a procedure and DATA.T1_Trigger
is a trigger.
The procedure gets time out when it tries to disable the trigger 'DATA.T1_Trigger' on line 34.
Alter trigger T1_Trigger disable;
What will be the possible solution for this.
Thanks in Advance!
Regards,
Parag
__________________
parag
|
|
|
|
| Re: Time out error [message #60045 is a reply to message #60032] |
Mon, 12 January 2004 07:18  |
Thiru
Messages: 1089
Registered: May 2002
|
Senior Member |
|
|
Hi,
what happens when you manually recompile the trigger before executing this process(procedure). You want the trigger to be disabled during this process or you are disabling just to troubleshoot ?
You could check v$access, v$db_object_cache , v$session_wait during this lock, for more information.
-Thiru
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
