Errors in oracle alert log - Error Code - Ora-00060 deadlock detected
Example Predictive Diagnostic jobs blocking each other:
65 SPOTLIGHT NN-NNN-NN NN:NN:00 NN-NNN-NN NN:NN:NN BEGIN
/*Quest PPCM Bottleneck job */ quest_ppcm_bottleneck.
collect_data; END;
64 SPOTLIGHT NN-NNN-NN NN:NN:00 NN-NNN-NN NN:NN:NN BEGIN /*Quest
SOO PPCM job */ quest_ppcm_snapshot_pkg.take_ snapshot; END;
Change one of the job’s Interval:
1. Open this ppcm connection;
2. Go to Spotlight Options -> Predictive Diagnostics -> Impending Bottlenecks Oracle job;
3. Change the default Interval value for this job from 30 minutes to 35 minutes or other value;
4. Save this change and restart Spotlight to see if it works.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center