GV$LOGMNR_EXTENTS definition in Oracle Database 11.2
GV$LOGMNR_EXTENTS
select
e.inst_id, -- INST_ID NUMBER
ds.owner, -- OWNER VARCHAR2(30)
ds.segment_name, -- SEGMENT_NAME VARCHAR2(81)
ds.partition_name, -- PARTITION_NAME VARCHAR2(30)
ds.segment_type, -- SEGMENT_TYPE VARCHAR2(18)
ds.tablespace_name, -- TABLESPACE_NAME VARCHAR2(30)
e.ext#, -- EXTENT_ID NUMBER
f.file#, -- FILE_ID NUMBER
e.block#, -- BLOCK_ID NUMBER
e.length * ds.blocksize, -- BYTES NUMBER
e.length, -- BLOCKS NUMBER
e.file# -- RELATIVE_FNO NUMBER
from
x$logmnr_uet$ e,
v$logmnr_sys_dba_segs ds,
x$logmnr_file$ f
where
e.segfile# = ds.relative_fno and e.segblock# = ds.header_block and e.ts# = ds.tablespace_id and ds.tablespace_id = f.ts# and e.file# = f.relfile# and bitand(NVL(ds.segment_flags,0), 1) = 0 and bitand(NVL(ds.segment_flags,0), 65536) = 0
union all
select
e.inst_id, -- INST_ID NUMBER
ds.owner, -- OWNER VARCHAR2(30)
ds.segment_name, -- SEGMENT_NAME VARCHAR2(81)
ds.partition_name, -- PARTITION_NAME VARCHAR2(30)
ds.segment_type, -- SEGMENT_TYPE VARCHAR2(18)
ds.tablespace_name, -- TABLESPACE_NAME VARCHAR2(30)
e.ktfbueextno, -- EXTENT_ID NUMBER
f.file#, -- FILE_ID NUMBER
e.ktfbuebno, -- BLOCK_ID NUMBER
e.ktfbueblks * ds.blocksize, -- BYTES NUMBER
e.ktfbueblks, -- BLOCKS NUMBER
e.ktfbuefno -- RELATIVE_FNO NUMBER
from
v$logmnr_sys_dba_segs ds,
x$logmnr_ktfbue e,
x$logmnr_file$ f
where
e.ktfbuesegfno = ds.relative_fno and e.ktfbuesegbno = ds.header_block and e.ktfbuesegtsn = ds.tablespace_id and e.ktfbuesegtsn = f.ts# and e.ktfbuefno = f.relfile# and bitand(NVL(ds.segment_flags, 0), 1) = 1 and bitand(NVL(ds.segment_flags,0), 65536) = 0