What would you infer from this?

View the Exhibit and examine the content of the V$PGA_TARGET_ADVICE_HISTOGRAM view.

What would you infer from this?

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.



Leave a Reply 1

Your email address will not be published. Required fields are marked *


L. Zhu

L. Zhu

pga_target_factor=2, so it is doubled.

B is the right answer