3 Replies Latest reply: Dec 2, 2012 11:44 PM by Aman.... RSS

    flushing memory

    902332
      hi all,

      if we use the command

      alter system flush shared_pool or alter system flush buffer_cache

      what exactly happens, does it delete the database from the memories,

      suppose if some transactions are going on in buffer cache what happens to that transaction, does it cancel..

      Please let me know. thanks for you help.
        • 1. Re: flushing memory
          sb92075
          899329 wrote:
          hi all,

          if we use the command

          alter system flush shared_pool or alter system flush buffer_cache

          what exactly happens, does it delete the database from the memories,

          suppose if some transactions are going on in buffer cache what happens to that transaction, does it cancel..

          Please let me know. thanks for you help.
          consider to Read The Fine Manual yourself to learn desired answers

          http://docs.oracle.com/cd/E11882_01/server.112/e26088/statements_2014.htm#SQLRF00902
          • 2. Re: flushing memory
            Osama_Mustafa
            Also this could help you
            http://www.datadisk.co.uk/html_docs/oracle/memory.htm
            • 3. Re: flushing memory
              Aman....
              899329 wrote:
              hi all,

              if we use the command

              alter system flush shared_pool or alter system flush buffer_cache

              what exactly happens, does it delete the database from the memories,
              The database or you meant data ? The commands do as what they are supposed to, just flush the data from the memory. The next access of that flushed data would come from the disk access.

              >
              suppose if some transactions are going on in buffer cache what happens to that transaction, does it cancel..
              What do you think should happen? As long as there is no explicit (or implicit) commit or rollback action, the transaction remains active. So the answer is a no .
              Please let me know. thanks for you help.
              Consider going with the suggestion of Sb and start reading Concepts guide. It contains tons of info on such questions .

              Aman....