Re: alter session set events = 'immediate trace name flush

From: <yong321_at_yahoo.com>
Date: 18 Jul 2006 09:48:22 -0700
Message-ID: <1153241301.954087.260540@b28g2000cwb.googlegroups.com>

Schandamama_at_gmail.com wrote:
>
> alter session set events = 'immediate trace name flush_cache'
>
> I am on 9i. I am issuing alter system flush shared_pool also along
> with it to test some query for tuning. What I see the difference is,
> first time it seems everything is retrieved as fresh; but later I do
> not see much difference. ...

The difference in performance or wall clock timing? If so, maybe the data is cached by the filesystem. If the difference is in physical reads reported by Oracle, the flush_cache event should always work (but see Mladen's message).

Yong Huang Received on Tue Jul 18 2006 - 11:48:22 CDT

Re: alter session set events = 'immediate trace name flush_cache'