Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

DBMS_SCHEDULAR JOB STICKINESS ON PARTICULAR NODE IN RAC

1036966Aug 30 2013 — edited Sep 4 2013

Hi All,

I am using 10g rac . We have scheduled gather stats on node 1 from OEM with instance stickiness is False.

but it is running on node2 sometimes . When it runs on node 2 , node 1 is up and running with lightest load.

I am confused why it is running on node 2?

Please help me out what are the possibilities for this issue.

Thanks,

Roopesh

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 2 2013

Added on Aug 30 2013

#database-key-features, #scheduler

3 comments

9,919 views