Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!postnews.google.com!75g2000cwc.googlegroups.com!not-for-mail
From: "Steve Howard" <stevedhoward@gmail.com>
Newsgroups: comp.databases.oracle.server
Subject: Re: executable to fix data doesn't appear to be doing anything..help
Date: 7 Jul 2006 06:49:49 -0700
Organization: http://groups.google.com
Lines: 47
Message-ID: <1152280189.118428.94320@75g2000cwc.googlegroups.com>
References: <1152277531.552150.89220@m79g2000cwm.googlegroups.com>
   <1152279399.130211.148410@p79g2000cwp.googlegroups.com>
   <1152279931.394775.80960@s16g2000cws.googlegroups.com>
NNTP-Posting-Host: 132.174.33.112
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
X-Trace: posting.google.com 1152280192 4402 127.0.0.1 (7 Jul 2006 13:49:52 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Fri, 7 Jul 2006 13:49:52 +0000 (UTC)
In-Reply-To: <1152279931.394775.80960@s16g2000cws.googlegroups.com>
User-Agent: G2/0.2
X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.0.4) Gecko/20060508 Firefox/1.5.0.4,gzip(gfe),gzip(gfe)
Complaints-To: groups-abuse@google.com
Injection-Info: 75g2000cwc.googlegroups.com; posting-host=132.174.33.112;
   posting-account=NfkiWwwAAAC7WIM54Nm5OVSmHWKeUTNj
Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:270570


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

Please don't top post (posting on top of responses already provided),
as it makes the responses harder to follow.

What did you type when set the trace?  Also, are you sure it uses
binds?  How did you find the SQL it is executing?

Regards,

Steve