How to read Oracle 10046 trace file
alter session set timed_statistics=true
/
alter session set max_dump_file_size=unlimited
/
alter session set tracefile_identifier='Identifier'
/
alter session set events '10046 trace name context forever, level 12'
/
SQL
/
alter session set events '10046 trace name context off'
/
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/207/viewspace-997329/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- ORACLE TRACE 10046Oracle
- Oracle 10046 SQL TRACEOracleSQL
- How to enable trace in OracleOracle
- how to start '10046 trace name context forever,level 12'Context
- Oracle SQL Trace 和 10046 事件OracleSQL事件
- 讀懂Oracle 10046 SQL TRACEOracleSQL
- Oracle SQL Trace 和10046 事件OracleSQL事件
- How to Get a 10046 trace for a Parallel Query [ID 1102801.1]Parallel
- oracle sql trace與10046淺談OracleSQL
- Maclean教你讀Oracle 10046 SQL TRACEMacOracleSQL
- Oracle:db file scattered readOracle
- oracle監聽開啟trace fileOracle
- Oracle 11g新SQL Trace 10046方法OracleSQL
- Oracle中開啟10046 Trace的各種方法Oracle
- 10046 trace詳解(1)
- sql_trace/ 10046 整理SQL
- sql_trace and 10046事件SQL事件
- Oracle中開啟10046 Trace的各種方法[轉]Oracle
- Oracle ASM How many allocation units per fileOracleASM
- Event 10046 - Enable SQL Statement TraceSQL
- Oracle中開啟trace 10046 event 的各種方法[zt]Oracle
- oracle deadlock死鎖trace file分析之一Oracle
- ZT 自動10046 trace指令碼指令碼
- oracle wait event之db file sequential readOracleAI
- 解決db file sequential read與db file scattered read
- [oradebug命令學習2]How to Use Oradebug to Get Trace File Name and Location
- How Users Read on the Web (轉)Web
- 等待事件db file sequential read、db file scattered read和direct read的區別事件
- 單個SQL語句的10046 traceSQL
- sql_trace、10046、10053、tkprofSQL
- 如何使用SQL_TRACE和10046事件SQL事件
- 跟蹤SQL - SQL Trace 及 10046 事件SQL事件
- How to Run Statement Level/Java trace or a SQL Trace in Self Service ApplicationJavaSQLAPP
- oracle deadlock死鎖trace file分析之一增補Oracle
- zt_How to read ERRORSTACK outputError
- How to build a jar file by mavenUIJARMaven
- sql_trace生成及使用tkprof檢視trace fileSQL
- db file scattered read與事件db file sequential read相類似(轉)事件