Re: Transaction rate question

Ranko.Mosic_at_gmail.com wrote:
> select count(*) from v$sysstat
> where name like '%commit%rollback%'

If this query returns anything more than a 0 count I"ll be surprised, as no such string exists in any NAME value in V$SYSSTAT. Possibly you're confused and meant:

select sum(value)
from v$syssat
where name in ('user commits','user rollbacks');

Using count(*) in place of sum(value) would return 2, always, and provide absolutely no insight into the transactional activity of the instance.

Before posting more useless drivel to this newsgroup TEST your queries.  Such testing might have prevented this embarassing example being posted.

David Fitzjarrell Received on Fri Jan 13 2006 - 11:56:00 CST