Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to find out daily Transaction rate.
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)