Which two are appropriate solutions to improve performance?

You are working on an online transaction processing (OLTP) system. You are investigating the reasons for performance degradation in the database. View the Exhibit named TOP5EVENTS and note the top five events.
View the Exhibit named TOPSQL and note the problems related to these statements.
View the Exhibit named INSTACT and note the table scans.
Which two are appropriate solutions to improve performance? (Choose two.)
Exhibit 1 (exhibit):
Exhibit 2 (exhibit):
Exhibit 3 (exhibit):

You are working on an online transaction processing (OLTP) system. You are investigating the reasons for performance degradation in the database. View the Exhibit named TOP5EVENTS and note the top five events.

View the Exhibit named TOPSQL and note the problems related to these statements.

View the Exhibit named INSTACT and note the table scans.

Which two are appropriate solutions to improve performance? (Choose two.)

A.
Enable the large pool.

B.
Keep the long tables in the keep buffer pool.

C.
Keep the short tables in the keep buffer pool.

D.
Set the CACHE property on the table for the long tables.

E.
Set the CACHE property on the table for the short tables.



Leave a Reply 0

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