Re: Oracle 11g and fine-grained invalidation

From: Yong Huang <>
Date: Thu, 9 Sep 2010 09:37:36 -0700 (PDT)
Message-ID: <>


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       

Received on Thu Sep 09 2010 - 11:37:36 CDT

Original text of this message