Re: Anyone seen weblogic do this?

Here's today bizarre relationship...

We created some single table aggregate fast refresh materialised views, but no 
matter how hard we
tried to follow the rules as per the manuals, the darn things would not allow a 
fast refresh. 
Some tracing showed that things started to go wrong as the pre-processor did 
some select's from
dual (retrieving the rowid from dual of all things.)

And our DUAL was a local IOT...So we converted dual back to its normal form and 
voila! our fast
refreshes now worked.  Now our DUAL is a heap with an index as well so we get 
the best of both
worlds.

Cheers
Connor

--- Tanel_Põder <tanel.poder.003@xxxxxxx> wrote: > If you cannot eliminate 
these excessive queries
by any means, then you could
> relieve the performance hit by having a local dual synonym pointing to a
> view uner sys schema whish queries x$dual instead. That way you'd eliminate
> 3 LIOs per query in 9i (in RAC environment you have to do a little extra
> trick to query only your instance's row from x$dual).
> 


=====
Connor McDonald
Co-author: "Mastering Oracle PL/SQL - Practical Solutions"
ISBN: 1590592174

web: http://www.oracledba.co.uk
web: http://www.oaktable.net
email: connor_mcdonald@xxxxxxxxx

Coming Soon! "Oracle Insight - Tales of the OakTable"

"GIVE a man a fish and he will eat for a day. But TEACH him how to fish, 
and...he will sit in a boat and drink beer all day"

------------------------------------------------------------


        
        
                
___________________________________________________________ALL-NEW Yahoo! 
Messenger - sooooo many all-new ways to express yourself 
http://uk.messenger.yahoo.com
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Other related posts: