| ORA-00379 [message #377241] |
Mon, 22 December 2008 01:44  |
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  |
Frank Naude
Messages: 4580
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 |
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 |
Frank Naude
Messages: 4580
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
