Re: 10.2.0.1 trace uncommitted inserts

From: ddf <oratune_at_msn.com>
Newsgroups: comp.databases.oracle.server Subject: Re: 10.2.0.1 trace uncommitted inserts Date: Fri, 29 Apr 2011 16:06:07 -0700 (PDT) Organization: http://groups.google.com
Lines: 29
Message-ID: <2d458eb5-4798-4caf-a73b-218177beca35_at_f2g2000yqf.googlegroups.com> References: <01055700-12ef-4e13-abf8-5446d5328c0b_at_f31g2000pri.googlegroups.com>  <pan.2011.04.29.16.30.35_at_email.here.invalid> <85dea8c3-3833-4922-9d01-2be6563071fa_at_s41g2000prb.googlegroups.com>  <dbd152c0-1b1f-4685-9a31-cf71e82485d0_at_m10g2000yqd.googlegroups.com> <06a1a0dc-7a24-4654-93c4-957fdba600fe_at_m13g2000yqb.googlegroups.com> NNTP-Posting-Host: 208.240.243.170
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable X-Trace: posting.google.com 1304118368 14618 127.0.0.1 (29 Apr 2011 23:06:08 GMT) X-Complaints-To: groups-abuse_at_google.com NNTP-Posting-Date: Fri, 29 Apr 2011 23:06:08 +0000 (UTC) Complaints-To: groups-abuse_at_google.com Injection-Info: f2g2000yqf.googlegroups.com; posting-host 8.240.243.170; posting-account=KXUmygkAAABvBFmgDBe4RBLFwhTRAMZC User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.1; WOW64;

 Trident/4.0; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR
 3.0.30729; Media Center PC 6.0; InfoPath.2; .NET4.0C),gzip(gfe)
Xref: textnews.cambrium.nl comp.databases.oracle.server:93974

On Apr 29, 3:29 pm, John Hurley <hurleyjo..._at_yahoo.com> wrote:
> David:
>
> # That is not what Mladen said or implied.
>
> So you are Mladen are twins that understand exactly what the other was
> trying to convey in a newsgroup posting?
>
> I did not realize that ...
>
> # The intent here is to suggest that the OP possibly create a trigger
> to capture insert  transactions into a separate table, with other
> information such as who did the insert and when, to track what is or
> isn't  happening.
>
> That's such a better idea than getting a 10046 trace initially eh?
>
> # There was no mention that the venedor is using triggers.
>
> Try reading the next several lines of Mladens reply that I left out a
> couple of times.  Do the shampoo thing ( rinse and repeat ) ...

I have, but apparently you didn't comprehend the text. Read the post prior to Mladen's stating that the vendor can't figure out why this isn't working; any vendor that can't figure out their own product is suspect in my book, too.

David Fitzjarrell Received on Fri Apr 29 2011 - 18:06:07 CDT