New Features for Administrators - Question 064

Which command can you use to alter the active size of the SGA dynamically, where the entered value differs from the current one?

A. ALTER SYSTEM SET SGA_MAX_SIZE=500M ;

B. ALTER SYSTEM DROP DB_2K_CACHE_SIZE ;

C. ALTER SYSTEM SET DB_CACHE_SIZE=AUTO ;

D. ALTER SYSTEM SET SHARED_POOL_SIZE=40M;

Answer: D

Explanation:

This command can be used to alter the active size of the SGA dynamically.

Incorrect Answers

A: This command is incorrect, because the SGA_MAX_SIZE cannot be changed dynamically. And question was about SGA size dynamic change, not SGA_MAX_SIZE.

B: This command is incorrect. You cannot drop the DB_CACHE_SIZE parameter.

C: This command is incorrect. You cannot set the DB_CACHE_SIZE parameter as AUTO.

OCP Oracle9i Database: New Features for Administrators, Daniel Benjamin, p. 180-182

Chapter 3: Manageability Enhancements

Oracle 9i New Features, Robert Freeman, p. 16-17

Chapter 1: Oracle9i Database Administration and Management Features