OCP-1Z0-052-V8.02-51题

最新推荐文章于 2026-02-01 13:18:42 发布
原创 最新推荐文章于 2026-02-01 13:18:42 发布 · 1w 阅读 · 0 ·
本内容遵循CC 4.0 BY-SA版权协议
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
收录于
OCP11g解析

当前文章被收录于：

OCP11g解析
870 篇文章 151 人学习

OCP11g，051,052,053每题的解析

订阅专栏 查看详情
OCP-1Z0-052

当前文章被收录于：

OCP-1Z0-052
198 篇文章 2 人学习
订阅专栏 查看详情
本文探讨了在自动共享内存管理(ASMM)环境下如何针对白天的OLTP作业与夜间的批处理作业自动调整数据库缓冲区高速缓存及大型池的内存分配策略，确保系统在不同负载下都能达到最佳性能。

51. In a system, large online transaction processing (OLTP) jobs run during the daytime that require a

large database buffer cache. In the night, the system supports batch jobs that require a higher value to be

set for the large pool. You must simultaneously configure the memory components to accommodate the

peak requirement.

What would you do to automate this configuration for the memory components with change in mode of

working? 

A.Set the SGA_TARGET initialization parameter to zero.

B.Set the PRE_PAGE_SGA initialization parameter to TRUE. 

C.Set the MEMORY_MAX_TARGET initialization parameter to zero.

D.Set the SGA_TARGET initialization parameter to a nonzero value.

Answer: D  

答案解析：

参考：http://blog.csdn.net/rlhua/article/details/12493791

 

对于白天运行大型联机事务处理(OLTP)  作业（要求大型缓冲区高速缓存）和夜晚运行并行批处理作业（要求大型池的内存空间比较大）的系统，就必须同时配置缓冲区高速缓存和大型池，以便适应峰值需求。
有了ASMM 功能，当 OLTP  作业运行时，缓冲区高速缓存会获取大部分内存来保证良好的I/O  性能。以后启动数据分析和报告批处理作业时，内存又会自动迁移到大型池，供并行查询操作使用，而不会产生内存溢出错误。
如果使用的是服务器参数文件(SPFILE) ，则Oracle DB 会在每次关闭实例时记住自动优化的组件的大小。因此，系统不需要在每次启动实例时都重新了解工作量的特性。它可以利用从以前的实例中获取的信息，从上次关闭时中断的位置开始继续评估工作量。
【SAP消息号KI280】
MRwugang的博客
05-07 2167
SAP消息号KI280 PS:相同的消息号可能会出现在不同的业务场景，条条大道通罗马，仅供学习交流参考！ SAP消息号KI280 1、业务场景： 内部订单入账F-02入账时报错：为2021.11.17 创建科目66020000作为控制范围 GW01中成本要素； 2、解决办法： FS00检查这个科目并不是成本要素导致的，FI到CO过账需要一个初级成本要素作为桥梁，FS00或KA01将其维护为初级成本要素； ...
51.In a system, large online transaction processing (OLTP) jobs run during the daytime that require
dwj19830118的专栏
07-22 1200
51.In a system, large online transaction processing (OLTP) jobs run during the daytime that require a large database buffer cache. In the night, the system supports batch jobs that require a higher value to be set for the large pool. You must simultaneousl
OCP-1Z0-053-V13.02-702题
一抹曦阳-Oracle
02-24 9493
702. View the Exhibit and examine the parameter settings in your server-side parameter file (SPFILE). When you tried to start the database instance, you received the following error:   Why di
OCP-1Z0-053-200题-139题-205
一抹曦阳-Oracle
02-08 4062
QUESTION 139 You specify a nonzero value for the MEMORY_TARGET initialization parameter, but do not set the PGA_AGGREGATE_TARGET or the SGA_TARGET parameters. You restart your database instance. Wh
OCP-1Z0-053-V12.02-666题
一抹曦阳-Oracle
10-08 6168
666.You are working in an online transaction processing (OLTP) environment. You use the FLASHBACKTABLE command to flash back the CUSTOMERS table. Before executing the FLASHBACK TABLE command, t
OCP-1Z0-052-V8 02-51题
sdfsdkk的博客
01-26 158
OCP-1Z0-052-V8 02-51题
OCP11g 参考图书 题库及错误答案释疑
weixin_34034261的博客
01-01 109
参考图书1、OCP11g官方教材by20131227（考试的前一天，官方邮件发过来的）http://pan.baidu.com/s/1sjPL5fv2、OCA认证考试指南IZ0-0473、OCA认证考试指南IZ0-051http://pan.baidu.com/s/1i3v9EN74、OCA认证考试指南IZ0-052http://pan...
C 语言学习笔记
最新发布
g_c_m_g的博客
02-01 1064
B站up Micro_Frank C语言大师系列课程笔记
ocp-v13-061
jiayue's BLOG
09-30 882
QUESTION 61 Which of the following advisors within the Oracle advisory framework will analyze a single SQL statement and make recommendations for performance improvement? A. SQL Repair Advisor B. S
OCP-1Z0-052-V8.02-52题
一抹曦阳-Oracle
10-15 8960
52. View the Exhibits and examine lock waits.   Users HR and SH complain that their transactions on one of the application tables, EMP, are waiting for response.  Which action would you take to
OCP-1Z0-053-V13.02-43题
热门推荐
一抹曦阳-Oracle
11-13 1万+
43.View the following SQL statements: Transaction T1 INSERT INTO hr.regions VALUES (5,'Pole');COMMIT; Transaction T2 UPDATE hr.regions SET region_name='Poles' WHERE region_id = 5; COMMIT; Transacti
Oracle10gOCP043题库91140题共185题
长亭路
04-16 1361
原 Oracle 10g OCP 043 题库 91-140题 共185题https://blog.csdn.net/tianlesoftware/article/details/5787412版权声明： https://blog.csdn.net/tianlesoftware/article/details/5787412 91. Consider the following comma...
OCP-1Z0-053-V12.02-188题
一抹曦阳-Oracle
10-27 4577
188.You can back up the RMAN recovery catalog with RMAN. A. True B. False Answer: A 答案解析： 参考：http://blog.csdn.net/rlhua/article/details/13169205 恢复目录是一个Oracle DB，因此与任何数据库一样，需要进行备份。Oracle 建议使
OCP-1Z0-052-V8.02-55题
一抹曦阳-Oracle
10-16 1万+
55. View the Exhibit to examine the output produced by the following query at three different times since the database instance started and has experienced workloads of different capacities: SQL> SE
OCP-1Z0-053-200题-90题-666
一抹曦阳-Oracle
02-10 3367
QUESTION 90 You are working in an online transaction processing (OLTP) environment. You use the FLASHBACK TABLE command to flash back the CUSTOMERS table. Before executing the FLASHBACK TABLE comman
OCP-1Z0-053-V12.02-205题
一抹曦阳-Oracle
10-09 5664
205.You specify a nonzero value for the MEMORY_TARGET initialization parameter, but do not set the PGA_AGGREGATE_TARGET or the SGA_TARGET parameters. You restart your database instance. Which s
OCP-1Z0-053-V12.02-310题
一抹曦阳-Oracle
10-27 5725
310.The RVPC user can do which of the following? (Choose all that apply.) A. Register databases if granted the register database privilege B. See all databases in the recovery-catalog schema C. See
OCP-1Z0-051-V9.02-103题
一抹曦阳-Oracle
10-19 9464
103. Examine the structure of the TRANSACTIONS table: name          Null          Type TRANS_ID      NOT NULL      NUMBER(3) CUST_NAME                  VARCHAR2(30) TRANS_DATE                 DATE
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值