View the Exhibit and examine the content of the V$PGA_TARGET_ADVICE_HISTOGRAM view. What would you infer from this?

Question

Exhibit

Options

• AIf the PGA size is set to 4 MB, then all the work areas would execute in optimal mode.
• BIf the PGA size is doubled, then all the work areas that are less than 2 MB would execute in
• CIf the PGA size is set to 32 MB, then the number of work areas would reduce. So it is the
• DIf the size of the Program Global Area (PGA) is set to more than 64 MB, then all the work areas

• A
  3% (1)
• B
  83% (33)
• C
  10% (4)
• D
  5% (2)

No community discussion yet for this question.