Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: executable to fix data doesn't appear to be doing anything..help
buccellik wrote:
> We were given an executable problem, from ESRI, to fix duplicate data
> in our database. The executable runs forever, we have never gotten it
> to finish, but killed it. When I do a trace on the database session it
> produces, the trace file is nothing but the following:
> WAIT #7: nam='SQL*Net message to client' ela= 3 p1=1111838976 p2=1 p3=0
> WAIT #7: nam='SQL*Net message from client' ela= 66 p1=1111838976 p2=1
> p3=0
> WAIT #7: nam='SQL*Net break/reset to client' ela= 3 p1=1111838976 p2=1
> p3=0
> WAIT #7: nam='SQL*Net break/reset to client' ela= 63 p1=1111838976 p2=0
> p3=0
> WAIT #7: nam='SQL*Net message to client' ela= 3 p1=1111838976 p2=1 p3=0
>
> When I use Performance Overview, I can see an SQL statement associated
> with the session. However, I would like to run that statement on my
> own, but I don't know what values are in the bind variables. Does
> anyone know how I can find out the values for the bind variables?
>
> Thanks.
Hi,
Version? (the answer varies)
You should be able to run a 10046 trace to get the values. Look for it on metalink, or google for it.
Regards,
Steve Received on Fri Jul 07 2006 - 08:36:39 CDT