View the Exhibit and examine the content of the V$PGA_TARGET_ADVICE_HISTOGRAM view.
What would you infer from this?
A.
If the PGA size is set to 4 MB, then all the work areas would execute in optimal mode.
B.
If the PGA size is doubled, then all the work areas that are less than 2 MB would execute in optimal mode.
C.
If the PGA size is set to 32 MB, then the number of work areas would reduce. So it is the appropriate size for PGA.
D.
If the size of the Program Global Area (PGA) is set to more than 64 MB, then all the work areas would execute in optimal mode. So it is the appropriate size for PGA.