关于asm的隐含参数_disable_rebalance_compact
来源:互联网 发布:优酷 java待遇 编辑:程序博客网 时间:2024/05/17 01:29
What is ASM rebalance compact Phase and how it can be disabled (文档 ID 1902001.1)
APPLIES TO:
Oracle Database - Enterprise Edition - Version 11.1.0.7 and later
Information in this document applies to any platform.
GOAL
What's compact phase during rebalance?
SOLUTION
+ The compact phase is part of rebalance operation, it moves the data as close as possible to the outer tracks of the disks (the lower numbered offsets).
The first time you run rebalance with 11g, it could take a while if the disk group configuration changed (especially via ADD DISK) when running with 10g ASM. Subsequent manual rebalance without a configuration change should not take as much time.
A disk group where the compact phase of rebalance has done a lot of work will tend to have better performance than the pre-compact disk group. The data should be clustered near the higher performing tracks of the disk, resulting less seektime .
+ It's enabled by default from 11g onwards.
+ It generally takes place at the end of rebalance operation.
Before 12c, we cannot see compact phase on v$asm_operation view at asm level. If one see EST_MINUTES shows as '0' and waiting for long time, probably its is doing compact. This can be confirmed by seeing system state dump from ASM level and mostly we will see no blocking session and waits are "kfk:async IO"
From 12c onwards, we can see compact phase as separate operation .
+ Compact phase can be disabled.
Before 12c, use hidden parameter _disable_rebalance_compact=true at instance level .
From 12c onwards, _disable_rebalance_compact parameter is no longer available, however Diskgroup attribute _rebalance_compact can be used:
SQL> ALTER DISKGROUP <dg> SET ATTRIBUTE '_rebalance_compact'='FALSE';
- 关于asm的隐含参数_disable_rebalance_compact
- 关于oracle隐含参数 总结
- 关于js的隐含参数(arguments,callee,caller)
- 理解ASM(二)关于ASM实例的初始化参数
- fdisk的部分隐含参数
- 查询Oracle的隐含参数
- 隐含参数_optimizer_skip_scan_enabled的作用
- pga_aggregate_target相关的隐含参数
- make的参数 隐含规则使用的变量 关于命令参数的变量
- 关于asm上使用filesystemio_options初始化参数的问题
- 关于oracle读取数据时,自动进行HASH处理的隐含参数:_gby_hash_aggregation_enabled
- 【parameter】oracle的隐含参数的查看
- linux中top的隐含参数秘密
- linux中top的隐含参数秘密
- oracle 查看隐含参数的脚步
- VC:va_list用法---隐含参数的使用方法
- javascript的隐含参数(arguments,callee,caller)
- oracle查看隐含参数的SQL
- 2016-9-13
- python中的编码声明
- 网站客服聊天
- C#处理和对接HTTP接口请求
- webFrom
- 关于asm的隐含参数_disable_rebalance_compact
- sqoop1.4.2 从Oracle装载数据到HDFS
- linux开发环境搭建
- Leetcode #9 Solution
- 在.net(C# or vb.net)中如何用户自定义消息,并在窗体中处理这些消息。
- javascript放大器实现
- java 句子翻转问题与字符串翻转
- 字符串问题
- hdu 5876 求补图上的最短路