ITPub博客

首页 > Linux操作系统 > Linux操作系统 > 我晕!9204难道有这样的bug???

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

原创 Linux操作系统 作者:nmgzw 时间:2019-06-24 18:42:04 0 删除 编辑

使用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",
................
郁闷啊!

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/25702/viewspace-464269/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2002-10-18

  • 博文量
    71
  • 访问量
    55277