Oracle
1Z0-064 · Question #29
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.)
The correct answer is B. Configure shared server mode. C. Identify the packages or procedures that are causing the "ORA-04031: unable to allocate .... D. Use DBMS_SHARED_POOL.KEEP to keep the SYS.STANDARD, SYS.DBMS_STANDARD, and. See the full explanation below for the reasoning.
Question
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.)
Options
- AConfigure the Server Result Cache.
- BConfigure shared server mode.
- CIdentify the packages or procedures that are causing the "ORA-04031: unable to allocate ....
- DUse DBMS_SHARED_POOL.KEEP to keep the SYS.STANDARD, SYS.DBMS_STANDARD, and
- EUse more anonymous procedures.
- FStandardize the type, size, and naming conventions for bind variables and spacing conventions
How the community answered
(63 responses)- A10% (6)
- B81% (51)
- E3% (2)
- F6% (4)
Community Discussion
No community discussion yet for this question.