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
table space 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?

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
table space 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.



Leave a Reply 2

Your email address will not be published. Required fields are marked *


L. Zhu

L. Zhu

when one temp tablespace is having contention, you can use temp tablespace group

C is right

Michael

Michael

B is correct, as in that answer a temporary tablespace group is used.