转载请注明出处:http://blog.csdn.net/guoyjoe/article/details/11664185
答案 BC
sys@OCM> alter system set fast_start_mttr_target=0; ----显示设为0
答案A不正确,这两参数与SGA顾问器无关。
答案B:正确,当fast_start_mttr_target 默认为0(即没有手工设0)说明是开启了自动检查点,(fast_start_mttr_target=0或默认,mttr顾问器都会被禁用)。
答案C正确,显式设置FAST_START_MTTR_TARGET = 0,自动检查点调整被禁用了(来自MOS:Automatic checkpoint tuning is enabled by default.If it is disabled, by setting the parameter to zero explicitly)
|
Automatic Checkpoint Tuning in Oracle 10g
(文档 ID 265831.1) |
APPLIES TO:
Oracle Server - Enterprise Edition - Version: 10.1.0.2 to 11.2.0.3 - Release: 10.1 to 11.2Information in this document applies to any platform.***Checked for relevance on 10-Oct-2011***
PURPOSE
To understand the new feature of "Automatic Checkpoint Tuning" introduced in Oracle 10g.
SCOPE
The note is intended for DBA's to get quickly familiar with this new Oracle 10g feature.
AUTOMATIC CHECKPOINT TUNING IN ORACLE 10G
Automatic Checkpoint Tuning
Oracle Database 10g supports automatic checkpoint tuning. It is enabled if fast_start_mttr_target is explicitly set to an non-zero value, or if fast_start_mttr_target is not set at all.It is an advancement over the MTTR related parameter introduced in earlier versions. The idea is to use the periods of low I/O usage to advance checkpoints and therefore improve availability.
How to enable
Automatic checkpoint tuning is enabled by default.If it is disabled, by setting the parameter to zero explicitly, you can enable it by unsetting FAST_START_MTTR_TARGET or set it to a nonzero value. If you set
this parameter to zero this feature will be disabled.Note: this is different from defaulting (i.e. not setting) fast_start_mttr_target to 0.It can be done statically using the initialization files or dynamically using
SQL> alter system set FAST_START_MTTR_TARGET=10;
Note: This is measured in seconds
When to enable
- system I/O capacity is insufficient with fast-start checkpointing
- If it is necessary to control the time to recover from an instance or node failure, then set FAST_START_MTTR_TARGET to the desired MTTR in seconds.
How it works
Enabling fast-start checkpointing increases the average number of writes per transaction that DBWn issues for a given workload. However, if the system is not already near or at its maximum I/O capacity, thenfast-start checkpointing has a negligible impact on performance
How to monitor
View V$MTTR_TARGET_ADVICE will give information on the additional I/O's on various values of FAST_START_MTTR_TARGET.
PROs and CONs
- FAST_START_MTTR_TARGET is set to a low value:
Fast-start checkpointing is more aggressive. The average number of writes per transaction that DBWn issues is higher in order to keep the thread checkpoint sufficiently advanced to meet the requested MTTR
- FAST_START_MTTR_TARGET is set to a high value:
Fast-start checkpointing in less aggressive, and the average number of writes per transaction that DBWn issues is lower.
In both cases above automatic checkpoint is enabled.
- FAST_START_MTTR_TARGET is unset:
Automatic checkpoint tuning is in effect. Average number of writes per transaction is reduced but at the same time MTTR is highest.
NOTE:
- When you enable fast-start checkpointing, remove or disable (set to 0) the following initialization parameters:
- LOG_CHECKPOINT_INTERVAL
- LOG_CHECKPOINT_TIMEOUT
- FAST_START_IO_TARGET
- Automatic Checkpoint tuning using FAST_START_MTTR_TARGET is only available with the Oracle Enterprise Edition and is also referred to as 'Fast-start fault recovery'.
Please refer to
Oracle® Database Licensing Information
11g Release 2 (11.2)
Part Number E10594-18
http://download.oracle.com/docs/cd/E11882_01/license.112/e10594/editions.htm#CJACGHEB
1、默认是开启的自动检查点!!!!,即fast_start_mttr_target没做任何设。
sys@OCM> show parameter mttr
NAMETYPE VALUE
------------------------------------ -----------------------------------------
fast_start_mttr_targetinteger 0
隐藏参数“_disable_selftune_checkpointing”(Disable self-tune checkpointing )= FALSE
sys@OCM> show parameter dump
NAMETYPE VALUE
------------------------------------ -----------------------------------------
background_core_dumpstring partial
background_dump_deststring/u01/app/oracle/diag/rdbms/ocm
/ocm/trace
core_dump_deststring/u01/app/oracle/diag/rdbms/ocm
/ocm/cdump
max_dump_file_sizestring unlimited
shadow_core_dumpstring partial
user_dump_deststring/u01/app/oracle/diag/rdbms/ocm
/ocm/trace
[root@mydb ~]# su - oracle
[oracle@mydb ~]$ more /u01/app/oracle/diag/rdbms/ocm/ocm/trace/
ARC1 started with pid=25, OS id=10803
Thread 1 opened at log sequence 12
Current log# 3 seq# 12 mem# 0:/u01/app/oracle/oradata/ocm/redo03.log
Successful open of redo thread 1
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Sun Sep 08 14:38:03 2013
ARC2 started with pid=26, OS id=10805
2、如果说显式的设置alter system set FAST_START_MTTR_TARGET=0就是关闭自动调节。
idle> alter system set fast_start_mttr_target=0;
System altered.
sys@OCM> startup force;
ORACLE instance started.
Total System Global Area 839282688 bytes
Fixed Size 2233000 bytes
Variable Size 515902808 bytes
Database Buffers 314572800 bytes
Redo Buffers 6574080 bytes
Database mounted.
Database opened.
[root@mydb trace]# vi alert_ocm.log
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
MTTR advisory was turned off because FAST_START_MTTR_TARGET was disabled.
3、当FAST_START_MTTR_TARGET显示设为非零
idle> alter system set fast_start_mttr_target=120;
System altered.
idle> startup force;
ORACLE instance started.
Total System Global Area 839282688 bytes
Fixed Size 2233000 bytes
Variable Size 515902808 bytes
Database Buffers 314572800 bytes
Redo Buffers 6574080 bytes
Database mounted.
Database opened.
[root@mydb trace]# vi alert_ocm.log
当FAST_START_MTTR_TARGET显示设为非0,没发现MTTR advisory 相关的信息。
总结:FAST_START_MTTR_TARGET默认或显示设为在alert日志中都会有MTTR advisory is disabled。
MOS Automatic Checkpoint Tuning in Oracle 10g [ID 265831.1]
答案D不正确的,跟这个参数有关,如果设为ture就会把检查点信息写到aler日志
sys@OCM> show parameter alert
NAMETYPE VALUE
------------------------------------ -----------------------------------------
log_checkpoints_to_alertboolean FALSE
QQ:252803295
技术交流:
DSI&Core Search Ⅰ 群:127149411(2000人技术群:未满)
DSI&Core Search Ⅱ 群:177089463(1000人技术群:未满)
DSI&Core Search Ⅲ 群:284596437(500人技术群:未满)
DSI&Core Search Ⅳ 群:192136702(500人技术群:未满)
DSI&Core Search Ⅴ 群:285030382(500人闲聊群:未满)
MAIL:dbathink@hotmail.com
BLOG:http://blog.csdn.net/guoyjoe
WEIBO:http://weibo.com/guoyJoe0218
ITPUB:http://www.itpub.net/space-uid-28460966.html
OCM: http://education.oracle.com/education/otn/YGuo.HTM
分享到:
相关推荐
Oracle 参数FAST_START_MTTR_TARGET的详细介绍
OCPOCA认证考试指南全册:Oracle Database 11g(1Z0-051,1Z0-052,1Z0-053) 共2部分:此为第002部分 基本信息 原书名: OCA/OCP Oracle Database 11g All-in-One Exam Guide with CD-ROM: Exams 1Z0-051, 1Z0-052...
OCPOCA认证考试指南全册:Oracle Database 11g(1Z0-051,1Z0-052,1Z0-053) 共2部分:此为第001部分 基本信息 原书名: OCA/OCP Oracle Database 11g All-in-One Exam Guide with CD-ROM: Exams 1Z0-051, 1Z0-052...
11. Pentium-compatible microprocessors. CPUs from cyrix. The Cyrix 6x86. The Cyrix 6x86MX. CPUs from AMD. The K5—5K86. The AMD K6. AMD K6 II and AMD K6 III with Super Socket 7. IDT WinChip C6...
MTBF-MTTR-MTTF三个指标的区别
资料整理,包括: 一些ORACLE问题如ORA-01555,ORA-07445的分析和解决, 以及FAST_START_MTTR_TARGET相关的4个参数设置
语法: TIMESTAMP '1997-01-31 09:26:50.10' (将值存储为 11 个字节)。 默认值: 从 NLS_TERRITORY 中获得 nls_time_format: 说明: 指定一个字符串值, 设置 TIME 数据类型的默认值, 该数据类型包含 HOUR, MINUTE 和 ...
6.2.1.13 FAST_START_MTTR_TARGET 37 6.2.1.14 INSTANCE_GROUPS(RAC) 37 6.2.1.15 PARALLEL_INSTANCE_GROUP(RAC) 38 6.2.1.16 与DRM有关的隐藏参数(RAC) 38 6.2.1.17 SESSION_CACHED_CURSORS 39 6.2.1.18 ...
计算MAX MTTR的sample
概述这是一个针对某些可能发现有用的额外寻呼机职责报告的项目。 它有一个有角度的前端和一个node.js表达后端来处理一些数字。客户安装依赖项npm install在后台,这也称为bower install 。 您应该发现您的项目中有两...
软件系统在某种意义上也是一种产品,所以用MTBF、MTTF、MTTR这三项指标来衡量软件系统的可靠性同样也是合适的。本文着重介绍这三项指标的定义以及它们之间的关系。
您可以测量准备时间,部署频率,平均还原时间(MTTR)和更改存储库的失败百分比。 如果您想贡献这个包裹,请分叉并一个拉取请求。 依存关系 吉特 先决条件 所有发行版都必须标记有特定的前缀和版本号[prefix] ...
用图示方式解释MTTR MTTF MTBF 概念及计算机系统可用性计算公式
仑悸吁噶忌蒙镊显叫拽拘拥乳漳归擅揽吟砧糕软借记鸡整豆枝奎拴铜逐凑汐安 6 计 算 机 基 础 知 识 笔 记 计算机的四特点: 1.有信息处理的特性。2.有程序控制的特性。3.有灵活选择的特性。4.有正确应 用的特性。...
mattty-t.github.io 网站: mattty-t.github.io ... 单击切换按钮将创建一个列表,该列表将下拉并允许用户浏览网站。 切换按钮是使用Javascript制作的。 悬停效果和过渡效果-将鼠标悬停在导航栏上的各个部分上将使
MTBF&MTTF&MTTR概念[归类].pdf
A measure of the degree to which an item is in an operable and committable state at the start of a mission when the mission is called for at an unknown (random) time. MTTF = ΣTTF/n (Mean time to fail...