Choose all the correct options

Question

you set the following parameters in the parameter file and restarted the database:memory_max_target=0 memory_target=500m pga_aggregate_target=90msga_target=270mwhich two statements are true regarding these parameters after the database instance is restarted? (choose two.)

Accepted Answer

The MEMORY_MAX_TARGET parameter is automatically set to 500 MB.

Accepted Answer

The lower bounds of PGA_AGGREGATE_TARGET and SGA_TARGET parameters are set to 90 MB and 270 MB, respectively.

Answer

The value of the MEMORY_MAX_TARGET parameter remains zero till it is changed manually.

Answer

The PGA_AGGREGATE_TARGET and SGA_TARGET parameters are automatically set to zero.

You set the following parameters in the parameter file and restarted the database:

0 Discussions

Trending Exams