Oracle Exam 1Z0-064 Topic 1 Question 26 Discussion

Actual exam question for Oracle's 1Z0-064 exam

Question #: 26
Topic #: 1

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.)

AConfigure the Server Result Cache.

BConfigure shared server mode.

CIdentify 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.

DUse DBMS_SHARED_POOL.KEEP to keep the SYS.STANDARD, SYS.DBMS_STANDARD, and SYS.DIUTIL packages and frequently executed compiled triggers.

EUse more anonymous procedures.

FStandardize the type, size, and naming conventions for bind variables and spacing conventions for SQL statements and PL/SQL blocks.

Show Suggested Answer

Suggested Answer: A, B, D

by Joseph at May 09, 2022, 04:12 AM

Limited Time Offer

25%

Off

Get Premium 1Z0-064 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!