使用alter session set sql_trace=true；本来想打印一个trace文件出来看看，可。。。。。

 
SQL> select * from v$version;

BANNER
----------------------------------------------------------------
Oracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit Production
PL/SQL Release 9.2.0.4.0 - Production
CORE 9.2.0.3.0 Production
TNS for HPUX: Version 9.2.0.4.0 - Production
NLSRTL Version 9.2.0.4.0 - Production

SQL> show parameter dump

NAME TYPE VALUE
------------------------------------ ----------- -------------------------
background_dump_dest string /oracle/BWD/saptrace/background
core_dump_dest string /oracle/BWD/saptrace/background
max_dump_file_size string UNLIMITED
shadow_core_dump string partial
user_dump_dest string /oracle/BWD/saptrace/usertrace

使用alter session set sql_trace=true后，发现生成的trace文件出现到了/oracle/BWD/920_64/rdbms/log/目录下，并没有出现在该出现的位置，后来用alter sysetm 重新指定后，再alter session set sql_trace后，发现回到正确的位置了！可退出sqlplus，再连接进去，发现位置又错了，我晕啊！

 

bwdev:orabwd 25> pwd
/oracle/BWD/920_64/rdbms/log
bwdev:orabwd 26> more bwd_ora_7563.trc
/oracle/BWD/920_64/rdbms/log/bwd_ora_7563.trc
Oracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit Production
With the Partitioning option
JServer Release 9.2.0.4.0 - Production
ORACLE_HOME = /oracle/BWD/920_64
System name:    HP-UX
Node name:      bwdev
Release:        B.11.23
Version:        U
Machine:        ia64
Instance name: BWD
Redo thread mounted by this instance: 0 
Oracle process number: 0
7563

Ioctl ASYNC_CONFIG error, errno = 1
*** 2006-10-17 20:50:43.841
*** SESSION ID:(60.40978) 2006-10-17 20:50:43.841
APPNAME mod='SQL*Plus' mh=3669949024 act='' ah=4029777240
=====================
PARSING IN CURSOR #1 len=68 dep=0 uid=22 oct=42 lid=22 tim=3335285333417 hv=1346161232 ad='41a39958'
alter session set events '10046 trace name context forever,level 12'
END OF STMT
EXEC #1:c=10000,e=99,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=3335285333317
WAIT #1: nam='SQL*Net message to client' ela= 3 p1=1650815232 p2=1 p3=0
*** 2006-10-17 20:50:56.281
WAIT #1: nam='SQL*Net message from client' ela= 12147867 p1=1650815232 p2=1 p3=0
WAIT #1: nam='SQL*Net more data from client' ela= 17 p1=1650815232 p2=218 p3=0
=====================
PARSING IN CURSOR #1 len=2051 dep=0 uid=22 oct=3 lid=22 tim=3335297482018 hv=3999031343 ad='41b80c38'
SELECT /*+ STAR_TRANSFORMATION FACT( T_00 )  */
 T_11."SID_0DOC_CURRCY" "S____063",
 T_11."SID_0BASE_UOM" "S____163",
 T_11."SID_0STAT_CURR" "S____295",
 T_02."S__0ACCNT_ASGN" "S____412",
 T_04."FISCPER" "K____028",
 T_06."S__Z1SGCP" "S____347",
 T_06."S__Z1QTCP" "S____346",
 T_07."SID_0DOC_TYPE" "S____467",
................

郁闷啊！

我晕！9204难道有这样的bug???