Re: Is Rollback a Transaction !
- From: Subodh Deshpande <deshpande.subodh@xxxxxxxxx>
- To: jonathan@xxxxxxxxxxxxxxxxxx
- Date: Mon, 13 Feb 2012 20:22:51 +0530
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@xxxxxxxxxxxxxxxxxx> 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@xxxxxxxxx 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