Transaction Counts

The number of active transactions in the instance at any one time can be seen by counting the number of rows in V$TRANSACTION. In Oracle8, you can get a high-water mark for this from V$RESOURCE_LIMIT.

In Oracle7, you can get the same info from X$KTCXB with the following query.

select
  'transactions' parameter,
  count(*) setting,
  count(decode(ktcxbflg, 0, null, 0)) hwm,
  to_char(
    100 * count(decode(ktcxbflg, 0, null, 0)) / count(*),
    '99999'
  ) || '%' usage
from
  sys.x$ktcxb
/