3 Replies Latest reply: Nov 22, 2013 12:36 PM by TSharma-Oracle RSS

    purge vs restart

    user12075620

      Hi,

       

      We had an issue in one of the RAC database last week.  We could not get any improvements after purging the shared pool, but after re-starting the database the problem went away. My question is how the db restart differs from the shared pool?

      Experts, please advise on this.

        • 1. Re: purge vs restart
          TSharma-Oracle

          We do not know which problem you are talking about? We are not psychic here. Did you flush shared pool? There is nothing like purging shared pool. Tell us about the problem which lead you to restart the system.

          • 2. Re: purge vs restart
            user12075620

            Yes, I am talking about the flushing the shared pool. The tool was keep on throwing an error saying that "table does not exist" though with all the permissions. We flushed the shared pool-no improvements. Finally we bounced the database and the problem went away.

             

            What could be the reason ??

            • 3. Re: purge vs restart
              TSharma-Oracle

              There is not any relationship between the error you got and flushing shared pool. With NO re-producible case, it is hard to give any explanation on your problem. I suggest you mark this question an answered and open a new thread when next time you get the same problem but before restarting the database.