Re: Anyone seen weblogic do this?
- From: Connor McDonald <hamcdc@xxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Fri, 2 Jul 2004 14:54:26 +0100 (BST)
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 //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
