Thursday, May 7, 2009

Monitor rollback operations

# From http://www.oracle.com/technology/pub/articles/10gdba/week2_10gdba.html

SELECT USED_UREC
FROM V$TRANSACTION;

select time_remaining
from v$session_longops
where sid = ;

SELECT SQL_TEXT
FROM V$SQL
WHERE SQL_ID = ;

select rcvservers from v$fast_start_transactions;

# check parameters
RECOVERY_PARALLELISM
ALTER SYSTEM SET FAST_START_PARALLEL_ROLLBACK = HIGH