Oracle查询回滚大事务所需时间

取ktuxesiz 字段10S差值 ，计算出每秒恢复的量，剩余总量除以每秒恢复的量selects.username,t.xidusn,t.xidslot,t.xidsqn,x.ktuxesizfromsys.x$ktuxe x,sys.v_$transaction t,sys.v_$session swherex.inst_id = userenv('Instance') andx.ktuxesta = 'ACTIVE' andx.ktuxesiz > 1 andt.xidusn = x.ktuxeusn andt.xidslot = x.ktuxeslt andt.xidsqn = x.ktuxesqn ands.saddr = t.ses_addr; 转自 https://www.cnblogs.com/alexbob/p/14580882.html: