Re: strange select issue

Where is your SELECT statement? It is missing from your trace file. Start the 10046 trace and then issue the SELECT statement again. See all of those lines that say "WAIT #1"? We need to see those lines that the SELECT statement is waiting on.

Cheers,
Brian

Tom wrote:
>
> > 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

-- 
===================================================================

Brian Peasland
dba_at_remove_spam.peasland.com

Remove the "remove_spam." from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
 the three"