7 Replies Latest reply: May 20, 2011 3:49 AM by Aman.... RSS

    nk db_cache_size error

    849883
      Hi,

      I am occasionally getting this ora-00379 error.
      ORA-00603: ORACLE server session terminated by fatal error
      ORA-00379: no free buffers available in buffer pool DEFAULT for block size 8K
      ORA-00604: error occurred at recursive SQL level 2

      I don't have any specific value set to 8k, 16k, 32k cache size and I have allowed Oracle to self manage the memory. To tackle this particular error should I set a large value from the SGA propotion and leave others (16k, 32k, etc) unchanged?

      Thanks
        • 1. Re: nk db_cache_size error
          Aman....
          rac100g wrote:
          Hi,

          I am occasionally getting this ora-00379 error.
          ORA-00603: ORACLE server session terminated by fatal error
          ORA-00379: no free buffers available in buffer pool DEFAULT for block size 8K
          ORA-00604: error occurred at recursive SQL level 2

          I don't have any specific value set to 8k, 16k, 32k cache size and I have allowed Oracle to self manage the memory. To tackle this particular error should I set a large value from the SGA propotion and leave others (16k, 32k, etc) unchanged?
          What's the default block size of your db? Looks like you are not using 8kb as the default one. If that's the case, you must set the non-default cache for that block size using the parameter db_8k_cache_size since the default cache won't be able to manage it. And the automatic management does not for nk_cache_size parameters but only for default cache parameter-db_cache_size.

          HTH
          Aman....
          • 2. Re: nk db_cache_size error
            Helios-GunesEROL
            Hi;

            Please see:

            OERR: ORA-379 no free buffers available in buffer pool %s for block size %sK [ID 75123.1]


            Regard
            Helios
            • 3. Re: nk db_cache_size error
              849883
              my db_block_size is 8k.
              • 4. Re: nk db_cache_size error
                849883
                Hi Helios,

                I read the doc you posted.
                In my case, I don't have any of these set,
                db_16k_cache_size
                db_2k_cache_size
                db_32k_cache_size
                db_4k_cache_size
                db_8k_cache_size
                db_block_buffers

                My question is asking if we need to allocate a fixed or minimum cache size for this particular 8k db block.

                Regards
                • 5. Re: nk db_cache_size error
                  Aman....
                  If your db block size is 8kb and you want to set a minimum value for it's cache, set some value for db_cache_size . This would act as like a minimum value that would always be there for the db_cache_size .

                  Aman....
                  • 6. Re: nk db_cache_size error
                    849883
                    From RDA, i see there is a hidden parameter,
                    __db_cache_size which is more than 2000000000

                    currently the db_cache_size is also set to 0.
                    • 7. Re: nk db_cache_size error
                      Aman....
                      rac100g wrote:
                      From RDA, i see there is a hidden parameter,
                      __db_cache_size which is more than 2000000000

                      currently the db_cache_size is also set to 0.
                      It's not hidden but auto-tuned parameter since its using two underscores. The hidden parameters start with a single underscore. The db_cache_size=0 is because you are using the automatic SGA memory management.

                      Aman....