Re: SQLGLS dump on 64bit

From: My-Works <info_at_my-works.org>
Date: Tue, 29 Apr 2003 10:15:20 +0200
Message-ID: <b8lc1o$h56$1@grillo.cs.interbusiness.it>

> Do you see any trace file in udump directory?

I added the
alter session set sql_trace=true
statement to my program and the next trace appeared in udump directory:

/usr1/oracle/admin/htora1/udump/htora1_ora_27653.trc Oracle9i Enterprise Edition Release 9.2.0.1.0 - 64bit Production JServer Release 9.2.0.1.0 - Production
ORACLE_HOME = /usr1/oracle/home
System name: HP-UX

Node name:      hpux01
Release:        B.11.11
Version:        U
Machine:        9000/800

Instance name: htora1
Redo thread mounted by this instance: 1
Oracle process number: 11
Unix process pid: 27653, image: oracle_at_hpux01 (TNS V1-V3)

• SESSION ID:(12.7439) 2003-04-29 10:04:49.797

  ---

  PARSING IN CURSOR #1 len=35 dep=0 uid=33 oct=42 lid=33 tim=1095069102480 hv=1775 202973 ad='163abc98' alter session set sql_trace = true END OF STMT EXEC #1:c=0,e=154,p=0,cr=0,cu=0,mis=1,r=0,dep=0,og=4,tim=1095069102441

  ---

  PARSING IN CURSOR #1 len=39 dep=0 uid=33 oct=3 lid=33 tim=1095069169051 hv=18265 34040 ad='149763a0' select count(*) into :b1 from DUAL END OF STMT PARSE #1:c=0,e=1348,p=0,cr=0,cu=0,mis=1,r=0,dep=0,og=4,tim=1095069169021 EXEC #1:c=0,e=102,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=1095069169407 FETCH #1:c=10000,e=394,p=0,cr=3,cu=0,mis=0,r=1,dep=0,og=4,tim=1095069169955

but the program hangs during SQLGLS call. The only way to stop it is kill -9
unix command.

After this next two lines where added to the trace file: STAT #1 id=1 cnt=1 pid=0 pos=1 obj=0 op='SORT AGGREGATE ' STAT #1 id=2 cnt=1 pid=1 pos=1 obj=222 op='TABLE ACCESS FULL OBJ#(222) '

What can I do?
Thanks
Misha Received on Tue Apr 29 2003 - 03:15:20 CDT