Jonathan Lewis wrote: > Looks like you've hit the big problem with RAC -
Do you think it's really the big problem? I'm just thinking about Oracle APPS instance or something alike. Somebody could start object recompilation (maint. pack/adadmin), synonyms creation or whatever like that on a node. Meanwhile full obj$ scan is/will go on on other node. How often people do FTS of obj$ on OLTP systems? Raj, do you need that query? :) > how many nodes do you have, how busy > are the nodes which are supposed to supply > with with CR copies across the interconnect, > and what's the latency and bandwidth of your > interconnect ? (And how did you get that many > objects into obj$ !!!) There is 80% probability that many of those are/were synonyms or that system is fully synonyms based. I have no other idea -- 463566 looks really cool. Raj, what's that? P.S.: Do I have a good imagination? :) Kind Regards, -- Vladimir Begun The statements and opinions expressed here are my own and do not necessarily represent those of Oracle Corporation. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Vladimir Begun INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
