I am interested in deploying the procedure Flush_IT on my test environment and later production. I attached the procedure with the changes that I made.
But am experiencing few issues with the procedure:
First the table SQL_SUMMARY was a problem I replaced it with STATS$SQL_SUMMARY.
That looked fine now am having the issue with table or view dba_running_stats.
The table or view does not exist.
If there is anyone who implemented the scripts I will appreciate the help....
I would side with Dave and look into fixing the issue rather than making flush shared_pool a feature of my system.
Are you pinning your large, most used packages/procs?
Are you certain you are using bind variables when possible on offending code?
Is there any chance shared_pool is under allocated and a larger one is needed?
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.