ORA-04031 : unable to allocate num bytes

Question

690 views10/04/2023Oracle Database

0

Amen1.09K 07/04/2023 0 Comments

What is the cause and solution for Oracle error ORA-04031 : unable to allocate num bytes of shared memory?

Ezana Answered question 10/04/2023

Write your answer.

score 0 · Answer 1 · 2023-04-10T10:00:14+00:00

Cause:

More usage of shared memory than available.

Solution:

Reduce the use of shared memory available.
Increase the SHARED_POOL_SIZE parameter.