Re: strange select issue

From: Tom <tomNOSPAM_at_teameazyriders.com>
Date: Thu, 18 Sep 2003 21:35:37 GMT
Message-ID: <Jypab.1378$s64.12308614@news-text.cableinet.net>

> thanks - this is what i have
>
> $ tail -f ora_3603.trc
> =====================
> PARSING IN CURSOR #1 len=7 dep=0 uid=5 oct=44 lid=5 tim=0 hv=2688585178
> ad='27604474'
> commit
> END OF STMT
> PARSE #1:c=0,e=0,p=0,cr=0,cu=0,mis=1,r=0,dep=0,og=4,tim=0
> XCTEND rlbk=0, rd_only=1
> EXEC #1:c=0,e=0,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=0
> WAIT #1: nam='SQL*Net message to client' ela= 0 p1=1413697536 p2=1 p3=0
> WAIT #1: nam='SQL*Net message from client' ela= 0 p1=1413697536 p2=1 p3=0
> XCTEND rlbk=0, rd_only=1

apologies - perhaps the whole thing helps....

Dump file /u01/app/oracle/admin/STG2/udump/ora_3603.trc Oracle8i Release 8.1.5.0.0 - Production
With the Java option
PL/SQL Release 8.1.5.0.0 - Production
ORACLE_HOME = /u01/app/oracle/product/8.1.5 System name: SunOS

Node name:      paros
Release:        5.8
Version:        Generic_108529-08
Machine:        i86pc

Instance name: STG2
Redo thread mounted by this instance: 1
Oracle process number: 3
Unix process pid: 3603, image: oracle_at_paros (TNS V1-V3)

2003.09.18.22.09.58.000
SESSION ID:(7.9) 2003.09.18.22.09.58.000 APPNAME mod='SQL*Plus' mh=3669949024 act='' ah=4029777240
PARSING IN CURSOR #1 len=70 dep=0 uid=5 oct=42 lid=5 tim=0 hv=4065493978 ad='2760c308' alter session set events='10046 trace name context forever, level 12' END OF STMT EXEC #1:c=0,e=0,p=0,cr=0,cu=0,mis=1,r=0,dep=0,og=4,tim=0 WAIT #1: nam='SQL*Net message to client' ela= 0 p1=1413697536 p2=1 p3=0 WAIT #1: nam='SQL*Net message from client' ela= 0 p1=1413697536 p2=1 p3=0
PARSING IN CURSOR #1 len=7 dep=0 uid=5 oct=44 lid=5 tim=0 hv=2688585178 ad='27604474' commit END OF STMT PARSE #1:c=0,e=0,p=0,cr=0,cu=0,mis=1,r=0,dep=0,og=4,tim=0 XCTEND rlbk=0, rd_only=1 EXEC #1:c=0,e=0,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=0 WAIT #1: nam='SQL*Net message to client' ela= 0 p1=1413697536 p2=1 p3=0 WAIT #1: nam='SQL*Net message from client' ela= 0 p1=1413697536 p2=1 p3=0 XCTEND rlbk=0, rd_only=1

Received on Thu Sep 18 2003 - 16:35:37 CDT