ORA-04021 Timeout occured while waiting to lock object [message #434467] |
Wed, 09 December 2009 06:03  |
 |
didiera
Messages: 134 Registered: August 2007 Location: Mauritius
|
Senior Member |
|
|
Hello,
I have a package which I modified and was trying to recompile but whenever I try recompilation, I get Oracle error ORA-04021. A timeout occurs while waiting to lock package for recompilation. Attempting to drop the package then recreate it also behaves the same way. My package has only 2 particularities (and they might not be blamed for this situation anyway) :
1] It uses CLOB variables (fiel read into CLOB variable)
2] It dynamically disables and enables constraints on other user tables.
I have also tried flushing Shared Pool but to no avail.
thanks for your lights,
Didier
|
|
|
|
|
|
|
|
|
|
|