Thank you Rich. The documentation only mentions cursors, but I'll test it. Thank you, Jay On Wed, Jun 1, 2011 at 4:15 PM, Rich Jesse <rjoralist2@xxxxxxxxxxxxxxxxxxxxx > wrote: > > 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 > > -- > //www.freelists.org/webpage/oracle-l > > >