oracle11g Real Time SQL Monitoring
来源:互联网 发布:cd音轨抓取软件 编辑:程序博客网 时间:2024/06/03 16:07
两种方法监控SQL执行情况
1、v$session_longops记录某个操作执行时间超过6秒
2、v$SQL_MONITOR或者package DBMS_MONITOR来主动对SQL执行监控部署
该功能具备三个条件即可
A)
SQL> show parameter statistics_level
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
statistics_level string TYPICAL
B)
SQL> select STATISTICS_NAME,SESSION_STATUS ,SYSTEM_STATUS,ACTIVATION_LEVEL,SESSION_SETTABLE from v$statistics_level where STATISTICS_NAME = 'SQL Monitoring';
STATISTICS_NAME SESSION_
---------------------------------------------------------------- --------
SYSTEM_S ACTIVAT SES
-------- ------- ---
SQL Monitoring ENABLED
ENABLED TYPICAL YES
C)
SQL> show parameter control_manage
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
control_management_pack_access string DIAGNOSTIC+TUNING
- oracle11g Real Time SQL Monitoring
- Real-Time SQL Monitoring详解
- ID 1380492.1 Monitoring SQL statements with Real-Time SQL Monitoring
- Real-Time SQL Monitoring using DBMS_SQLTUNE
- 【SQL Performance】实时SQL监控功能(Real-Time SQL Monitoring)
- Real-Time SQL Monitoring using DBMS_SQLTUNE (REPORT_SQL_MONITOR, REPORT_SQL_MONITOR_LIST and REPORT_
- Monitoring SQL Statements with Real-Time SQL Monitoring (文档 ID 1380492.1)
- Inotify: Efficient, Real-Time Linux File System Event Monitoring
- Real Time Interactive IP LAN Monitoring with IPTraf Tool
- Monitoring the Cluster in Real Time with CHM (Cluster Health Monitor)
- oratop - Utility for Near Real-time Monitoring of Databases, RAC and Single Instance (Doc ID 1500864
- Salesforce.com and real time SQL
- Real-time
- real time、CPU time探讨
- Real-Time Glow
- Real-Time Workshop®
- Real-Time Windows Target
- Real-Time HTML editor
- 对于MVC模式的一点疑惑
- Managing within the dynamic business environment
- 关于笔记本电脑硬盘方面升级的大搜罗
- 使用Dreamweaver 5.5 + JQuery + PhoneGap 开发手机应用程序(上)
- POJ 2247 Humble Numble(我的水题之路——丑数2,3,5,7)
- oracle11g Real Time SQL Monitoring
- 鲁宾斯坦离职:曾担任Palm CEO
- 杂谈:请为flash cs x版本加一个布局显示工具
- html文件导入了DTD之后 无法获取scrollTop的高度
- 海贼王游戏--EM游戏06--巧夺天工
- 大型web 应用服务架构配置一栏
- 如何学习单片机?
- 2012.1.28-月记计划书
- fiddler使用记录