analyze invalidating dependant SQLAREA stuff?

From: Kevin Brand <kevin.brandx_at_tel.gte.com>
Date: Thu, 5 Nov 1998 12:17:27 -0600
Message-ID: <71sq7s$fbr$1@news.gte.com>

Given the following statements:

analyze table mytab compute statistics [ { FOR ALL } COLUMNS | INDEXES ] OR
execute sys.dbms_utility.analyze_schema('SCHEMA','COMPUTE',0,0,'[ { FOR ALL } COLUMNS | INDEXES ]') Should I expect that all analyzed-object-dependant SQL code in the Shared Pool will be invalidated or otherwise required to be reloaded/parsed upon next execution?

If so, short of holding off on nightly re-computes, how does one compensate for this artificial lowering of Library Cache:SQL AREA hit ratio?

-Kevin

remove the x for an email reply Received on Thu Nov 05 1998 - 12:17:27 CST