What would be a long-term solution?

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?

A.
Configure the large pool if it is not done already.

B.
Change the temporary tablespace assigned to this user ID.

C.
Create and assign temporary tablespace group to this user ID.

D.
Increase the number of database writer (DBWn) processes ID.

E.
Make the bigger temporary tablespace the default temporary tablespace ID.