SCOTT@book> @ viewsess rollback
NAME STATISTIC# VALUE SID
---------------------------------------------------------------------- ---------- ---------- ----------
user rollbacks 7 0 274
transaction tables consistent read rollbacks 325 0 274
rollbacks only - consistent read gets 329 0 274
cleanouts and rollbacks - consistent read gets 330 0 274
rollback changes - undo records applied 335 0 274
transaction rollbacks 336 0 274
IMU CR rollbacks 383 0 274
7 rows selected.
SCOTT@book> rollback ;
Rollback complete.
SCOTT@book> @ viewsess rollback
NAME STATISTIC# VALUE SID
---------------------------------------------------------------------- ---------- ---------- ----------
user rollbacks 7 1 274
transaction tables consistent read rollbacks 325 0 274
rollbacks only - consistent read gets 329 0 274
cleanouts and rollbacks - consistent read gets 330 0 274
rollback changes - undo records applied 335 0 274
transaction rollbacks 336 0 274
IMU CR rollbacks 383 0 274
7 rows selected.
--//viewsess.sql
set verify off
column name format a70
SELECT b.NAME, a.statistic#, a.VALUE,a.sid
FROM v$mystat a, v$statname b
WHERE lower(b.NAME) like lower('%&1%') AND a.statistic# = b.statistic# ;
--and a.value>0;