Which action would you suggest after analyzing the output?

View Exhibit1 and examine a portion of Active Session History(ASH) report.
View Exhibit2 to examine the tablespaces.
Which action would you suggest after analyzing the output?
Exhibit 1 (exhibit):
Exhibit 2 (exhibit):

View Exhibit1 and examine a portion of Active Session History(ASH) report.

View Exhibit2 to examine the tablespaces.

Which action would you suggest after analyzing the output?

A.
Increase the log buffer size.

B.
Rebuild indexes on SPCT table.

C.
Decreasing the number of free lists in segment SPCT.

D.
Move SPCT table to a different tablespace that is locally managed with automatic segment space management.



Leave a Reply 1

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


max

max

D makes sense because locally managed tbs can cause heavy busy waits = ASSM