Posted on 2000-04-05
Sometimes when I compile a package, Toad locks up and eventually times out with ORA-04021: timeout occurred while waiting for a lock on object ...
How do I know what session is blocking the compile? OEM lock manager does not seem to show anything.
Also, this particular package is used infrequently, has no package variables, and when it is used, the action takes only a few seconds and is always committed. It seems strange that there should be any contention for this object. What's happening here?