using V$SHARED_POOL_ADVICE to avoid ORA-04031
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.
0