You're right Shrinivas. I'm sorry.
I think you can try with
v$sysstat -- user commits +
user rollbacks
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Saturday, December 01, 2001 1:15 AM
This will give the peak usage of
Hi lists,
Does anybody have a query to find , how many transactions ran since the
instance started.
v$transaction will have only the current trnx running.
is there any other views that will show the total trnx since instance
startup.
Thnx and regards,
Srinivas
--
Please see the official
Is there any column related to this in v$resource_limt ?
-Original Message-
Sent: Friday, November 30, 2001 7:05 AM
To: Multiple recipients of list ORACLE-L
Hi lists,
Does anybody have a query to find , how many transactions ran since the
instance started.
v$transaction will have
if you're using Oracle 8
check v$resource_limit.transactions view
HTH
Diego Cutrone
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, November 30, 2001 7:05 AM
Hi lists,
Does anybody have a query to find , how many transactions ran
This will give the peak usage of the transactions, since instance
started, but not the cumulative.
-Original Message-
Sent: Friday, November 30, 2001 1:41 PM
To: Multiple recipients of list ORACLE-L
if you're using Oracle 8
check v$resource_limit.transactions view
HTH
Diego Cutrone
