Rolling_profiles Job In Demantra Doesn't Execute Through DBMS_JOBS in 12.2.5.1 (Doc ID 2288259.1)

Last updated on DECEMBER 04, 2019

Applies to:

Goal

Customer has upgraded to 12.2.6.1

VERSION BUILD SP Upgrade Date
12.2.6 2 12260250 27-APR-2017 03:17:34
12.2.6 1 12260251 27-APR-2017 02:57:20
12.2.6 112 0 26-APR-2017 13:23:00
7.3.1 48 UPGRADED FROM 26-APR-2017 06:12:59
7.3.1 1 7310234 10-MAY-2014 19:46:11
7.3.1 2 7302173 20-AUG-2013 23:11:54
7.3.1 48 0 13-SEP-2011 13:38:22

Post that they have noticed that the Rolling_profiles job in demantra doesn't execute through DBMS_JOBS anymore

They have turned on the below db parameters, but dont see that rolling_profiles are executing through dbms_jobs and ITEMS join is not added in update statement.

UPDATE DB_PARAMS SET PVAL='TRUE' WHERE PNAME='RollingUpdatesUseJobQueues';
UPDATE DB_PARAMS SET PVAL='TRUE' WHERE PNAME='RollingUpdatesRenameColumns';
UPDATE DB_PARAMS SET PVAL='ITEMS' WHERE PNAME='RollingupdatesDimLevelStep';
UPDATE DB_PARAMS SET PVAL='TRUE' WHERE PNAME='RollingUpdatesOneCommit';

In the upgraded instance it now does not run through dbms_jobs , but as a direct SQL driven by application

There is no issue with the execution. Question is, rolling_profiles execution is driven by dbms_jobs before , now not by it. Ask is to know if that is how the latest version is designed to.

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.