Oracle
1Z0-054 · Question #91
1Z0-054 Question #91: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-054 to reveal the answer and full explanation for question #91. The question stem and answer options stay visible for context.
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.
Unlock 1Z0-054 to see the answer
You've previewed enough free 1Z0-054 questions. Unlock 1Z0-054 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.