What do you infer?

The users in your online transaction processing (OLTP) environment complain that the response
time of the application has increased dramatically.To investigate the problem, view the Exhibit and
examine the queries you executed.

What do you infer?

The users in your online transaction processing (OLTP) environment complain that the response
time of the application has increased dramatically.To investigate the problem, view the Exhibit and
examine the queries you executed.

What do you infer?

A.
Cursor sharing is not enabled.

B.
The large pool is not configured.

C.
The temporary tablespace is full.

D.
The value set for the SHARED_POOL_SIZE initialization parameter is too small.

E.
The value set for the PGA_AGGREGATE_TARGET initialization parameter is too small.



Leave a Reply 1

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


L. Zhu

L. Zhu

PGA hit ratio is too low. increase PGA

So E is right