Re: Trace COMMIT/TRANSACTION

From: joel garry <joel-garry_at_home.com>
Date: Tue, 28 Dec 2010 10:08:16 -0800 (PST)
Message-ID: <bd58501b-8a1d-4766-b56c-d00a5de678d2_at_u25g2000pra.googlegroups.com>

On Dec 28, 3:55 am, valigula <valig..._at_gmail.com> wrote:
> Hi All,
>
> Is it possible to trace commit's in oracle 11g ?,  A process is
> inserting data into several database tables using hibernate, i would
> like to check if commit is done one time per all the inserts or one
> per every one.
>
> I have activated the sql_traces/tkprof, but the stats  i am gaining
> are referring to every query and not to the transaction.
>
> Do i need to use AWR ? or any other tool?
>
> Thanks in advance

Also see the examples for v$session in
http://www.dbspecialists.com/files/presentations/wait_events_10g.html so you can at least see if the log file sync is an issue.

I also don't know anything about hibernate, but you might want to search about pl/sql using batch commit at asktom.oracle.com. If hibernate does that, counting commits could be misleading. I don't think it does, from a quick google about needing jdbc batching for mass inserts. But that's all beyond me.

jg

--
_at_home.com is bogus.
OMG!  "Doctor" Turi is still around!
http://www.examiner.com/astropsychology-in-phoenix/do-you-have-a-brain-for-social-networks
This guy used to annoy ca.earthquakes with psychic earthquake
predictions.

Received on Tue Dec 28 2010 - 12:08:16 CST