首页 > 应用开发 > IT综合 > Transaction Table
==> Transaction Table
==> state 0 = IDLE
1 = Collecting 2 = Prepared 3 = Committed
4 = Forced Abort 5 = Forced Commit 6 = Forced Mixed
7 = try again later
9 = No TX (Committed) 10= Active local TX
==> cflags 1 = TX has started storing collecting information
2 = TX has forced the collecting information
4 = Prepared TX needs distributed recovery
10= Rollback failed on this TX - mark SMON for recover
20= TX has rolled back its updates
==> wrap# is incremented TX slot reuse.
==> uel ?
==> scn SCN for the TX prepare / commit
==> dba is DBA of HEAD of the REDO - Ie: The MOST RECENT CHANG
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/717880/viewspace-822064/ ,如需转载,请注明出处,否则将追究法律责任。