Database - RAC/Scalability (MOSC)

MOSC Banner

One Db Scheduled Job (With Db Queue), the Attribute parallel_instances has some wrong in RAC.

edited Aug 21, 2024 1:04AM in Database - RAC/Scalability (MOSC) 4 commentsAnswered

We are going to make the RAC (Two Nodes) from Standalone Instance, we have Db Scheduled Jobs (With Db Queue), we set the Attribute parallel_instances as True due to the needs of our business.

e.g. as below

begin dbms_scheduler.set_attribute('xxxx','parallel_instances',TRUE);end;/

Submitting a single or multiple queues in instance 1, it CAN NOT trigger scheduler job created on instance 2. ===================================================================

So any aspects we need to consider for the Db Scheduled Jobs and Queue in RAC? Thanks.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center