视图:x$ktuxe





x$ktuxe是一张比较重要的内部视图,用来描述运行事务,包括有pmon和smon进程进行回滚的事务。

SQL> desc x$ktuxe
Name                                      Null?    Type
—————————————– ——– ————————-
ADDR                                               RAW(4)
INDX                                               NUMBER
INST_ID                                            NUMBER
KTUXEUSN                                           NUMBER
KTUXESLT                                           NUMBER
KTUXESQN                                           NUMBER
KTUXERDBF                                          NUMBER
KTUXERDBB                                          NUMBER
KTUXESCNB                                          NUMBER
KTUXESCNW                                          NUMBER
KTUXESTA                                           VARCHAR2(16)
KTUXECFL                                           VARCHAR2(24)
KTUXEUEL                                           NUMBER
KTUXEDDBF                                          NUMBER
KTUXEDDBB                                          NUMBER
KTUXEPUSN                                          NUMBER
KTUXEPSLT                                          NUMBER
KTUXEPSQN                                          NUMBER
KTUXESIZ                                           NUMBER

解释:

KTUXEUSN                                           NUMBER
KTUXESLT                                           NUMBER
KTUXESQN                                           NUMBER

以上三个字段构成xid,也就是事务在回滚段中的入口。

KTUXERDBF                                          NUMBER
KTUXERDBB                                          NUMBER

回滚段入口指向的Undo File和Undo Block

KTUXESCNB                                          NUMBER
KTUXESCNW                                          NUMBER

当前事务的scn

KTUXESTA                                           VARCHAR2(16)

active,inactive

KTUXECFL

dead,none,sco|col

KTUXEUEL                                           NUMBER

used extent

KTUXEDDBF                                          NUMBER
KTUXEDDBB                                          NUMBER
KTUXEPUSN                                          NUMBER
KTUXEPSLT                                          NUMBER
KTUXEPSQN                                          NUMBER

parent transation info

ktuxesiz                                                 number

Undo Size

该视图包含了数据库重新启动被pmon和smon恢复的事务,也包含了被kill或者意外终止的进程的事务信息,可以弥补v$transaction的不足。

该视图可以完成以下功能:

(1)、查看事务回滚速度

(2)、查看被死进程锁住的资源

(3)、查看被死进程锁住的对象




Related posts

coded by nessus
分享:  DeliciousGReader鲜果豆瓣CSDN网摘
Trackback

no comment untill now

Add your comment now

无觅相关文章插件