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