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
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