查看一个活动的sql对话

最新推荐文章于 2024-12-09 16:43:56 发布

原创最新推荐文章于 2024-12-09 16:43:56 发布 · 508 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#sql #活动 #express #database #oracle #date

ORACLE 专栏收录该内容

31 篇文章

订阅专栏

Connected to Oracle Database 10g Express Edition Release 10.2.0.1.0
Connected as SYS

SQL> select * from v$transaction;

ADDR XIDUSN XIDSLOT XIDSQN UBAFIL UBABLK UBASQN UBAREC STATUS START_TIME START_SCNB START_SCNW START_UEXT START_UBAFIL START_UBABLK START_UBASQN START_UBAREC SES_ADDR FLAG SPACE RECURSIVE NOUNDO PTX NAME PRV_XIDUSN PRV_XIDSLT PRV_XIDSQN PTX_XIDUSN PTX_XIDSLT PTX_XIDSQN DSCN-B DSCN-W USED_UBLK USED_UREC LOG_IO PHY_IO CR_GET CR_CHANGE START_DATE DSCN_BASE DSCN_WRAP START_SCN DEPENDENT_SCN XID PRV_XID PTX_XID
-------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------------- -------------------- ---------- ---------- ---------- ------------ ------------ ------------ ------------ -------- ---------- ----- --------- ------ --- -------------------------------------------------------------------------------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ----------- ---------- ---------- ---------- ------------- ---------------- ---------------- ----------------
27948C98 3 12 215 2 685 444 18 ACTIVE 07/08/10 12:30:31 535541 0 3 2 685 444 18 2894DBA8 3587 NO NO NO NO 0 0 0 0 0 0 0 0 1 1 3 0 12 0 2010-7-8 12 0 0 535541 0 03000C00D7000000 0000000000000000 0000000000000000

SQL>