Which two actions can improve performance?

You work as a DBA for a company and manage an online transaction processing (OLTP) system. You received complaints about the performance degradation of SQL statements executed by the application that uses this database.View the Exhibit and examine the output of the queries executed to investigate the performance issues.
Which two actions can improve performance? (Choose two.)
Exhibit:

You work as a DBA for a company and manage an online transaction processing (OLTP) system. You received complaints about the performance degradation of SQL statements executed by the application that uses this database.View the Exhibit and examine the output of the queries executed to investigate the performance issues.

Which two actions can improve performance? (Choose two.)

A.
increasing the size of the shared pool

B.
setting the CURSOR_SHARING parameter to EXACT

C.
decreasing the value set for the OPEN_CURSORS parameter

D.
replacing literals with bind variables in SQL statements with the PLAN_HASH_VALUE 1337874392

E.
replacing literals with bind variables in SQL statements with the PLAN_HASH_VALUE 1445457117



Leave a Reply 0

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