monitoring usage
来源:互联网 发布:gson封装复杂json 编辑:程序博客网 时间:2024/04/29 22:28
1. Which two statements are true about identifying unused indexes? (Choose two.)
A. Performance is improved by eliminating unnecessary overhead during DML operations.
B. V$INDEX_STATS displays statistics that are gathered when using the MONITORING USAGE keyword.
C. Each time the MONITORING USAGE clause is specified, the V$OBJECT_USAGE view is reset for the specified index.
D. Each time the MONITORING USAGE clause is specified, a new monitoring start time is recorded in the alert log.
参照以下BLOG,理解如何查看索引监控的使用以及注意事项:
(1)http://ora110.itpub.net/post/33978/457118
(2)http://www.eygle.com/archives/2004/12/monitor_index_usage.html
答案:AC
解释:
A:在DML操作中消除不必要的消耗使性能得到提升
B:V$INDEX_STATS 视图显示使用MONITORING USAGE 关键字获得的统计信息,应该是V$OBJECT_USAGE
C:每次开始MONITORING USAGE 语句将重置V$OBJECT_USAGE 视图的相应索引信息
D:每次开始MONITORING USAGE 语句,一个新的监控开始时间被记录到ALERT LOG中,没有记录,可以查看ALERT_<SID>.LOG系统日志文件
总结:
开始监视索引使用:ALTER INDEX 索引名 MONITORING USAGE;
查看被监视索引使用情况:SELECT * FROM V$OBJECT_USAGE;
停止监视索引使用:ALTER INDEX 索引名 NOMONITORING USAGE;
- monitoring usage
- Monitoring CPU usage
- Disk usage monitoring
- Monitoring Index Usage in Oracle9i
- Monitoring Index Usage【每日一译】--20121216
- How to see index usage (without "alter index ... monitoring usage")
- two scripts - monitoring the usage of rollback segments of Oracle Database
- iOS获取设备流量使用情况 iPhone Data Usage Tracking/Monitoring
- iOS获取设备流量使用情况 iPhone Data Usage Tracking/Monitoring
- iOS获取设备流量使用情况 iPhone Data Usage Tracking/Monitoring
- 转载:iOS获取设备流量使用情况 iPhone Data Usage Tracking/Monitoring
- iOS获取设备流量使用情况 iPhone Data Usage Tracking/Monitoring
- Memory leak in Windows 8.1 with Killer E2200 and Windows Network Data Usage Monitoring
- Sysstat – All-in-One System Performance and Usage Activity Monitoring Tool For Linux
- usage
- 137 While Monitoring the space usage in your database that is in ARCHIVELOG mode you observed that t
- Security Monitoring
- Keystroke Monitoring
- 无锡尚德 侯云
- 虚函数和纯虚函数的区别
- Silverlight全局(App.xaml)和局部样式汇总
- C# 基础学习笔记
- Silverlight中如何将style独立
- monitoring usage
- 让表单的所有控件失效
- windows下 如何在Web页面上直接打开、编辑、创建Office文档
- 关于URI is hierarchical错误的解决方案
- Excel交叉引用及其应用实例
- No result defined for action and result
- Verilog assign和always 注意事宜
- ORACLE NUMBER类型
- [转]linux文件系统基础知识