Very long compile times

[Dean Lamper]

We recently switched to Oracle10g2 and Pl/SQLDev v7 a few weeks later.

All developers now face ridicilous compile times when package containes syntax errors. If syntax is OK, it compiles under one second.

Erroneous package compile times are up to one hour. Looking at oracle statistics we observed large amont of library cache pin waits.

Any idea? Is this oracle's quirk or Pl/SQLDev's?

 

[Marco Kalter]

What happens if you perform the same compilation in SQL*Plus?

 

[Dean Lamper]

It is not a Pl/SQL Dev problem, it was same with SQL*Plus.

But today it just magically works. Admins claims he did not change anything. 10g2...