Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

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

Re: 10.2.0.1 trace uncommitted inserts

Show all headers | View raw

On Apr 28, 4:08 pm, Tiago <diariodastril...@gmail.com> wrote:
> Hi,
>
>   I have an application written in .net, I have only the .exe, not the
> source. It keeps processing data from an external source and inserting
> on a table, but sometimes I can't see the data on the table. Sometimes
> it inserts, sometimes doesn't. Vendor is taking too long to figure
> that out, since the message that get inserted look like exactly like
> the one that doesn't :( I suspect it is trying to commit but something
> wrong happens. App log doesn't show any error, external data source
> says it sent the data correctly, App log says it received, but nothing
> is inserted.
>
> Is there a way to trace uncommited inserts? I would try to check if
> the insert is happening at all, perhaps the App log isn't catching
> something that could be a big error...
>
> Thanks!
>
> -- Tiago

If you are really running on 10.2.0.1 ( not 10.2.0.4 or 10.2.0.5 )
then some really bad things could be happening with a ton of unapplied
oracle maintenance.

An Oracle 10046 trace is the usual recommended definitive way of
tracing what is going on with an application.

Can you work with a dba resource to get a trace done for you?

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