OraFAQ Forum: RAC & Failsafe » dbms_stats.gather_system

Home » Server Options » RAC & Failsafe » dbms_stats.gather_system_stats in rac

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Nov 28 06:07:58 CST 2024