June 26, 2012 9:34 am
If you are running BPM and you are not using B2B, you might want to disable the DBMS job that refreshes the B2B materialized view. This job runs every minute by default.
To find the job, use a query like the one below. Update the schema user to match the environment:
select job , schema_user , broken , what , interval from dba_jobs where schema_user = “DEV_SOAINFRA”
Look for the job which contains something like the following in the WHAT column. Note that it may be different if a different schema prefix was used in the environment.
dbms_refresh.refresh('"DEV_SOAINFRA"."B2B_SYSTEM_MV"');
To remove the job, take note of the job number from the JOB column and then use a command like the following, substituting in the correct job number in place of 24:
begin dbms_job.remove(24); end;
Alternatively, alter the materialized view to be refreshed on demand, using a command similar to this:
alter materialized view dev_soainfra.b2b_system_mv refresh on demand;
Posted by Mark Nelson
Categories: Uncategorized
You must be logged in to post a comment.
Mobile Site | Full Site
Get a free blog at WordPress.com Theme: WordPress Mobile Edition by Alex King.
[…] Customization) by Andrejus Baranovskis BPMN process editor problems in 11.1.1.6 by Mark Nelson BPM – Disable DBMS job to refresh B2B Materialized View by Mark […]
By Process Accelerator Kit « SOA Community Blog on July 16, 2012 at 4:59 pm