Database Administration (MOSC)

MOSC Banner

Problem compiling PL/SQL concurrently on different SCHEMAs of the same Database

edited Jan 17, 2013 6:02AM in Database Administration (MOSC) 10 commentsAnswered
 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...

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center