executable to fix data doesn't appear to be doing anything..help

From: buccellik <kellibuccelli_at_comcast.net>
Date: 7 Jul 2006 06:05:31 -0700
Message-ID: <1152277531.552150.89220@m79g2000cwm.googlegroups.com>

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. Received on Fri Jul 07 2006 - 08:05:31 CDT