ORA-04031 With Large "db_block_buffers_headers" And "db_block_hash_buckets" Allocations
(Doc ID 1476045.1)
Last updated on FEBRUARY 23, 2019
Applies to:
Oracle Database - Enterprise Edition - Version 9.2.0.1 and laterOracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Information in this document applies to any platform.
Goal
ORA-04031 errors are being reported under the following conditions:
- DB_CACHE_SIZE is not set
- Instead DB_BLOCK_BUFFERS is set, because USE_INDIRECT_DATA_BUFFERS is set to TRUE.
Typically, these settings are used on 32-bit platforms to enable system memory usage (RAM) above the 4GB boundary (32-bit limitation). - In the shared pool, memory allocations of type "db_block_buffers_headers" are either very large or the largest memory allocations.
- Memory allocations of type "db_block_hash_buckets" are also present in the shared pool.
- SHARED_POOL_SIZE has been increased as much as possible.
How to stop the ORA-4031 errors from occurring?
Solution
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
| Goal |
| Solution |
| References |