Oracle
1Z0-064 · Question #8
Examine an extract from a PGA Memory Advisory for your database: Which two inferences are correct? (Choose two.)
The correct answer is B. The current PGA size requires the use of a temporary tablespace for sorting operations. D. PGA size should be increased at least four times its current size for significant improvement in. See the full explanation below for the reasoning.
Question
Examine an extract from a PGA Memory Advisory for your database:
Which two inferences are correct? (Choose two.)
Exhibit
Options
- AAutomatic management of PGA memory is disabled.
- BThe current PGA size requires the use of a temporary tablespace for sorting operations.
- CThe current PGA size is sufficient and does not require the memory manager to allocate more
- DPGA size should be increased at least four times its current size for significant improvement in
How the community answered
(41 responses)- A12% (5)
- B80% (33)
- C7% (3)
Community Discussion
No community discussion yet for this question.