Re: How do u make Oracle forget data buffered from previous queries?
From: Youichi Tamura <y-tamura_at_nriws11.nri.co.jp>
Date: Fri, 30 Sep 1994 09:46:39 GMT
Message-ID: <CwxsHs.3tz_at_nrigw11.nri.co.jp>
> Is there an easy way to flush everything buffered from previous queries?
> I wan't to time a number of queries, and as the time varies depending on
> what's been queried about earlier, I need to flush everything chached.
Date: Fri, 30 Sep 1994 09:46:39 GMT
Message-ID: <CwxsHs.3tz_at_nrigw11.nri.co.jp>
>Hans Lindberg (d7hansl_at_dtek.chalmers.se) wrote:
> Is there an easy way to flush everything buffered from previous queries?
> I wan't to time a number of queries, and as the time varies depending on
> what's been queried about earlier, I need to flush everything chached.
Why don't you:
SQL> alter system flush shared_pool;
and clear all data from the SGA shared pool?
-- Yoichi Tamura y-tamura_at_nri.co.jpReceived on Fri Sep 30 1994 - 10:46:39 CET