I tidligere versioner af Oracle betød en ORA-379, typisk at DB_BLOCK_BUFFERS var sat for lavt. Anbefalingerne var at DB__BLOCK_BUFFERS var >= 4*PROCESSES.
ORA-00379:
|
no free buffers available in buffer pool string for block size stringK
|
Cause:
|
All buffers in the specified buffer pool for the specified block size are in use and no free buffers are available.
|
Action:
|
Increase the number of buffers in the specified pool for the specified block size
|
Vi stødte dog på den samme fejl forleden, på en 10.2.0.2 database. Fejlen ORA-379 no free buffers available in buffer pool %s for block size %sK er den samme, men denne gang kan det være Oracle Bug 4637008.
Description
It is possible for the buffer cache to get into a state where it has very few buffers available leading to frequent
ORA-379 errors.
Workaround:
The instance has to be bounced to clear this condition.
Set "_in_memory_undo" = false to prevent the problem occuring in the first place.
Berørte versioner: 10.1.0.4, 10.1.0.5, 10.2.0.2
Fejlen er "fixed" i 10.2.0.3 (Server Patch Set) og 11.1.0.6 (Base Release)