Re: Oracle 11g and fine-grained invalidation

From: Yong Huang <yong321_at_yahoo.com>
Date: Thu, 9 Sep 2010 09:37:36 -0700 (PDT)
Message-ID: <581164.20971.qm_at_web80607.mail.mud.yahoo.com>



Michael,

Indeed Rob Van Wijk and Toon Koppelaars's research is impressive. I want to add that you can disable fine-grained invalidation by setting _IGNORE_FG_DEPS to NONE.

Also, even in 10g, dependency$ has d_attrs column with the same comment (as seen in sql.bsq), "Finer grain attr. numbers if finer grained". But we know 10g doesn't have fine-grained invalidation yet.

Yong Huang       

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Sep 09 2010 - 11:37:36 CDT

Original text of this message