052-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.

在专用服务器模式下,进程和会话是一对一的关系,UGA 被包含在 PGA 中,
在共享服务器模式下,进程和会话是一对多的关系,UGA 在大池(Large Pool)中分配。
如果分配失败,如大型池太小,或是根本没有设置大型池,则从共享池(Shared Pool)中分配


posted @ 2017-12-13 15:28  巴啦啦大魔王  阅读(139)  评论(0编辑  收藏  举报