Oracle的sql监控
来源:互联网 发布:移动内网外网切换软件 编辑:程序博客网 时间:2024/05/16 00:36
<!--StartFragment -->
线上SQL抓取分析:
依照硬盘IO排列
SELECT * FROM (SELECT SQL_ID,PARSING_USER_ID,EXECUTIONS,SORTS,COMMAND_TYPE,DISK_READS FROM V$SQLAREA WHERE PARSING_USER_ID != 0 ORDER BY DISK_READS DESC ) WHERE ROWNUM<11
依照CPU使用排列
SELECT * FROM (SELECT SQL_ID,PARSING_USER_ID,EXECUTIONS,SORTS,COMMAND_TYPE,DISK_READS,CPU_TIME FROM V$SQLAREA WHERE PARSING_USER_ID != 0 ORDER BY CPU_TIME DESC ) WHERE ROWNUM<11
依照SQL ID查询实际的SQL
SELECT SQL_TEXT FROM V$SQLTEXT WHERE SQL_ID='9brygt3kuuz7k' ORDER BY PIECE ASC
根据SPID查询SQL
SELECT a.username,a.machine,a.program,a.sid,a.serial#,a.status,c.piece,c.sql_text FROM v$session a,v$process b,v$sqltext c WHERE b.spid='&spid' AND b.addr=a.paddr AND a.sql_address=c.address(+) ORDER BY c.piece;
根据SPID查询连接信息
SELECT PID,SPID,USERNAME,SERIAL#,PROGRAM FROM V$PROCESS WHERE spid=
依照硬盘IO排列
SELECT * FROM (SELECT SQL_ID,PARSING_USER_ID,EXECUTIONS,SORTS,COMMAND_TYPE,DISK_READS FROM V$SQLAREA WHERE PARSING_USER_ID != 0 ORDER BY DISK_READS DESC ) WHERE ROWNUM<11
依照CPU使用排列
SELECT * FROM (SELECT SQL_ID,PARSING_USER_ID,EXECUTIONS,SORTS,COMMAND_TYPE,DISK_READS,CPU_TIME FROM V$SQLAREA WHERE PARSING_USER_ID != 0 ORDER BY CPU_TIME DESC ) WHERE ROWNUM<11
依照SQL ID查询实际的SQL
SELECT SQL_TEXT FROM V$SQLTEXT WHERE SQL_ID='9brygt3kuuz7k' ORDER BY PIECE ASC
根据SPID查询SQL
SELECT a.username,a.machine,a.program,a.sid,a.serial#,a.status,c.piece,c.sql_text FROM v$session a,v$process b,v$sqltext c WHERE b.spid='&spid' AND b.addr=a.paddr AND a.sql_address=c.address(+) ORDER BY c.piece;
根据SPID查询连接信息
SELECT PID,SPID,USERNAME,SERIAL#,PROGRAM FROM V$PROCESS WHERE spid=
0 0
- Oracle的sql监控
- ORACLE监控数据库性能的SQL
- oracle数据库性能监控的SQL
- oracle数据库性能监控的SQL
- 性能监控之oracle的SQL语句
- ORACLE监控数据库性能的SQL
- oracle监控数据库性能的SQL汇总
- Oracle监控数据库性能的SQL汇总
- Oracle-常用监控SQL
- oracle sql 监控
- Oracle监控Sql脚本
- Oracle-常用监控SQL
- Oracle常用监控SQL
- Oracle常用监控SQL
- Oracle常用监控SQL
- Oracle常用监控SQL
- Oracle常用监控SQL
- Oracle常用监控SQL
- Redis资料的整理
- Android 美团Robust热更新 使用入门
- 装备选择
- Redis资料的整理
- c语言面试题目
- Oracle的sql监控
- 修改字符串以及string 与char* char[]之间的转换
- 线程中断 实例 interrupt
- avalon学习资料
- 笔记 一个函数返回参数二进制中 1 的个数
- 小白学自动化测试之工具篇——TestWriter
- avalon学习资料
- jquery操作select(增加,删除,清空)
- Java NIO秒读小文件