Oracle
1Z0-054 · Question #84
You queried V$SYSTEM_EVENT in your online transaction processing (OLTP) environment to check the following wait events: Average Event Total Seconds Total Wait Name Waits Waiting Timeouts (in secs)…
The correct answer is C. Increase the size of the Program Global Area (PGA). See the full explanation below for the reasoning.
Question
You queried V$SYSTEM_EVENT in your online transaction processing (OLTP) environment to check the following wait events:
Average Event Total Seconds Total Wait Name Waits Waiting Timeouts (in secs) ------------------------------ ------------ -------- ------------ ----- ---- direct path read temp 18,274 11,312 16,282 .619 direct path write temp 3,251 416 25 .127 Which step would be appropriate to improve the performance?
Options
- AIncrease the number of I/O slaves.
- BIncrease the size of the Database Buffer Cache.
- CIncrease the size of the Program Global Area (PGA).
- DIncrease the number of database writer (DBWn) processes.
How the community answered
(47 responses)- A9% (4)
- B4% (2)
- C74% (35)
- D13% (6)
Community Discussion
No community discussion yet for this question.