You have a Linux machine with an Oracle database instance running in it. The database users
log on and log off from the database instance frequently. The page size for the system is 4 KB
and the SGA size is 100 MB. To reduce the page fault, you set the PRE_PAGE_SGA parameter
to TRUE for the database instance. After some time you observed that the process startup
duration has increased significantly. What could be the reason for this?
A.
The SGA has been locked into physical memory.
B.
Each server process that starts must access every page in SGA.
C.
The session memory for the new connections is allocated from SGA.
D.
The SGA size is adjusted by the Automatic Shared Memory Management feature during every
new connection.