Consider an application in which memory required for each session is 400 KB and memory
required for each server process is 4 MB. The pool size is 100 and the number of shared servers
used is 100. If there are 5000 client connections, what is the amount of memory used by a
dedicated server?
A.
615 MB
B.
2.5 GB
C.
4 GB
D.
12 GB
E.
22 GB
E
http://docs.oracle.com/cd/E11882_01/server.112/e25494/manproc.htm#ADMIN12483
Agree. It’s E
Answer :E
Explanation :
Example of Memory Usage for Dedicated Server, Shared Server, and Database Resident Connection Pooling
Memory required for each session is 400 KB
Memory required for each server process is 4 MB
The pool size is 100
Number of shared servers used is 100.
If there are 5000 client connections, the memory used by each configuration is as follows:
• Dedicated Server
Memory used = 5000 X (400 KB + 4 MB) = 22 GB
• Shared Server
Memory used = 5000 X 400 KB + 100 X 4 MB = 2.5 GB
Out of the 2.5 GB, 2 GB is allocated from the SGA.
• Database Resident Connection Pooling
Memory used = 100 X (400 KB + 4 MB) + (5000 X 35KB) = 615 MB
The cost of each connection to the broker is approximately 35 KB.
E
https://docs.oracle.com/database/121/ADMIN/manproc.htm#ADMIN12348