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.)

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 2

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


L. Zhu

L. Zhu

A is right. the hitratio is only 60% too low. increasing the size of share pool
B is wrong. EXACT will not be able to share plan
C is wrong.
D is wrong.
E is right. it has 79 sql statement with the same plan hash value.

So A.E. are correct

ash

ash

For A -the get hit ratio should be as high as 90% in OLTP systems