What happens when you execute these SQL statements?
ALTER SYSTEM SET SGA_TARGET = 992M;
ALTER SYSTEM SET SHARED_POOL_SIZE = 0;
ALTER SYSTEM SET LARGE_POOL_SIZE = 0;
ALTER SYSTEM SET JAVA_POOL_SIZE = 0;
ALTER SYSTEM SET DB_CACHE_SIZE = 0;
ALTER SYSTEM SET STREAMS POOL SIZE = 0;
A.
The database stops (shutdown abort).
B.
B) The database Stops (shutdown immediate).
C.
You activate Automatic Shared Memory Management.
D.
You get an error message.
Explanation:
http://www.orafaq.com/forum/t/67825/0/ (see the second post)
c