关于Oracle 12c 中的Heat Map
来源:互联网 发布:克里米亚战争知乎 编辑:程序博客网 时间:2024/05/17 01:25
关于Oracle 12c 中的Heat Map:
以下摘自:Information Lifecycle Management (ILM), Heat Map, Automatic Data Optimization (ADO) (文档 ID 1612385.1)
Heat Map is an Oracle Database 12c feature that stores system-generated data usage statistics at the row and segment levels – information that can be used to automate the compression and movement of data in order to reduce storage costs, improve performance and optimize Oracle Database storage. Heat Map, used in conjunction with Automatic Data Optimization can automate compression and storage policies based on the usage of the data. Segment level Heat Map tracks the time of last modification and access of tables and partitions. Row level Heat Map shows modification times at the row level. Heat Map, once enabled, automatically collects segment and row level statistics that can be used to define compression and storage policies which will be automatically maintained throughout the lifecycle of the data. Heat Map skips internal access done for system tasks -- automatically excluding Stats Gathering, DDLs or Table Redefinitions.
Heat Map can be enabled as:
ALTER SYSTEM SET HEAT_MAP = ON;
By default the value is OFF
The V$HEAT_MAP_SEGMENT view displays real-time segment access information. The ALL_, DBA_, and USER_HEAT_MAP_SEGMENT views display the latest segment access time for all segments visible to the user. The ALL_, DBA_, and USER_HEAT_MAP_SEG_HISTOGRAM views display segment access information for all segments visible to the user. The DBA_HEATMAP_TOP_OBJECTS view displays heat map information for the top 1000 objects. The DBA_HEATMAP_TOP_TABLESPACES view displays heat map information for the top 100 tablespaces.
- 关于Oracle 12c 中的Heat Map
- deep learning: heat Map
- OpenStack中的Heat进阶
- OpenStack中的Heat分析
- OpenStack中的Heat分析
- 关于Oracle 12c 多租户架构中的db_files参数.
- 关于 oracle 12c
- 关于C语言中的Map(thinkvd 开发日志)
- 关于c++map
- Nova和Heat中的servergroup
- 查看heat template中的脚本
- 网站点击热图(Heat Map)
- Heat
- 关于Map中的重复键
- 关于STL中的map用法
- 关于Python 中的 map()函数
- 关于Map中的重复键
- 关于SubString在C#,JAVA,Oracle,SQLServer中的不同用法
- 判断浏览器兼容性:
- Hibernate 的增删查改语句
- Android-使用线性布局管理器布局
- 数据库维护的操作
- php环境下,无法curl问题
- 关于Oracle 12c 中的Heat Map
- Ubuntu安装图解
- Oracle DRM技术的变迁 (四)
- color key在倒车显示功能上的至关重要性
- Android服务器——使用TomCat实现软件的版本检测,升级,以及下载更新进度!
- max-width
- leetcode 5 Longest Palindromic Substring(manacher)
- 阿尔法狗打脸啪啪响啊~
- Function:--js中创建函数的方法