This is very much effective and simple code for segregating resource to specific RAC instance.
BEGIN
sys.dbms_scheduler.set_attribute( name => 'JOB_NAME', attribute => 'instance_id', value =>1);
END;
BEGIN
sys.dbms_scheduler.set_attribute( name => 'PARSING_NV1GEN1_12', attribute => 'instance_id', value =>1);
END;
BEGIN
sys.dbms_scheduler.set_attribute( name => 'JOB_NAME', attribute => 'instance_id', value =>1);
END;
BEGIN
sys.dbms_scheduler.set_attribute( name => 'PARSING_NV1GEN1_12', attribute => 'instance_id', value =>1);
END;
No comments:
Post a Comment