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: way to check how many transactions been process

Re: way to check how many transactions been process

From: Steve Howard <stevedhoward_at_gmail.com>
Date: Sat, 10 Nov 2007 16:24:32 -0000
Message-ID: <1194711872.731292.84240@50g2000hsm.googlegroups.com> 





On Nov 10, 10:33 am, aaa <aaa_mem..._at_newsguy.com> wrote:


> We have ORACLE 9ir2 on LINUX servers.  Does there has way or script which can

> check how many transactions been process?

>

> Thnaks.




Hi,



If by transactions you mean commits, then if you have statspack
installed, you can query stats$sysstat for the difference in 'user
commits' over a period of time.



HTH,


Steve
Received on Sat Nov 10 2007 - 10:24:32 CST












Original text of this message













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