在oracle11g当中,可以有更加简单的定位当前trace文件的办法,那就是访问视图 v$diag_info。
store@TEST> select * from v$version;
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
PL/SQL Release 11.2.0.1.0 - Production
CORE 11.2.0.1.0 Production
TNS for Linux: Version 11.2.0.1.0 - Production
NLSRTL Version 11.2.0.1.0 - Production
store@TEST> set linesize 1500;
store@TEST> SELECT * FROM v$diag_info;
INST_ID NAME VALUE
---------- ---------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------