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

最新推荐文章于 2018-10-29 19:22:48 发布
原创 最新推荐文章于 2018-10-29 19:22:48 发布 · 1.1w 阅读 · 1 ·
CC 4.0 BY-SA版权
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。

本文介绍如何防止Oracle数据库中特定表及其依赖索引的统计信息被后续的统计收集操作覆盖，直至某一时间点。通过使用DBMS_STATS包手动维护优化器统计信息，并提供了锁定统计信息的方法。

40. You have statistics collected for some selected tables. Your requirement is that the statistics for the

tables and all dependent indexes must not be overwritten by further statistics collection until a certain

point of time.

How would you achieve this?

A.Lock statistics for the tables.

B.Change STALE_PERCENT to zero for the tables.

C.Set the TIMED_STATISTICS parameter to TRUE.

D.Set the STATISTICS_LEVEL parameter to BASIC.

E.Set the OPTIMIZER_USE_PENDING parameter statistics to TRUE.

Answer: A  

答案解析：

参考：http://docs.oracle.com/cd/E11882_01/server.112/e41573/stats.htm#PFGRF94712


You can maintain optimizer statistics manually using the DBMS_STATS package. For example, you can save and restore copies of statistics. You can export statistics from one database and import those statistics into another database. For example, you can export statistics from a production system to a test system. You can also lock statistics to prevent them from changing.



OCP 11G 1Z0-052 V8.02.pdf
04-11
1. **错误原因**: 这个错误通常发生在当一个事务试图获取某个数据块的一致读视图（即快照），但该数据块的undo记录已经被清除，导致无法创建一致读视图。 2. **解决办法**: - **选项分析**: - A. 查询无法获取到...
OCP认证VCE题库1Z0-052
01-22
用的是1Z0-052.188道V8.02版制作，处女座工程师出品，完美品质，值得信赖
how to lock statistics for the tables
qq_19557525的专栏
05-17 413
一、查看表的statistics 的方法 select table_name,owner,stattype_locked from dba_tab_statistics where stattype_locked is not null; 二、lock statistics for the table 方法 exec dbms_stats.lock_table_stats ('',
40.You have statistics collected for some selected tables. Your requirement is that the statistics
dwj19830118的专栏
07-20 1311
40.You have statistics collected for some selected tables. Your requirement is that the statistics for the tables and all dependent indexes must not be overwritten by further statistics collection until a certain point of time.
41.You have recently collected statistics on certain objects of a schema in your database. But you o
dwj19830118的专栏
07-21 1384
41.You have recently collected statistics on certain objects of a schema in your database. But you observe suboptimal execution plans for the queries on these objects after two days of statistics collection. The optimizer statistics retention period is set
OCP-1Z0-052-V8.02-41题
一抹曦阳-Oracle
11-06 1万+
41. You have recently collected statistics on certain objects of a schema in your database. But you observe suboptimal execution plans for the queries on these objects after two days of statistics co
20151122 ocp 052(01-10)解析
gumengkai的博客
11-22 781
1.you need to load information about new customers from the new_cust table into the tables cust and cust_special , if a new customer has a credit limit greater than 10000,then the details have to be
Oracle OCP 1Z0-051 题库V8.02 全新解析
题库V8.02是指针对1Z0-051考试更新至第八版次的题库资料。 知识点一：Oracle数据库简介 Oracle数据库是由甲骨文公司开发的一种关系型数据库管理系统（RDBMS）。它支持复杂的查询、事务处理以及高效的存储和管理大量...
OCP-1Z0-052-V8.02-1题
sdfsdkk的博客
10-29 180
分享一下我老师大神的人工智能教程！零基础，通俗易懂！http://blog.csdn.net/jiangjunshow也欢迎大家转载本篇文章。分享知识，造福人民，实现我们中华民族伟大复兴！                1. View the
deferrable initially deferred
赱向远方
05-09 1860
DEFERRABLE Clause The DEFERRABLE and NOT DEFERRABLE parameters indicate whether or not, in subsequent transactions, constraint checking can be deferred until the end of the transaction using the SET C
OCP-1Z0-052-V8.02-100题
一抹曦阳-Oracle
11-14 1万+
100. In which situations does the Oracle Data Pump use external tables and not the direct path load while exporting a table? (Choose all that apply.) A.if a table is not in a cluster B.if a table h
teradata collect statistics
09-22 294
teradata可以用下面语句收集统计信息： collect statistice on tablename column(columnname); 收集统计信息后，teradata PE就会按照收集的统计信息确定执行计划，...
锁 死锁 阻塞 Latch 等待 详解
tianshibaijia
09-26 414
锁这东西是纯概念性的东西，但是作用又非常大。以前整理过两篇文章，今天又看了点书，觉得还不是很清楚。就重新整理了下。在想要不要把以前的文章删掉，这样在blog里是比较简介的，但后来又一想。这些连接在其他的地方可能被引用了。就决定还是保留着了，也算见证自己成长的一个过程。 ORACLE锁机制 http://blog.csdn.net/xujinyang/article/details/6882...
Recently
让阳光照进心里
09-02 920
刚刚找到了一个BUG,是有关多线程互斥资源的,已经解决了.还有五分钟吃饭,随便说点什么吧.   真心感慨做游戏事情好多好多,这个项目只做前端(前端前端的,都是跟燕春同学学的...),没有网络和数据库部分,还好一些.有很多可能出现问题的地方,操作系统,语言,图形,都要懂一些,越来越觉得自己好无能,很多事情都是一知半解而已.好在,问题到目前为止都解决了,而且在可控的形式之下.毕竟,做软件把握好复杂度
编译时Collected errors
qq_39502936的博客
02-05 5498
lede下编译新固件，编译时出现错误 Collected errors: * satisfy_dependencies_for: Cannot satisfy the following dependencies for luci-app-ddns: * ddns-scripts * * opkg_install_cmd: Cannot install package luci-app
A referential integrity constraint violation occurred BUG修复
xujianrj的专栏
05-30 3417
参考：http://stackoverflow.com/questions/8856588/how-to-update-complex-model-in-asp-net-mvc-3
今天总算搞懂了RI (Referential Integrity) 引用完整性
热门推荐
Kemin | 本博客独立到nakeman.cn
06-06 1万+
今天总算搞懂了RI (Referential Integrity) 引用完整性数据的完整性内容比较多，暂不谈，现只举个例子理解一下引用完整性实例关系：多篇文章(Article)某一类别(Class)父子关系：一方为父多方为子主外键关系：父方主键与子方外键关联原理：父子关系是通过选定的键关联的，如果某一方的这个键变更了，而另一方不作更新，必然造成数据的不正确。如：文章实体用C
169.You have two tables with referential integrity enforced between them. You need to insert data to
dwj19830118的专栏
08-08 749
169.You have two tables with referential integrity enforced between them. You need to insert data to the child table first because it is going to be a long transaction and data for the parent table will be available in a later stage, which can be inserted
评论
成就一亿技术人!
拼手气红包6.0元
还能输入1000个字符
 
红包 添加红包
表情包 插入表情
表情包 代码片
 条评论被折叠 查看
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值