Re: Recording Oracle transaction levels
Date: Thu, 11 Sep 2008 04:15:53 -0700 (PDT)
On 11 Sep., 12:12, Johne_uk <edg..._at_tiscali.co.uk> wrote:
> Just a quick question.
> My manager is in the process of setting up some KPIs for our IT
> department (mostly general interest for other depts to look at). One
> such metric he has requested is 'the actual number of transactions
> executed within the previous hour'.
> I don't think this is possible because, as far as I know, Oracle
> doesn't keep any record of the number of transactions it has executed
> and taking regular snapshots of how many transactions are running at
> that exact time is going to be pretty meaningleess as some
> transactions can be as short as a mill-second.
> So the question being - is my assumption above correct or is there
> another way to do this that I'm unaware of?
> Thanks in advance
Btw : The view flashback_transcation_query only records committed transactions, not those that are rolled back. So If your manager wants to know the sum of all transactions (committed + rolled back), use Statspack (or AWR reporting), as Sybrand suggested.
- Kenneth Koenraadt