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 10046 SQL TRACEOracleSQL
- Oracle:db file scattered readOracle
- 單個SQL語句的10046 traceSQL
- [Javascript] How javascript read the property?JavaScript
- How to Convert Class File to Java File Online?Java
- 等待事件db file sequential read、db file scattered read和direct read的區別事件
- ADFS – How to enable Trace Debugging and advanced access logging
- 【TUNE_ORACLE】等待事件之IO等待“db file scattered read”Oracle事件
- 【TUNE_ORACLE】等待事件之IO等待“db file sequential read”Oracle事件
- Oracle session traceOracleSession
- How to Convert a Class File to a Ja
- 【TRACE】如果通過10046跟蹤資料庫效能問題資料庫
- read content in a text file in pythonPython
- How to use Qt Designed Ui fileQTUI
- 從10046看Oracle分割槽裁剪Oracle
- db file scattered read等待事件事件
- db file sequential read等待事件事件
- 【等待事件】db file sequential read事件
- 【等待事件】db file scattered read事件
- 從v$diag_info定位trace file
- 從10046 trace 的trca報告中總結的時間模型示例模型
- How to Dump Redo Log File Information --metalinkORM
- [20181130]control file sequential read.txt
- C# read excel file via ExcelDataReaderC#ExcelLDA
- 0316理解db file parallel read等待事件Parallel事件
- Trace file的命名規則和存放路徑
- How to get the exact duration of an audio file in js All In OneJS
- Oracle診斷案例-Sql_traceOracleSQL
- iis 0x80070032 Cannot read configuration file because it exceeds the maximum file size
- I/O上的等待事件 —— control file sequential read/control file parallel write事件Parallel
- [20181129]大量的control file sequential read.txt
- 0322理解db file parallel read等待事件2Parallel事件
- How Oracle Store Number internal(zt)Oracle
- How to Install EMC PowerPath on Oracle VM 3.4Oracle
- [Design Pattern] Upload big file - 2. How to coordinate frontend and backend
- 每日一個 Golang Packages 06/07 os File Read wtiteGolangPackage
- idea怎麼修改檔案的file is read-onlyIdea
- [20210315]理解db file parallel read等待事件3.txtParallel事件
- [20210315]理解db file parallel read等待事件4.txtParallel事件