Which three actions should you perform to reduce shared pool fragmentation and avoid the “ORA-04031:
unable to allocate …. bytes of shared memory” error for the shared pool? (Choose three.)
A.
Configure the Server Result Cache.
B.
Configure shared server mode.
C.
Identify the packages or procedures that are causing the “ORA-04031: unable to allocate ….
bytes of shared memory” error and use the DBMS_SHARED_POOL.KEEP to keep them in the shared
pool.
D.
Use DBMS_SHARED_POOL.KEEP to keep the SYS.STANDARD, SYS.DBMS_STANDARD, and SYS.DIUTIL
packages and frequently executed compiled triggers.
E.
Use more anonymous procedures.
F.
Standardize the type, size, and naming conventions for bind variables and spacing conventions for SQL
statements and PL/SQL blocks.