PrepAway - Latest Free Exam Questions & Answers

Which three statements will cause the memory tuner to actively tune memory within the database?

The SELF_TUNING_MEM database configuration (db cfg) parameter is set to
ON. Which three statements will cause the memory tuner to actively tune memory within the
database? (Choose three.)

PrepAway - Latest Free Exam Questions & Answers

A.
One db cfg parameter is set to AUTOMATIC or the size of at least one buffer pool is set to
AUTOMATIC, and the DAT ABAS E_M E M O R Y db cfg parameter is set to a numeric value or to
AUTOMATIC

B.
Any two of LOCKLIST, SHEAPTHRES_SHR, PCKCACHESZ are set to AUTOMATIC

C.
The SORTHEAP db cfg parameter is set to AUTOMATIC

D.
At least one buffer pool has its size set to AUTOMATIC

E.
MAXLOCKS is set to AUTOMATIC


Leave a Reply