Re: How are OCM jobs recreated by catbundle.sql?

From: Rich J <rjoralist3_at_society.servebeer.com>
Date: Thu, 15 Oct 2015 08:38:25 -0500
Message-ID: <8caa27b4c5cd23afa45c0d9460bdeba1_at_society.servebeer.com>


 

On 2015/10/14 18:56, De DBA wrote:

> I seem to remember that these jobs can be reenabled by running the recompile procedure utl_rcmp, but I may be wrong.
>
> catbundle creates an Apply script that you then execute - did you also check that script?

Hey Tony,

I started to look through the chain of UTL recompile code, but since the packages are wrapped, I can't find anything definitive. There's no dependency on the packages in the ORACLE_OCM schema, either, so I'm probably at a dead end unless I want to open an SR.... Nah...not worth the hassle.

On a happy side note, I discovered that the package bodies in ORACLE_OCM are not wrapped. It's nice to be able to see exactly what data OCM is collecting.

Thanks!
Rich

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Oct 15 2015 - 15:38:25 CEST

Original text of this message