Return
-
Title
What is PPCM job and how to turn off predictive diagnostic ? -
Description
What is PPCM job and how to turn off predictive diagnostic ?
-
Resolution
PPCM is used for the feature to provide predictic diagnostic. The easiest way is to drop cascade that Spoltight user and create one without Predictive Diagnostic feature (assuming that that user is used for this Spotlight only).
When you re-run the GUI wizard for that Oracle user you would uncheck the box Predictive Diagnostic at the end of the wizard.So you can entirely drop the objects for the Spoltight user (via the drop scripts), or drop the user altogether, and then rerun the User Wizard to recreate the user (or create a new user) and answer NO to - " do you want Predictive Diagnostics " -, which will disable the whole feature.ÂManual scripts by default are here: c:\Program Files\Quest Software\Spotlight\Plug-ins\SoO\OracleScriptsÂIn script DROP_OBJECTS_spot.sql (executed as SYS), the code:Âaccept soo_owner prompt "SoO Owner to remove objects from: ";
set verify off
prompt Dropping Predictive Diagnostics Jobs...begin
for row in (select job from dba_jobs where priv_user=upper('&soo_owner') and what like '%quest_ppcm%') loop
dbms_ijob.remove(row.job);
end loop;
commit;
end;
/will drop the Predictive jobs.