Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed.icl.net!newsfeed.fjserv.net!newsfeed.icl.net!colt.net!news.tele.dk!feed118.news.tele.dk!postnews.google.com!s16g2000cws.googlegroups.com!not-for-mail
From: "buccellik" <kellibuccelli@comcast.net>
Newsgroups: comp.databases.oracle.server
Subject: Re: executable to fix data doesn't appear to be doing anything..help
Date: 7 Jul 2006 06:45:31 -0700
Organization: http://groups.google.com
Lines: 35
Message-ID: <1152279931.394775.80960@s16g2000cws.googlegroups.com>
References: <1152277531.552150.89220@m79g2000cwm.googlegroups.com>
   <1152279399.130211.148410@p79g2000cwp.googlegroups.com>
NNTP-Posting-Host: 206.205.83.4
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
X-Trace: posting.google.com 1152279935 14753 127.0.0.1 (7 Jul 2006 13:45:35 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Fri, 7 Jul 2006 13:45:35 +0000 (UTC)
In-Reply-To: <1152279399.130211.148410@p79g2000cwp.googlegroups.com>
User-Agent: G2/0.2
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0),gzip(gfe),gzip(gfe)
X-HTTP-Via: 1.0 Symantec_Web_Security (3.0.1.76)
Complaints-To: groups-abuse@google.com
Injection-Info: s16g2000cws.googlegroups.com; posting-host=206.205.83.4;
   posting-account=6NG7rw0AAACwJ6GG8fUS22U2gZETitvg
Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:270568

I did run the 10046 trace, and the trace file only contained all of the
waits, as shown above.
Steve Howard wrote:
> 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