Re: strange select issue

From: Tom <tomNOSPAM_at_teameazyriders.com>
Date: Thu, 18 Sep 2003 21:34:36 GMT
Message-ID: <Mxpab.1376$P64.12316873@news-text.cableinet.net>

> issue
> alter session set events='10046 trace name context forever, level 12'
>
> This will generate a trace file in the user_dump_dest directory, which
> will show you *what* it is waiting for.
> 8.1.5 is a can of worms and have been desupped long since. The 8.1
> productline will be laid to rest on December 31, 2003

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

hmm does that offer any info?

thanks

Tom Received on Thu Sep 18 2003 - 16:34:36 CDT