初探v$transaction表used_urec字段

心静自然凉

1748

58页

3次

2019-09-19

10墨值下载

初探

v$transaction

表

used_urec

字段

最近有客户问到

v$transaction

表

used_urec

字段是什么意思，看了下官方文档关

于

v$transaction

视图的介绍

V$TRANSACTION lists the active transactions in the system.

Column Datatype Description

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) YES if 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

USED_UREC NUMBER Number of undo records used

LOG_IO NUMBER Logical I/O

PHY_IO NUMBER Physical 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

of 58

10墨值下载

oracle

关注

评论