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

Re: 10.2.0.1 trace uncommitted inserts

Path	csiph.com!x330-a1.tempe.blueboxinc.net!usenet.pasdenom.info!news.albasani.net!weretis.net!feeder1.news.weretis.net!news.solani.org!.POSTED!not-for-mail
From	Mladen Gogala <gogala.mladen@gmail.com>
Newsgroups	comp.databases.oracle.server
Subject	Re: 10.2.0.1 trace uncommitted inserts
Date	Sat, 30 Apr 2011 17:14:21 +0000 (UTC)
Organization	solani.org
Lines	16
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>
Mime-Version	1.0
Content-Type	text/plain; charset=UTF-8
Content-Transfer-Encoding	8bit
X-Trace	solani.org 1304183661 19278 eJwNy8ERwDAIA7CVwmE7MA4HYf8RWv1Fl6kvRIHLLXB8TgiGDqSFSnpynRInE537WPdvY5YfBKwQKQ== (30 Apr 2011 17:14:21 GMT)
X-Complaints-To	abuse@news.solani.org
NNTP-Posting-Date	Sat, 30 Apr 2011 17:14:21 +0000 (UTC)
User-Agent	Pan/0.133 (House of Butterflies)
X-User-ID	eJwNwocRwDAIBLCVAqaYcXjK/iM4J+kxsnIxNdH9QZnmOiNlp3qjg4JS0x02YAFQ3fbJAW49LpASGw==
Cancel-Lock	sha1:tu/FtuqQtj3HLqtUGeLiOY9QoLk=
X-NNTP-Posting-Host	eJwNxskBwDAIA7CVHGMgGScH7D9Cq5fcYsRNhYe8vTGIzhJpZlJa77/7wgs6fQ4ZzHqNCUz3pSCV8/rLdr4patTZG6VV6A+H+Ri2
Xref	x330-a1.tempe.blueboxinc.net comp.databases.oracle.server:576

Show key headers only | 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