alter session set events = 'immediate trace name flush_cache'

Greetings,

How to identify if system has flushed data buffer after issuing this command

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. How can I identify weather buffer_cahce has been cleared ? at least my query data should have been flushed out.

thanks in advance Received on Tue Jul 18 2006 - 05:53:21 CDT