oracle事务号

最新推荐文章于 2022-06-30 22:24:41 发布

iteye_9222

最新推荐文章于 2022-06-30 22:24:41 发布

阅读量529

点赞数

分类专栏： oracle 文章标签：数据库

本文链接：https://blog.csdn.net/iteye_9222/article/details/82360197

版权

oracle 专栏收录该内容

6 篇文章 0 订阅

订阅专栏

declare

my number;

begin

insert into a(myxid )values( null );

dbms_lock.sleep(15);

select count(xid) into my from v$transaction;--v$transation是监控当前事务的表

dbms_output.put_line(my);

commit;

end;

--延时15秒，两个事务提交时，在v$transaction中有两条数据，怎么查出哪一条是当前事务的。

----------------------------------------------------------------------------------------------

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`	`VARCHAR 2(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
`XID`	`RAW(8)`	Transaction XID
`PRV_XID`	`RAW(8)`	Previous transaction XID
`PTX_XID`	`RAW(8)`	Parent transaction XID