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

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 17:14 +0000
Organization	solani.org
Message-ID	<pan.2011.04.30.17.14.21@gmail.com> (permalink)
References	<01055700-12ef-4e13-abf8-5446d5328c0b@f31g2000pri.googlegroups.com> <17c014bc-7b17-405b-831d-c9a3404dc774@f2g2000yqf.googlegroups.com>

Show all headers | View raw

On Sat, 30 Apr 2011 07:16:36 -0700, Mark D Powell wrote:

> Tiago, I think John's recommendation to use the standard Oracle trace
> feature is a good one.  Every insert will be caugth by trace committed
> or not.  The commits will also be caught by the trace though you will
> need to scan the raw trace file to see statements.

Of course, in case of the 3-tier application, it will be a joy to read 
the traces from all the server processes, especially if the application 
doesn't use DBMS_APPLICATION_INFO and launches a 100 or so processes when 
it is started.

-- 
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