Focus on DB architect mail:ylouis83#gmail.com

Using TUNE_MVIEW and EXPLAIN_REWRITE to enable us to tune MV Fast Refreshes and Query Rewrites

Posted by admin on 17th October 2011

We can use the DBMS_MVIEW.EXPLAIN_REWRITE package (which was first introduced in Oracle 9i if memory serves me right) to diagnose why Query redirectio[……]

Read more

Posted in Oracle Experience | 7 Comments »