The objective of setting a PGA max size is to inhibit run-away operations.
Correct Answer:
Verified
Q6: Much of proactive activity is related to
Q7: SGA manages memory operations on a database
Q8: An increase in shared pool size may
Q9: In most database engines,the execution of a
Q10: Few database engines function by making changes
Q12: Proactive maintenance is all about forecasting and
Q13: The PGA is controlled by the PGA_AGGREGATE_TARGET
Q14: The advice performance tools (Advice Central section
Q15: Write consistency implies that if one user
Q16: Read consistency is very important to a
Unlock this Answer For Free Now!
View this answer and more for free by performing one of the following actions
Scan the QR code to install the App and get 2 free unlocks
Unlock quizzes for free by uploading documents