What would you do to increase the memory available for the SQL work areas?

Your database is running on the automatic Program Global Area (PGA) memory management and Shared Memory Management mode. You want to increase the memory available for the SQL work areas.
What would you do?

Your database is running on the automatic Program Global Area (PGA) memory management and Shared Memory Management mode. You want to increase the memory available for the SQL work areas.
What would you do?

A.
modify the HASH_AREA_SIZE initialization parameter

B.
modify the PGA_AGGREGATE_TARGET initialization parameter

C.
modify the WORK_AREASIZE_POLICY initialization parameter

D.
increase the value of the SGA_TARGET initialization parameter

E.
increase the value of the SGA_MAX_SIZE initialization parameter

F.
increase the value of the SORT_AREA_SIZE initialization parameter



Leave a Reply 0

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