Home » Server Options » RAC & Failsafe » dbms_stats.gather_system_stats in rac
dbms_stats.gather_system_stats in rac [message #109405] Thu, 24 February 2005 07:17
pbilodeau
Messages: 1
Registered: February 2005
Location: Quebec
Junior Member
Hi, in 10g documentation it is recommand to run system statistics for the CBO can decide the best plan to use with information on CPU and I/O, but in RAC architecture, i had 5 nodes, and 2 nodes is for batch job and 3 nodes for OLTP if some of my instance run batch job and other

run oltp and Oracle had just one dictionnary table for keeping stats, what can i do with this? if i gather stats on oltp server, my batch

job server will not run plan correctly and vis versa....

anyone has an idea how to treate this?

Thanks for your anwser

Pierre
Previous Topic: Migration from Single Database to RAC implementation
Next Topic: Oracle 10g on Solaris 10 with storage
Goto Forum:
  


Current Time: Mon Dec 06 17:20:39 CST 2021