Database Administration (MOSC)

MOSC Banner

using V$SHARED_POOL_ADVICE to avoid ORA-04031

edited Jun 19, 2024 5:40AM in Database Administration (MOSC) 16 commentsAnswered ✓

Hi,

On Oracle 19c on AIX

in alertlog we have:

ORA-04031: unable to allocate bytes of shared memory ……("shared pool","UPDATE

Can we use V$SHARED_POOL_ADVICE to find good size for shared pool and avoid ORA-04031 ?

How?

Thank you.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center