PROCEDURE Flush_It

Hi Guys...

I am running Oracle 9i on Solaris.

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

Thanks

what issue are you having?
and why are you flushing the shared pool like this - seems like a bad thing to do

Thanks davey23uk for the reply...

I am experiencing a lot of:

ORA-04031: unable to allocate 4096 bytes of shared memory ("shared pool","DECLARE job BINARY_INTEGER :...","PL/SQL MPCODE","BAMIMA: Bam Buffer")...

This becomes a nightmare for my environment...

I decided to implement this and run it at adhoc basis...

Now when I compile the procedure as system or user with dba role.

The user can't find the table or view dba_running_stats.

Thanks

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?