Re: Recording Oracle transaction levels

On 11 Sep., 12:12, Johne_uk <edg..._at_tiscali.co.uk> wrote:
> Hi,
>
> 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
> John

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