Problem compiling PL/SQL concurrently on different SCHEMAs of the same Database
Hi,We have a problem where our Continuous integration environment attempts to create many schemas on a shared database server concurrently.
What we get is that the scripts we use to create the database report (using "select object_name,object_type from user_objects where status = 'INVALID'") immediately after DBMS_UTILITY.COMPILE_SCHEMA.
If we connect to the schema and compile, say, from sqldeveloper all is OK.
Our experience seem is:
- With one shared database this works perfectly for 1 create at a time, and breaks for 2 or more.
- For another shared database it works perfects for 1,2,3 or 4 at a time - and breaks for 5, 6, etc...
0