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:

At SQL*Plus prompt, execute:
'Alter session set events ... ' statement to enable tracing.
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博客

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

Applies to:

Goal

Fix

References

最新文章