Trace COMMIT/TRANSACTION
From: valigula <valigula_at_gmail.com>
Date: Tue, 28 Dec 2010 03:55:01 -0800 (PST)
Message-ID: <f61cb6c6-a3ff-473b-a101-46893279c3dd_at_w2g2000yqb.googlegroups.com>
Hi All,
Date: Tue, 28 Dec 2010 03:55:01 -0800 (PST)
Message-ID: <f61cb6c6-a3ff-473b-a101-46893279c3dd_at_w2g2000yqb.googlegroups.com>
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 Received on Tue Dec 28 2010 - 05:55:01 CST