侧边栏壁纸
博主头像
与晚风述往事博主等级

万般皆下品,唯有读书高。

  • 累计撰写 149 篇文章
  • 累计创建 29 个标签
  • 累计收到 7 条评论

目 录CONTENT

文章目录

V$TRANSACTION动态性能视图

与晚风述往事
2021-11-08 / 0 评论 / 0 点赞 / 412 阅读 / 1,920 字 / 正在检测是否收录...
温馨提示:
本文最后更新于 2021-11-19,若内容或图片失效,请留言反馈。部分素材来自网络,若不小心影响到您的利益,请联系我们删除。

介绍

V$TRANSACTION视图列出正在运行的事务。

视图详情

下面列表信息来源于Oracle 11G官方文档,本人仅做简单翻译,方便下次查询。

字段名 字段类型 描述
ADDR RAW(4 | 8) Address of the transaction state object
XIDUSN NUMBER Undo segment number 回滚段号
XIDSLOT NUMBER Slot number
XIDSQN NUMBER Sequence number 序列号
UBAFIL NUMBER Undo block address (UBA) filenum
UBABLK NUMBER UBA block number
UBASQN NUMBER UBA sequence number
UBAREC NUMBER UBA record number
STATUS VARCHAR2(16) Status 状态
START_TIME VARCHAR2(20) Start time (wall clock) 事务开始时间
START_SCNB NUMBER Start system change number (SCN) base
START_SCNW NUMBER Start SCN wrap
START_UEXT NUMBER Start extent number
START_UBAFIL NUMBER Start UBA file number
START_UBABLK NUMBER Start UBA block number
START_UBASQN NUMBER Start UBA sequence number
START_UBAREC NUMBER Start UBA record number
SES_ADDR RAW(4 | 8) User session object address 用户会话地址
FLAG NUMBER Flag 标志
SPACE VARCHAR2(3) YES if a space transaction
RECURSIVE VARCHAR2(3) YES if a recursive transaction
NOUNDO VARCHAR2(3) YES if a no undo transaction
PTX VARCHAR2(3) YESif parallel transaction
NAME VARCHAR2(256) Name of a named transaction
PRV_XIDUSN NUMBER Previous transaction undo segment number
PRV_XIDSLT NUMBER Previous transaction slot number
PRV_XIDSQN NUMBER Previous transaction sequence number
PTX_XIDUSN NUMBER Rollback segment number of the parent XID
PTX_XIDSLT NUMBER Slot number of the parent XID
PTX_XIDSQN NUMBER Sequence number of the parent XID
DSCN-B NUMBER This column is obsolete and maintained for backward compatibility. The value of this column is always equal to the value in DSCN_BASE.
DSCN-W NUMBER This column is obsolete and maintained for backward compatibility. The value of this column is always equal to the value in DSCN_WRAP.
USED_UBLK NUMBER Number of undo blocks used 使用的undo块数量
USED_UREC NUMBER Number of undo records used 使用的undo记录数
LOG_IO NUMBER Logical I/O 逻辑I/O
PHY_IO NUMBER Physical I/O 物理I/O
CR_GET NUMBER Consistent gets 一致性读
CR_CHANGE NUMBER Consistent changes 一致性改变
START_DATE DATE Start time (wall clock)
DSCN_BASE NUMBER Dependent SCN base
DSCN_WRAP NUMBER Dependent SCN wrap
START_SCN NUMBER Start SCN
DEPENDENT_SCN NUMBER Dependent SCN
XID RAW(8) Transaction XID
PRV_XID RAW(8) Previous transaction XID
PTX_XID RAW(8) Parent transaction XID
0

评论区