[oradebug命令學習2]How to Use Oradebug to Get Trace File Name and Location

尛樣兒發表於2012-11-10

How to Use Oradebug to Get Trace File Name and Location [ID 310830.1]
修改時間:2012-7-31型別:HOWTO狀態:PUBLISHED優先順序:3

In this Document

Goal
Fix
References


Applies to:

Oracle Server - Enterprise Edition - Version 8.1.7.4 to 11.2.0.3 [Release 8.1.7 to 11.2]
Information in this document applies to any platform.
***Checked for relevance on 26-Apr-2012***

Goal

How to get trace file name and location from SQL*Plus when trace event is enabled in a session using 'Alter session'?

Fix

Use the command: Oradebug tracefile_name 

For example:

  1. At SQL*Plus prompt, execute:
       'Alter session set events ... ' statement to enable tracing.
  2. Issue:
       Oradebug setmypid
       Oradebug tracefile_name

Sample Output

SQL> conn sys/sys as sysdba
Connected.

SQL> alter session set events '10046 trace name context forever, level 12';

Session altered.

SQL> oradebug setmypid
Statement processed.

SQL> oradebug tracefile_name
/u01/app/oracle/diag/rdbms/v1120/v1120/trace/v1120_ora_26077.trc

References

@NOTE:29786.1 - SUPTOOL: ORADEBUG

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/23135684/viewspace-748940/，如需轉載，請註明出處，否則將追究法律責任。

相關文章