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 sort operations are running out of temporary space.
What would be a long-term solution?
A.
Change the temporary tablespace assigned to this user ID.
B.
Create and assign temporary tablespace group to this user ID.
C.
Increase the size of the temporary tablespace assigned to this user ID.
D.
Make the bigger temporary tablespace the default temporary tablespace ID.