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)