Parallel DML failing with ORA-12801 and ORA-00379
(Doc ID 3028813.1)
Last updated on JUNE 29, 2024
Applies to:
Oracle Database - Enterprise Edition - Version 12.1.0.2 and laterInformation in this document applies to any platform.
Symptoms
Parallel DML is failing with below error.
INSERT /*+ APPEND PARALLEL(32)*/ INTO <table name>
Caused By: java.sql.SQLRecoverableException: ORA-00603: ORACLE server session terminated by fatal error
ORA-00379: no free buffers available in buffer pool DEFAULT for block size 32K
ORA-12801: error signaled in parallel query server P045, instance <INSTANCE NAME>
ORA-00379: no free buffers available in buffer pool DEFAULT for block size 32K
Error Codes
---------------------------------------------------
ORA-00379: no free buffers available in buffer pool DEFAULT for block size 32K
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Cause |
| Solution |
| References |