See what I mean - it took you 14 days to find it ! ;)
--
Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk
Robert Goold wrote in message <38a3469b.4724648_at_news.compuserve.com>...
>Server Concepts 7.3 Chapter 9 Memory Structures and Processes p9-24
>
>"... When the ANALYZE command is used to update or delete the
>statistics of a table, cluster, or index, all shared SQL areas that
>contain statements that reference the analyzed object are flushed from
>the shared pool. The next time a flushed statement is executed, the
>statement is parsed in a new shared SQL area to reflect the new
>statistics for the object. ..."
>
>Regards
>
>Robert
>
>On Wed, 26 Jan 2000 07:13:29 -0000, "Jonathan Lewis"
><jonathan_at_jlcomp.demon.co.uk> wrote:
>
>>
>>My biggest problem with the manuals is trying to
>>find something that I know exists.
>>
Received on Thu Feb 10 2000 - 00:00:00 CST
