Re: Is Rollback a Transaction !

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
>
>
>

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