Re: Extremely Slow Query

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: Vladimir.Begun_at_oracle.com

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: ListGuru_at_fatcity.com (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).