Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How to find out daily Transaction rate.

Re: How to find out daily Transaction rate.

From: Jurij Modic <jmodic_at_src.si>
Date: Tue, 19 Jan 1999 20:45:47 GMT
Message-ID: <36a4eee8.12080204@news.arnes.si>


On 19 Jan 1999 11:14:18 GMT, "Johnny chopra" <johnnyc_at_mail.starnet.com.au> wrote:

>Does any one knows how to find out
>number of transactions which occurs on daily basis.

You can query V$SYSSTAT daily at the same time end see how many commits have been isued during last 24 hours.

SELECT value FROM v$sysstat WHERE name='user commits';

>Regards
>Johnny

HTH,
Jurij Modic <jmodic_at_src.si>
Certified Oracle7 DBA (OCP)



The above opinions are mine and do not represent any official standpoints of my employer Received on Tue Jan 19 1999 - 14:45:47 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US