Hello everybody,
Here is my situation. In the company I am working for, we have a routine that recompiles an Oracle schema after each deploy. We usually do many deploys during the day for testing purposes and this recompilation help us to identify invalid objects in the end of each deploy. These compilations are done sequentially. Now I need to develop a routine that recompiles schemas in parallel using the same Oracle instance.
Every time I try to compile two schemas at the same time, I receive an Invalid Objects message in at least one of them. However, compiling the objects manually shows that they are not invalid. Looks like the compilation was not done at all. This problems just occur when I need to compile in parallel. I tried using DBMS_UTILITY.COMPILE_SCHEMA and SYS.UTL_RECOMP.RECOMP_PARALLEL with no success.
So here is the question. Do you know if it is possible to compile different schemas on the same Oracle client at the same time? In positive case, there is any guideline that I should follow to achieve this?