The PL/SQL hanges in one schema during the compilation, but it did compile fine for another schema, both schemas are in the same instance, we did analyze the two schemas nightly,any ideas?
Printable View
The PL/SQL hanges in one schema during the compilation, but it did compile fine for another schema, both schemas are in the same instance, we did analyze the two schemas nightly,any ideas?
Hi,
usually if compilation hangs, the (old, before-image) pl/sql-unit is locked due to hold by a session.
Orca
:cool: