137.Your database instance is currently configured to support 1,500 connections. The Web application
来源:互联网 发布:济宁知豆电动汽车电话 编辑:程序博客网 时间:2024/05/20 16:37
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
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
0 0
- 137.Your database instance is currently configured to support 1,500 connections. The Web application
- 70.You configured the Flash Recovery Area (FRA) for your database. The database instance is running
- 29.Your database instance is configured with automatic undo management and the UNDO_RETENTION
- 43.In your database instance, the STATISTICS_LEVEL initialization parameter is set to BASIC. What is
- 71.You configured the Flash Recovery Area for your database. The database instance has been started
- 75.Your test database is configured to run in NOARCHIVELOG mode. One of the data files in the USERS
- 138 Your database instance is running. You are not able to access Oracle Enterprise Manager Database
- Your database instance is running with full workload after database creation. You have decided to us
- 32.Your database instance is running with full workload after database creation. You have decided to
- 5.The database instance is currently using SPFILE. View the Exhibit and examine the error that you
- This application is currently offline. To enable the application, remove the app_offline.htm
- VS运行出现This application is currently offline. To enable the application, remove the app_offline.
- This application is currently offline. To enable the application, remove the app_offline.htm file fr
- This application is currently offline. To enable the application, remove the app_offline.htm file fr
- 28.View the Exhibit and examine the undo tablespace attributes. Your database instance is experien
- 47.Your database instance is functional for the past one month. The Automatic Workload Repository (A
- 138.Your database is configured in shared server mode. However, your senior DBA asks you to modify t
- VS运行网页应用时出现This application is currently offline. To enable the application...
- 如何选择深度学习框架 TensorFlow/Torch/Mxnet/Theano
- 九度oj--1002和1045
- 【单片机执行指令的过程】
- 开始使用Log4j
- 软件 易用性理解
- 137.Your database instance is currently configured to support 1,500 connections. The Web application
- TextView自定义
- jQuery添加/筛选/检测(3)
- C++string类常用函数 c++中的string常用函数用法总结
- PHP接口开发
- github优秀开源项目大全-iOS
- fork和pause等系统调用的实现原理(Linux0.11内核)
- Android武器库
- Spring使用之:Quartz定时任务为什么会被阻塞