How to detect Package Compilation confilcts
We have been struggling with this problem for a few days now and have resorted to bouncing the database in order to clear the problem but there must be a way of finding out what is preventing a package from compiling?
There are some locks on the system, and using TOAD (sorry, I'm not a DBA by any means), we can see these and TOAD tells us its not blocking any other user (its good at showing blocking locks if users are trying to perform DML on the same tables). But could these locks be blocking the package compilation - and if they are, how do I prove it?
So simply, I am trying to compile a package and it is timing out. How can I determine why its not compiling?
Thanks in advance.
Richard