Re: is there are a way to track commits?

Another possibility is to mine the redo logs for this information.

HTH,
Brian

NetComrade wrote:
>
> I issue
> alter session set events '10046 trace name context forever, level 12'
> but I cannot identify commits in the log
> is there are another event that should be set?
> I am trying to evaluate if we can decrease the amount of commits in
> the App. The App is Pro*C. I'd like to see after which statements the
> commit is being issued. Should I assume that whenever I see a 'log
> file sync', a commit has been made?
>
> Thanks in advance.
> .......
> We use Oracle 8.1.7.4 on Solaris 2.7 boxes
> remove NSPAM to email

-- 
===================================================================

Brian Peasland
oracle_dba_at_remove_spam.peasland.com

Remove the "remove_spam." from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
 the three"