ITPub博客

首页 > 应用开发 > IT综合 > what's xidsqn and ubasqn in v$transaction?

what's xidsqn and ubasqn in v$transaction?

原创 IT综合 作者:warehouse 时间:2008-07-27 22:46:05 0 删除 编辑

不容易理解的2个字段,Jonathan Lewis的解释

http://www.dbforums.com/archive/index.php/t-1314288.html

[@more@]

Jonathan Lewis
The slots in the transaction table in the undo segment header
are continuously being reused. Each time a slot it re-used,
its sequence number (xidsqn) goes up.

Similarly, undo blocks are re-used (though it takes more
time to get round to re-using them than transaction slots).
Each time an undo block is "newed" and reused, its
sequence number UBASQN goes up.

来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/19602/viewspace-1007948/ ,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2007-12-07

  • 博文量
    717
  • 访问量
    5366325