View the Exhibit to observe the error. You receive this error regularly and have to shutdown the database instance to overcome the error. AutomaticShared Memory Management is configured for the…

The correct answer is B. Enable automatic memory management. ORA-04031: unable to allocate string bytes of shared memory ("string","string","string","string") Cause: More shared memory is needed than was allocated in the shared pool or Streams pool. Action: If the shared pool is out of memory, either use the DBMS_SHARED_POOL package to…

Performance Management

Question

View the Exhibit to observe the error. You receive this error regularly and have to shutdown the database instance to overcome the error. AutomaticShared Memory Management is configured for the instance. What can you do to reduce the chance of this error in the future?

Exhibit

Options

AIncrease the value of SGA_MAX_SIZE
BEnable automatic memory management
CSet the PRE_PAGE_SGA parameter to true
DLock the System Global Area (SGA) in memory

How the community answered

(53 responses)

A
4% (2)
B
70% (37)
C
17% (9)
D
9% (5)

Explanation

ORA-04031: unable to allocate string bytes of shared memory ("string","string","string","string") Cause: More shared memory is needed than was allocated in the shared pool or Streams pool. Action: If the shared pool is out of memory, either use the DBMS_SHARED_POOL package to pin largepackages, reduce your use of shared memory, or increase the amount of available shared memory byincreasing the value of the initialization parametersSHARED_POOL_RESERVED_SIZE andSHARED_POOL_SIZE. If the large pool is out of memory, increase the initialization parameterLARGE_POOL_SIZE. If the error is issued from an Oracle Streams or XStream process, increase theinitialization parameter STREAMS_POOL_SIZE or increase the capture or apply parameter MAX_SGA_SIZE.

Topics

#Automatic Memory Management#SGA_TARGET#MEMORY_TARGET#STATISTICS_LEVEL

Community Discussion

No community discussion yet for this question.

Full 1Z0-034 Practice