Oracle内部视图:x$ktfbue

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]

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

© 2011, www.oracledatabase12g.com. 版权所有.文章允许转载,但必须以链接方式注明源地址,否则追究法律责任.

相关文章 | Related posts:

1. Oracle内部视图:X$BH
2. DIAG: Alter System Dump Undo – Quick Reference
3. VIEW: X$KTUXE – Transaction Entry (table)
4. Know more about DML
5. Fractured block found during backing up datafile
6. EVENT: 10013 “Instance Recovery”
7. BMB versus Freelist Segment: DBMS_SPACE.UNUSED_SPACE and DBA_TABLES.EMPTY_BLOCKS
8. Rollback Segment Utilization:Extent, Wrap and Shrink
9. Database Hangs Because SMON is taking 100% CPU doing transaction recovery