Oracle 19 EE RU -patch: Is there a way datapatch could be run without the auto recomp at the end?
We have a 19 RAC env, where we have several dbs, and in this env there is one annoying db where datapatch often hangs (for many hours) in recomp. Not always, but often - some RU datapatches have gone normally (for example Oct23, Jan24) but some do not (Jul23, Apr24). We've had several SRs open about this, but no real resolution. So we have to ctrl-end the datapatch, fix the problematic object where the hangup -issue occurs (MDSYS.SDO_GEOMETRY) and do recompiling by hand (utlrp). After this the db is ok, but of course patch registry show wrong status (END),