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?
Exhibit:

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 0

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