Toad World® Forums

Clear Cache after each SQL optimizer run ?

alter system flush buffer_cache;

alter system flush shared_pool;

Thanks
Elesh

Morning Everyone,
A quick question, is anyone aware of how to clear the cache, ie run these commands between each SQL Optimization run such that the optimization results do not subsequently use the cache …

Hi Elesh

The command to clear buffer is:
alter system flush buffer_cache;

The latest beta version of SQL Optimizer do have this option added to clear buffer cache for you in between each SQL run.

Thanks,
Alex

Hi Alex,

Thanks for getting back to me, any chance of finding out whether the beta version is available for download and play ?

Thanks
Elesh

Hi Elesh,

Sure, the beta is available for community users. You can actually find the link “Beta v8.5.0” under “DOWNLOADS” on the left hand side (above the blue “Additional Resources” box). Or you can use this link: http://sqloptimizeroracle.inside.quest.com/beta.jspa

Let me know if you have problem downloading or using the beta.

Thanks,
Alex

Hi Alex,

Thanks for your help Alex.
Clicking the download link seems to hang, are there some issues with the download server ?

Thanks
Elesh

Not quite yet …

Hi Elesh,

I have just tried the download and it should work. Can you please try it again?

Thanks,
Alex

Hi,

We are using oracle 9.2.0.8.0, it looks like alter system flush buffer_cache is not working.
Could you please help me ?

Cheers.

Hi ,

Oracle 9i do not support “alter system flush buffer_cache” command.

Ken