Home » RDBMS Server » Server Administration » ORA-00379 (10.2.0.4, RDBMS 3 node RAC, Win2003 server x64)
ORA-00379 [message #377241] Mon, 22 December 2008 01:44 Go to next message
hristo
Messages: 258
Registered: May 2007
Senior Member
Hi!

Saw some:
ORA-00379: no free buffers available in buffer pool 
ORA-00379: no free buffers available in buffer pool DEFAULT for block size 8K

in one of my RAC DBs.

This happened during the nigth, when no users are connected. Some batchjobs are running but nothing serious.

Surfed around for this error but have not found that much.

Should I:
Increase the DB_BLOCK_BUFFERS parameter in init<SID>.ora file and restart my instance??

Regards
Hristo

[Updated on: Mon, 22 December 2008 01:52] by Moderator

Report message to a moderator

Re: ORA-00379 [message #377244 is a reply to message #377241] Mon, 22 December 2008 01:54 Go to previous messageGo to next message
Frank Naude
Messages: 4502
Registered: April 1998
Senior Member
Yes, you need to increase it. However, I trust you are using the newer DB_CACHE_SIZE parameter instead of the ancient DB_BLOCK_BUFFERS.

PS: For RAC it is probably wise to keep the cache sizes the same on all nodes.
Re: ORA-00379 [message #377247 is a reply to message #377241] Mon, 22 December 2008 02:16 Go to previous messageGo to next message
hristo
Messages: 258
Registered: May 2007
Senior Member
Hi!

Thanks for your reply, but as we are using sga_target should I not let Oracle handle this parameter?

Regards
Hristo
Re: ORA-00379 [message #377250 is a reply to message #377247] Mon, 22 December 2008 02:26 Go to previous message
Frank Naude
Messages: 4502
Registered: April 1998
Senior Member
Well, if you are using SGA_TARGET you cannot use DB_BLOCK_BUFFERS. If you try you will get an "ORA-00825: cannot set db_block_buffers if sga_target set".

SGA_TARGET and DB_CACHE_SIZE are however compatible. If you set both, DB_CACHE_SIZE will be seen as a minimum value for the buffer.

So, if you want, you can simply increase your SGA_TARGET.
Previous Topic: Alert log file
Next Topic: Limit resource creation
Goto Forum:
  


Current Time: Wed Dec 07 14:37:21 CST 2016

Total time taken to generate the page: 0.11084 seconds