SQL> SELECT xidusn, xidslot, xidsqn, ubablk, ubafil, ubarec FROM v$transaction;
XIDUSN XIDSLOT XIDSQN UBABLK UBAFIL UBAREC
---------- ---------- ---------- ---------- ---------- ----------
6 22 2414 2631 3 45
总结:
XIDUSN 回滚段
XIDSLOT 事务槽号
UBABLK 前镜像的数据块地址
UBAFIL前镜像的文件号
深度解析:
SQL> select * from v$rollname a where a.usn=6;
USN NAME
---------- ------------------------------
6 _SYSSMU6_3707530756$
SQL> select usn,writes,rssize,xacts,hwmsize,shrinks,wraps from v$rollstat;
USN WRITES RSSIZE XACTS HWMSIZE SHRINKS WRAPS
---------- ---------- ---------- ---------- ---------- ---------- ----------
0 8112 385024 0 385024 0 0
1 800750 2220032 0 2220032 0 3
2 1412340 2220032 0 2220032 0 1
3 1398866 2220032 0 2220032 0 3
4 1569748 2220032 0 2220032 0 4
5 2109384 3268608 0 3268608 0 4
6 4877548 5365760 1 5365760 0 9
7 1672696 2220032 0 2220032 0 2
8 1341938 2220032 0 2220032 0 1
9 1542752 2220032 0 2220032 0 5
10 1879432 4317184 0 4317184 0 2
alter system dump undo header '_SYSSMU6$'; 转储undo块头
转储内容:
[oracle@parnassusdata1 trace]$ tail -n 300 PROD1_ora_10132.trc
Trace file /s01/oracle/app/oracle/diag/rdbms/prod/PROD1/trace/PROD1_ora_10132.trc
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
ORACLE_HOME = /s01/oracle/app/oracle/product/11.2.0/dbhome_1
System name: Linux
Node name: parnassusdata1.oracle.com
Release: 2.6.32-200.13.1.el5uek
Version: #1 SMP Wed Jul 27 21:02:33 EDT 2011
Machine: x86_64
Instance name: PROD1
Redo thr