Your database instance is currently configured to support 1,500 connections. The Web application
that uses the database allows a large number of users to work with the database simultaneously.
Some users of the Web application do not interact with the server all the time. You want to
increase the scalability by configuring the database instance to handle more connections. As a
DBA, which configuration would you set to support more than 1,500 connections at a time?
A.
You would configure more listeners for the database.
B.
You would configure the database in shared server mode to use the connection pooling feature.
C.
You would increase the value of the PGA_AGGREGATE_TARGET initialization parameter that
assigns more session memory to users.
D.
You would decrease the value of the PRIVATE_SGA resource limit in the profiles used by the
users to accommodate more session information.