Oracle
1Z0-054 · Question #91
You work in an online transaction processing (OLTP) environment and users are experiencing slow response time on their queries. These users connect as FINANCE to run their application and run…
The correct answer is C. Create and assign temporary tablespace group to this user ID. See the full explanation below for the reasoning.
Question
You work in an online transaction processing (OLTP) environment and users are experiencing slow response time on their queries. These users connect as FINANCE to run their application and run hundreds of sessions. Your investigation shows that there is lot of I/O contention happening on only one temporary tablespace and there is no load on other temporary tablespaces. View the Exhibit and examine the details. After some time you observed that the sort operations are running out of temporary space. What would be a long-term solution?
Options
- AConfigure the large pool if it is not done already.
- BChange the temporary tablespace assigned to this user ID.
- CCreate and assign temporary tablespace group to this user ID.
- DIncrease the number of database writer (DBWn) processes ID.
- EMake the bigger temporary tablespace the default temporary tablespace ID.
How the community answered
(28 responses)- B4% (1)
- C82% (23)
- D4% (1)
- E11% (3)
Community Discussion
No community discussion yet for this question.