What would be the correct decision?

The users in your online transaction processing (OLTP) environment complain that the query
response time has increased considerably. You checked the Program Global Area (PGA)- related
information in the AWR report to investigate it further.
View the Exhibit named PGAHIT and note the PGA cache-hit percentage.

View the Exhibit named PGAADV and analyze the content.

If you want to increase the size of PGA, you have sufficient memory available in the system. What
would be the correct decision?

The users in your online transaction processing (OLTP) environment complain that the query
response time has increased considerably. You checked the Program Global Area (PGA)- related
information in the AWR report to investigate it further.
View the Exhibit named PGAHIT and note the PGA cache-hit percentage.

View the Exhibit named PGAADV and analyze the content.

If you want to increase the size of PGA, you have sufficient memory available in the system. What
would be the correct decision?

A.
Double the size of PGA.

B.
Increase the size of PGA to 120 MB.

C.
Increase the size of PGA to 160 MB or more.

D.
Leave the PGA at its current size and investigate other possible causes.



Leave a Reply 1

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


L. Zhu

L. Zhu

when it is more than 160MB, it is getting better
So C is right.