This discussion is archived
7 Replies Latest reply: May 20, 2011 1:49 AM by Aman.... RSS

nk db_cache_size error

849883 Newbie
Currently Being Moderated
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.... Oracle ACE
    Currently Being Moderated
    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 Oracle ACE
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    my db_block_size is 8k.
  • 4. Re: nk db_cache_size error
    849883 Newbie
    Currently Being Moderated
    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.... Oracle ACE
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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.... Oracle ACE
    Currently Being Moderated
    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....

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points