Which two statements are true about these parameters after the database instance is restarted?

You set the following parameters in the parameter file and restarted the database:
MEMORY_MAX_TARGET=0
MEMORY_TARGET=500M
PGA_AGGREGATE_TARGET=90M
SGA_TARGET=270M
Which two statements are true about these parameters after the database instance is restarted? (Choose two.)

You set the following parameters in the parameter file and restarted the database:
MEMORY_MAX_TARGET=0
MEMORY_TARGET=500M
PGA_AGGREGATE_TARGET=90M
SGA_TARGET=270M
Which two statements are true about these parameters after the database instance is restarted? (Choose two.)

A.
The PGA_AGGREGATE_TARGET and SGA_TARGET parameters are automatically set to zero

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

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

D.
The MEMORY_MAX_TARGET parameter is automatically set to 500 MB



Leave a Reply 3

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


diana

diana

Why option D ?

seenagape

seenagape

I have the same idea. BD

AAC

AAC

SQL> alter system set MEMORY_MAX_TARGET=0 scope = spfile;
System altered.
SQL> alter system set MEMORY_TARGET=500M scope = spfile;
System altered.
SQL> alter system set PGA_AGGREGATE_TARGET=90M scope = spfile;
System altered.
SQL> alter system set SGA_TARGET=270M scope = spfile;
System altered.
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORA-00837: Specified value of MEMORY_TARGET greater than MEMORY_MAX_TARGET