> 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. Cool solution! :) Thanks for the information, Tanel. > > 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). ---------------------------------------------------------------- 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 -----------------------------------------------------------------