從v$diag_info定位trace file
Oracle Support note Interpreting Raw SQL_TRACE output (39817.1). TKPROF
As of version 11.1, it ’ s much easier to query either the v$diag_info or v$process views, as shown in the following examples:
SQL> SELECT value
2 FROM v$diag_info
3 WHERE name = 'Default Trace File';
VALUE
--------------------------------------------------------------------
/u00/app/oracle/diag/rdbms/dba111/DBA111/trace/DBA111_ora_23731.trc
SQL> SELECT p.tracefile
2 FROM v$process p, v$session s
3 WHERE p.addr = s.paddr
4 AND s.sid = sys_context('userenv','sid');
TRACEFILE
--------------------------------------------------------------------
/u00/app/oracle/diag/rdbms/dba111/DBA111/trace/DBA111_ora_23731.trc
Note that the v$diag_info view provides information for the current session only.
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/14377/viewspace-2286456/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- sql_trace生成及使用tkprof檢視trace fileSQL
- oracle監聽開啟trace fileOracle
- Process W000 died, see its trace file
- How to read Oracle 10046 trace fileOracle
- v$datafile.file#與v$tempfile.file#區別
- 10.2.0.2 RAC DB ">>> ERROR IN KQLMBIVG SEE LCK TRACE FILEError
- oracle deadlock死鎖trace file分析之一Oracle
- 監聽器控制程式lsnrctl跟蹤trace file
- Please Check VKTM Trace File for More Details (文件 ID 1347586.1)AI
- truncate、recreate後臺程式跟蹤檔案(trace file)
- Non critical error ORA-48913 caught while writing to trace fileErrorWhile
- oracle deadlock死鎖trace file分析之一增補Oracle
- 【11g】v$diag_info檢視獲得控制檔案轉儲檔名及位置
- ORA-01157: cannot identify/lock data file %s - see DBWR trace file的處理IDE
- TECH: Getting a Stack Trace from a CORE file on Unix (Doc ID 1812.1)
- ass109.awk 分析Oracle 的跟蹤檔案(trace file)Oracle
- 基於10.2.0.1 rac deadlock死鎖 trace file分析_增補二
- [20130117]Analyzing a SQL Trace File with SQL Statements.txtSQL
- [oradebug命令學習2]How to Use Oradebug to Get Trace File Name and Location
- Mysql從指定位置擷取字串MySql字串
- 控制檔案恢復—從trace檔案中恢復
- Process J000 died, see its trace file,kkjcre1p: unable to spawn jobq slave process
- SQL TraceSQL
- trace errorstackError
- OERR: ORA-1499 table/Index Cross Reference Failure - see trace file [ID 1499.1]IndexROSAI
- No virtual method setOutputFile Ljava/io/File V in class Landroid/media/MediaRecorderJavaAndroid
- Key File 破解之 PicMaster V2.5 (10千字)AST
- Oracle歸檔日誌使用情況: v$recovery_file_dest and v$recovery_area_usage.Oracle
- 從Export Dumpfile file 中讀出DDL 語句Export
- 從Swift語言看ORM的定位錯誤SwiftORM
- Oracle session traceOracleSession
- mysql trace optimizerMySql
- SQL_TRACESQL
- 問題之Process m000 died, see its trace file&ksvcreate: Process(m000) creation failedAI
- 從 React Router v5 過渡到 v6React
- 從 webpack v1 遷移到 webpack v2Web
- 抖音藍V賬號定位及外化羅盤(附下載)
- 談談Babel v6的新特性及未來定位Babel