专栏首页小麦苗的DB宝专栏【OCP最新题库解析(052)--题29】 For which requirement should you config

【OCP最新题库解析(052)--题29】 For which requirement should you config

Q

题目

For which requirement should you configure shared servers?

A. accommodating an increasing number of users who run short-duration, infrequent queries in an OLTP environment with limited memory.

B. using Recovery Manager(RMAN) to recover a database.

C. submitting backup jobs at regular, 24-hour intervals in an OLTP environment with limited memory.

D. accommodating an increasing number of users who run analytical queries in a DSS environment with limited memory.

E. performing bulk-load operations in a DSS environment with limited memory.

A

答案

Answer:A

使用连接共享功能,数据库服务器可以使空闲会话超时,从而使用其连接为活动会话提供服务。空闲会话逻辑上仍处于打开状态,当该会话下次发出请求时会自动重新建立物理连接。因此,Web应用程序可使用现有硬件来满足大量并发用户的需求。连接共享是通过共享服务器进行配置的。

Oracle共享服务器体系结构是一个有效的进程和内存使用模型,但是并不适用于所有的连接。由于存在公共请求队列,并且大量用户会共享分派程序响应队列,所以当存在必须处理大批数据的操作时共享服务器的性能并不是很好,如处理仓库查询或执行批处理时。使用Oracle Recovery Manager进行备份和恢复会话时,也会处理大量的数据集,因此也必须使用专用连接。

许多管理任务不能(无法)使用共享服务器连接执行,其中包括启动和关闭实例、创建表空间和数据文件、维护索引和表、分析统计信息,以及通常由DBA执行的其它多个任务。

所有DBA会话都必须选择专用服务器。

Using shared servers reduces the number of processes and the amount of memory consumed on the database host. Shared servers are beneficial for databases where there are many OLTP users performing intermittent transactions.

Using shared servers rather than dedicated servers is also generally better for systems that have a high connection rate to the database. With shared servers, when a connect request is received, a dispatcher is available to handle concurrent connection requests. With dedicated servers, however, a connection-specific dedicated server is sequentially initialized for each connection request.

Performance of certain database features can improve when a shared server architecture is used, and performance of certain database features can degrade slightly when a shared server architecture is used. For example, a session can be prevented from migrating to another shared server while parallel execution is active.

A session can remain nonmigratable even after a request from the client has been processed, because not all the user information has been stored in the UGA. If a server were to process the request from the client, then the part of the user state that was not stored in the UGA would be inaccessible. To avoid this situation, individual shared servers often need to remain bound to a user session.

本文分享自微信公众号 - DB宝(xiaomaimiaolhr),作者:小麦苗best

原文出处及转载信息见文内详细说明,如有侵权,请联系 yunjia_community@tencent.com 删除。

原始发表时间:2018-07-02

本文参与腾讯云自媒体分享计划,欢迎正在阅读的你也加入,一起分享。

我来说两句

0 条评论
登录 后参与评论

相关文章

  • 【OCP最新题库解析(052)--题27】Your database is configured in archivelog

    Which clause or clauses ensure that no media recovery is required when the table...

    小麦苗DBA宝典
  • 【OCP最新题库解析(052)--题22】Which three of these must be accessible

    小麦苗DBA宝典
  • 【静默】Oracle各类响应文件何在?

    1、创建数据库的响应文件:$ORACLE_HOME/assistants/dbca/dbca.rsp

    小麦苗DBA宝典
  • SQL,PL/SQL 数据类型一览表

    The following is a list of datatypes available in Oracle.

    Leshami
  • malloc.c

    glibc-2.14中的malloc.c源代码,供研究malloc和free实现使用:

    一见
  • 响铃:从小众到大众,智能微投还有多少路要走?

    专注智慧家庭领域数据监测的奥维云网发布数据称,2017年1-7月,投影仪线上卖了53万台,其中家用的43万台,含智能微投(1kg以下)19万台。相比手机动不动几...

    曾响铃
  • VB语言基础重要知识点19(for循环应用)

    在文本框中输入一个数字,点击输出按钮,在窗体上打印出五角星点阵的正方形。从中体会双重for循环的力量。

    刘金玉编程
  • 1-添加自己的Lua执行函数(ESP8266-SDK开发(lua版本))

    lua_pushnumber (L, 1); lua_pushnumber (L,3); lua_pushnumber (L,4); return ...

    杨奉武
  • github 入门教程之 github 访问速度太慢怎么办

    github 是全世界最流行的开源项目托管平台,其代表的开源文化从根本上改变了软件开发的方式.

    雪之梦技术驿站
  • 制作地图及常见问题

    地图在制作报表中很常见,主要功能是展示区域信息,如展示区域销售信息,用户区域分布情况等。本文介绍一下地图的制作步骤及常见的问题。

    腾讯云商业智能分析团队

扫码关注云+社区

领取腾讯云代金券