oracle uet$,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

KTFBUESEGTSNts# containing this segment

KTFBUESEGFNORelative number of the file containing the segment header

KTFBUESEGBNOsegment header block number

KTFBUEEXTNOExtent number

KTFBUEFNORelative number of the file containing the extent

KTFBUEBNOStarting block number of the extent

KTFBUEBLKSSize of the extent in ORACLE blocks

KTFBUECTMcommit_jtime,Commit Time of the undo in the extent expressed as Julian date

KTFBUESTTcommit_wtime,Commit Time of the undo in the extent expressed as wall clock time

KTFBUESTATransaction Status of the undo in the extent;1, 'ACTIVE', 2, 'EXPIRED', 3, 'UNEXPIRED', 0 for non-undo-extent