137.Your database instance is currently configured to support 1,500 connections. The Web application

137.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.
答案：B
解析：这道题的意思就是数据库配置了1500个会话连接，但是现在web允许大量的用户同时登录，并且他们由一个特点是
很多登录的用户不做任何操作，该怎么设置
A.错误，配置再多的监听也对会话也没有作用
B.正确
C.错误，这里只是增大了用户的pga，与会话个数没关系
D.错误，这个是限制用户内存占用的


专用服务器，客户端与服务器端进程是一对一
共享服务器，客户端与服务器端进程是多对一，并且可以通过调度器来管理


SQL> show parameter share
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
hi_shared_memory_address             integer     0
max_shared_servers                   integer    --这里是没有限制的
shared_memory_address                integer     0
shared_pool_reserved_size            big integer 6081740
shared_pool_size                     big integer 0
shared_server_sessions               integer
shared_servers                       integer     1