SQL诊断工具-10046 Event
来源:互联网 发布:软件产品质量 编辑:程序博客网 时间:2024/06/10 08:30
SQL> select * from v$version;
BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi
PL/SQL Release 10.2.0.4.0 - Production
CORE 10.2.0.4.0 Production
TNS for IBM/AIX RISC System/6000: Version 10.2.0.4.0 - Productio
NLSRTL Version 10.2.0.4.0 - Production
SQL> alter session set events '10046 trace name context forever, level 12';
ERROR:
ORA-01031: insufficient privileges
设置10046事件时出现了ORA-01031: insufficient privileges
给用户授予alter session 的权限,试试
SQL> conn / as sysdba
Connected.
SQL> grant alter session to user;
Grant succeeded.
SQL> conn user/password
Connected.
SQL> select * from v$mystat where rownum=1;
SID STATISTIC# VALUE
---------- ---------- ----------
445 0 1
--在session级别开启10046 Event
SQL> alter session set events '10046 trace name context forever, level 12';
会话已更改。
SQL> set timing on;
SQL> select count(policyno) as sumcount
2 from Prpjinvoiceloan
3 Where SettleType = '0'
4 AND PayRefDate IS Null
5 AND PRINTERCODE = '3300112003';
SUMCOUNT
----------
0
已用时间: 00: 00: 00.29
--关闭10046 Event
SQL> alter session set events '10046 trace name context off';
会话已更改。
已用时间: 00: 00: 00.01
--查询生产trace文件的路径
TRACE_FILE_NAME
--------------------------------------------------------------------------------
/oracle/app/admin/ca561dev/udump/ca561dev_ora_1712218.trc
已用时间: 00: 00: 00.23
SQL> exit
--为了方便阅读,使用oracle自带的tkprof格式化trace文件
/oracle/app/admin/ca561dev/udump$tkprof ca561dev_ora_1712218.trc 2.txt aggregate=no explain=user/password
--查看格式化后的文件
/oracle/app/admin/ca561dev/udump$ more 2.txt
。。。省略部分信息。。。
********************************************************************************
count = number of times OCI procedure was executed
cpu = cpu time in seconds executing
elapsed = elapsed time in seconds executing
disk = number of physical reads of buffers from disk
query = number of buffers gotten for consistent read
current = number of buffers gotten in current mode (usually for update)
rows = number of rows processed by the fetch or execute call
--------------------------------------------------------------------------------
*** SESSION ID:(445.18365) 2010-11-18 16:00:26.300
********************************************************************************
select count(policyno) as sumcount
from Prpjinvoiceloan
Where SettleType = '0'
AND PayRefDate IS Null
AND PRINTERCODE = '3300112003'
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.01 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 2 0.01 0.25 615 615 0 1
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 4 0.01 0.26 615 615 0 1
- SQL诊断工具-10046 Event
- ORACLE SQL_TRACE SQL诊断工具
- SQL诊断------10046事件
- DBA手记:DBA诊断利器 - Event 10046和 10053
- 使用Extended Events诊断SQL Server 2012----在SQL Server 2012中创建Extended Event会话
- 使用Extended Events诊断SQL Server 2012----查看由Extended Event捕获的数据
- Oracle_Statspack性能诊断工具
- Oracle_Statspack性能诊断工具
- SMTPDiag 诊断工具
- WAS 诊断工具
- Oracle诊断工具-RDA
- 网络诊断工具
- 自动诊断工具ADDM
- ORACLE 日常诊断工具
- 系统诊断工具
- hanganalyz 性能诊断工具
- oracle性能诊断工具
- linux网络诊断工具
- 精确测试时间
- select-options 条件总结
- 局域网打印机共享方法
- 006_《深入Delphi6 网络编程》
- 四类clustering方法比较
- SQL诊断工具-10046 Event
- SLC500 channel0在user mode/system mode间转换
- tips
- msp430单片机应用之定时器、PWM、比较器
- 投稿参考
- 投稿参考
- JQuery的.ajax方法实例
- c++学习笔记
- 反射