SQL> desc x$ktfbue; Name Meaning ADDR N/A INDX N/A INST_ID N/A KTFBUESEGTSN ts# containing this segment KTFBUESEGFNO Relative number of the file containing the segment header KTFBUESEGBNO segment header block number KTFBUEEXTNO Extent number KTFBUEFNO Relative number of the file containing the extent KTFBUEBNO Starting block number of the extent KTFBUEBLKS Size of the extent in ORACLE blocks KTFBUECTM commit_jtime,Commit Time of the undo in the extent expressed as Julian date KTFBUESTT commit_wtime,Commit Time of the undo in the extent expressed as wall clock time KTFBUESTA Transaction Status of the undo in the extent;1, 'ACTIVE', 2, 'EXPIRED', 3, 'UNEXPIRED', 0 for non-undo-extent
Oracle内部视图:x$ktfbue
原创
©著作权归作者所有:来自51CTO博客作者maclean_007的原创作品,请联系作者获取转载授权,否则将追究法律责任
x$ktfbue:kernel transaction, file bitmap used extent,used extent bitmap in file header for LMT (equivalent to uet$ in DMT); check dba_extents view definition,ktfb –space/spcmgmt support for bitmapped space manipulation of files/tablespaces
KTFBUE means K[Kernel] T[Transaction] F[File] B[Bitmap] U[Used] E[Extents]
![](https://ucenter.51cto.com/images/noavatar_middle.gif)
提问和评论都可以,用心的回复会被更多人看到
评论
发布评论
相关文章
-
如何在Odoo中利用SQL视图创建动态视图
odoo sql 视图
SQL 数据 菜单项 -
[转自Oracle ACE--刘相兵]Oracle内部视图X$KFFXP
[转自Oracle ACE--刘相兵]Oracle内部视图X$KFFXP
XKFFXP ide sed 映射关系 字段 -
内部视图:interval view x$kvii 介绍
内部视图x$kvii554078
Oracle sql 数据库 RAC ORA -
oracle 视图基础 - [ORACLE]
而补漏,不为晚矣;视图的概念视图是基...
Oracle 出版 SQL 数据结构 数据