DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4
  1. #1
    Join Date
    Feb 2010

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

    Attached Files Attached Files

  2. #2
    Join Date
    Sep 2002
    what issue are you having?
    and why are you flushing the shared pool like this - seems like a bad thing to do

  3. #3
    Join Date
    Feb 2010
    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.


  4. #4
    Join Date
    Mar 2007
    Ft. Lauderdale, FL
    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?
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.