Groups > comp.databases.oracle.server > #572

Re: 10.2.0.1 trace uncommitted inserts

From	Mladen Gogala <gogala.mladen@gmail.com>
Newsgroups	comp.databases.oracle.server
Subject	Re: 10.2.0.1 trace uncommitted inserts
Date	2011-04-30 04:10 +0000
Organization	solani.org
Message-ID	<pan.2011.04.30.04.10.58@gmail.com> (permalink)
References	(2 earlier) <85dea8c3-3833-4922-9d01-2be6563071fa@s41g2000prb.googlegroups.com> <dbd152c0-1b1f-4685-9a31-cf71e82485d0@m10g2000yqd.googlegroups.com> <06a1a0dc-7a24-4654-93c4-957fdba600fe@m13g2000yqb.googlegroups.com> <2d458eb5-4798-4caf-a73b-218177beca35@f2g2000yqf.googlegroups.com> <f7c76626-69b4-46f5-b4d2-f004ee84f6ae@m10g2000yqd.googlegroups.com>

Show all headers | View raw

On Fri, 29 Apr 2011 17:00:01 -0700, John Hurley wrote:

> The original poster does not apparently know about setting a 10046
> trace.  More than one person implicated in not having the ability to
> figure out what is going on at least in my mind.

10046 trace has nothing to do with the problem. The original problem, at 
least according to what I have read, is that the application log contains 
the record of the transaction while the table doesn't. If that is a usual 
3-tier application with an application server, client and a DB server, 
tracing it will not be trivial as it may include many sessions that are 
unrelated to the problem. If the vendor "cannot figure out what's 
happening", the vendor is extremely unlikely to be using 
DBMS_APPLICATION_INFO. The best bet is a trigger with an autonomous 
transaction which will show what was fired and when. That is called 
"debugging" and is usually done by the people who write the application. 
If they are unable to do so, which is what the OP implied, then they are 
not very competent, period.
Furthermore, your sanctimonious "I'm holier than thou" attitude is 
beginning to bore the heck out of me, so I ignore majority of your posts. 
You can shove your crystal ball where the sun doesn't shine. 

-- 
http://mgogala.byethost5.com

Back to comp.databases.oracle.server | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

10.2.0.1 trace uncommitted inserts Tiago <diariodastrilhas@gmail.com> - 2011-04-28 13:08 -0700
  Re: 10.2.0.1 trace uncommitted inserts John Hurley <hurleyjohnb@yahoo.com> - 2011-04-28 14:39 -0700
  Re: 10.2.0.1 trace uncommitted inserts Mladen Gogala <no@email.here.invalid> - 2011-04-29 16:30 +0000
    Re: 10.2.0.1 trace uncommitted inserts John Hurley <hurleyjohnb@yahoo.com> - 2011-04-29 12:47 -0700
      Re: 10.2.0.1 trace uncommitted inserts ddf <oratune@msn.com> - 2011-04-29 13:15 -0700
        Re: 10.2.0.1 trace uncommitted inserts John Hurley <hurleyjohnb@yahoo.com> - 2011-04-29 15:25 -0700
        Re: 10.2.0.1 trace uncommitted inserts John Hurley <hurleyjohnb@yahoo.com> - 2011-04-29 15:29 -0700
          Re: 10.2.0.1 trace uncommitted inserts Mladen Gogala <no@email.here.invalid> - 2011-04-29 22:45 +0000
          Re: 10.2.0.1 trace uncommitted inserts ddf <oratune@msn.com> - 2011-04-29 16:06 -0700
            Re: 10.2.0.1 trace uncommitted inserts John Hurley <hurleyjohnb@yahoo.com> - 2011-04-29 17:00 -0700
              Re: 10.2.0.1 trace uncommitted inserts Mladen Gogala <gogala.mladen@gmail.com> - 2011-04-30 04:10 +0000
  Re: 10.2.0.1 trace uncommitted inserts Mark D Powell <Mark.Powell2@hp.com> - 2011-04-30 07:16 -0700
    Re: 10.2.0.1 trace uncommitted inserts Mladen Gogala <gogala.mladen@gmail.com> - 2011-04-30 17:14 +0000
    Re: 10.2.0.1 trace uncommitted inserts joel garry <joel-garry@home.com> - 2011-05-02 09:38 -0700

csiph-web