Re: Is Rollback a Transaction !

From: Sidney Chen <huanshengchen_at_gmail.com>
Date: Mon, 13 Feb 2012 14:32:00 +0800
Message-ID: <CAM_ddu-ngUZQ4Nt5FOvw1agvWHA+NM2G52evKU7E1e3WB7C3Vg_at_mail.gmail.com>



User rollback is also accounted in the transactions. you can take the awr snapshot in the frame, and check the "Rollbacks:" and "Transactions:" in the "Load Profile" in the awr report

On Mon, Feb 13, 2012 at 1:44 PM, Subodh Deshpande < 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
>
>
>

-- 
Regards
Sidney Chen


--
http://www.freelists.org/webpage/oracle-l
Received on Mon Feb 13 2012 - 00:32:00 CST

Original text of this message