RE: Oracle 11g and fine-grained invalidation(B

From: Michael Rosenblum(B <mrosenblum_at_dulcian.com>
Date: Thu, 9 Sep 2010 13:16:38 -0400
Message-ID: <2673A0170447634DA7F7ABCA51E89FA9A6B3E16AC4_at_MAIL2.dulcian.local>

I just checked my 10.2.0.4 database for SYS.DEPENDENCY$.D_ATTRS - and looks like Oracle already started to use that column even in 10g and in my instance there are only the following values:

02,06,0E,1E,3E,7E,FE

It appears that the column represents references to synonyms (including Oracle's own, like, DUAL or USER_TABLES) by articulating whether you have %ROWTYPE reference, COUNT(*), explicit list of columns etc (btw, the list of values reminds me what we have in 11g after initial 8-byte type).

Michael Rosenblum

Dulcian Inc

$B!!(B

-----Original Message-----

From: Yong Huang [mailto:yong321_at_yahoo.com]

Sent: Thursday, September 09, 2010 12:38 PM

To: Michael Rosenblum

Cc: oracle-l_at_freelists.org

Subject: Re: Oracle 11g and fine-grained invalidation

$B!!(B

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 - 12:16:38 CDT