Re: Is Rollback a Transaction !

From: Subodh Deshpande <deshpande.subodh_at_gmail.com>
Date: Mon, 13 Feb 2012 20:22:51 +0530
Message-ID: <CAJsOtB7inqCi5rM_rY65ohO3uPKnb761JCdjU-r79FARJD35DA_at_mail.gmail.com>

Thanks Jonathan,
Yes, by transaction in oracle database, I mean a successful commit and that is why I asked whether a rollback should also be considered as transaction.

Subodh!

On 13 February 2012 17:22, <jonathan_at_jlcomp.demon.co.uk> wrote:

>
>
> That's not a trivial question - it depends what you want to mean by
> "transaction".
>
> Techincally the mechanism for processing a rollback ends with exactly the
> same operation as a commit, i.e. generation of a "commit SCN" an update to
> the relevant undo segment header transaction table entry.
>
> You then have to worry about counting sys-recursive events (such as space
> management). Unfortunately Oracle doesn't give you all the information you
> need; you have:
>
> user commits
> user rollback
> transaction rollbacks
>
> The last statistics includes user rollbacks though, and there is no
> statistic for recursive commits. The closest approximation you get for a
> total count used to be a statistic about "calls to kcmgas" - but in 11g
> that can be incremented quite a lot more by actions other than commits and
> rollbacks.
>
> Regards
> Jonathan Lewis
>
>
> deshpande.subodh_at_gmail.com wrote:
> > Hi List,
> > Suppose I want find out how many transactions can happen or happened in a
> > time frame..
> > then apart from successful commits and or user calls, should I need to
> > consider rollbacks(no matter what is the reason, may be because of user
> > intervention or due to error) happened during the time frame.
> >
> > Thanks!
> > Subodh
> >
> >
> > > http://www.freelists.org/webpage/oracle-l
> >
> >
> >
> >
> >
> >
> > --
> > ==========================
> > ====================
> > Love me or Hate me both are in my Favour.
> > Love me, I am in your Heart. Hate me, I am in your Mind.
> > ==========================
> > ====================
> >
> >
> > --
> > http://www.freelists.org/webpage/oracle-l
> >
> >
> >
>
>

-- 
=============================================
Love me or Hate me both are in my Favour.
Love me, I am in your Heart. Hate me, I am in your Mind.
=============================================


--
http://www.freelists.org/webpage/oracle-l

Received on Mon Feb 13 2012 - 08:52:51 CST