which of the following initialization parameters?

Automatic PGA Memory Management eliminates the need to manually configure which of
the following initialization parameters? (Choose all that apply.)

Automatic PGA Memory Management eliminates the need to manually configure which of
the following initialization parameters? (Choose all that apply.)

A.
SORT_AREA_SIZE

B.
HASH_AREA_SIZE

C.
BITMAP_MERGE_AREA_SIZE

D.
CREATE_BITMAP_AREA_SIZE

E.
PGA_AGGREGATE_TARGET

Show Hint

Leave a Reply 1

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

Jake from SF

Jake from SF

A,B,C,D are correct:

https://docs.oracle.com/cd/E11882_01/server.112/e25494/memory.htm#ADMIN11234

Oracle Database supports manual PGA memory management, in which you manually tune SQL work areas.

In releases earlier than Oracle Database 10g, the database administrator controlled the maximum size of SQL work areas by setting the following parameters: SORT_AREA_SIZE, HASH_AREA_SIZE, BITMAP_MERGE_AREA_SIZE and CREATE_BITMAP_AREA_SIZE. Setting these parameters is difficult, because the maximum work area size is ideally selected from the data input size and the total number of work areas active in the system.

Reply