Re: number of transactions in a day

From: Jared Still <jkstill_at_gmail.com>
Date: Fri, 1 Jun 2007 12:27:06 -0700
Message-ID: <bf46380706011227w1faaad3fnfae51dbec987aca9@mail.gmail.com>

On 6/1/07, dd yakkali <dd.yakkali_at_gmail.com> wrote:
>
> Is there any way of knowing howmany transactions happened in a day?
>

No. The database has no idea how many business transactions are processed by your applications.

Applications need to build this into the software. SAP for instance does this.

The database can tell you how many COMMITs have occurred since the database has started, but that is not a measure of business transactions.

Some damagement report needs this.
>
>

Tell them to ask the application folks.

-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

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

Received on Fri Jun 01 2007 - 14:27:06 CDT