介绍
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 |
评论区