Re: v$db_object_cache loads
From: Rich Jesse <rjoralist2_at_society.servebeer.com>
Date: Wed, 1 Jun 2011 15:15:54 -0500 (CDT)
Message-ID: <e7f47b454a05ac947f14181501e8a100.squirrel_at_society.servebeer.com>
Hey Jay,
Date: Wed, 1 Jun 2011 15:15:54 -0500 (CDT)
Message-ID: <e7f47b454a05ac947f14181501e8a100.squirrel_at_society.servebeer.com>
Hey Jay,
>>> Can anyone tell me why I have some objects being reloaded in the SGA,
>>> even
>>> though they are pinned? To my knowledge, no dependent objects are being
>>> modified. I had posted a similar question last year when this DB was
I had this same question a number of years ago. A surviving brain cell thinks the invalidation was coming from stats collection in my case.
I believe that the default for the "no_invalidate" option of GATHER_x_STATS in the DBMS_STATS package is FALSE, which *will* invalidate dependent objects. Likewise, TRUE will *not* invalidate -- it seems backwards with the negatively-named option.
Sorry, but I need to leave this up for you to prove.
HTH! GL! Rich
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Jun 01 2011 - 15:15:54 CDT