1看看哪些对象会用上SEG$这个表.
SCOTT@bi>connect / as sysdba
Connected.
SYS@tell>select * from user_dependencies where referenced_name='SEG$';
2随便抽一个出来,看看其如何使用SEG$.
SYS@tell>SELECT TEXT FROM DBA_VIEWS WHERE VIEW_NAME='USER_TAB_PARTITIONS';
TEXT
--------------------------------------------------------------------------------
select o.name, 'NO', o.subname, 0,
tp.hiboundval, tp.hiboundlen, tp.part#, ts.name,
tp.pctfree$,
decode(bitand(ts.flags, 32), 32, to_number(NULL), tp.pctused$),
tp.initrans, tp.maxtrans, s.iniexts * ts.blocksize,
decode(bitand(ts.flags, 3), 1, to_number(NULL),
s.extsize * ts.blocksize),
s.minexts, s.maxexts,
decode(bitand(ts.flags, 3), 1, to_number(NULL),
s.extpct),
decode(bitand(ts.flags, 32), 32, to_number(NULL),
decode(s.lists, 0, 1, s.lists)),
decode(bitand(ts.flags, 32), 32, to_number(NULL),
decode(s.groups, 0, 1, s.groups)),
decode(mod(trunc(tp.flags / 4), 2), 0, 'YES', 'NO'),
decode(bitand(s.spare1, 2048), 2048, 'ENABLED', 'DISABLED'),
tp.rowcnt, tp.blkcnt, tp.empcnt, tp.avgspc, tp.chncnt, tp.avgrln,
tp.samplesize, tp.analyzetime,
decode(s.cachehint, 0, 'DEFAULT', 1, 'KEEP', 2, 'RECYCLE', NULL),
decode(bitand(tp.flags, 16), 0, 'NO', 'YES'),
decode(bitand(tp.flags, 8), 0, 'NO', 'YES')
from obj$ o, tabpartv$ tp, ts$ ts, sys.seg$ s, sys.tab$ t
whereo.obj# = tp.obj# and ts.ts# = tp.ts# and
tp.file#=s.file# and tp.block#=s.block# and tp.ts#=s.ts# and
tp.bo# = t.obj# and bitand(t.trigflag, 1073741824) != 1073741824 and
o.owner# = userenv('SCHEMAID')
and o.namespace = 1 and o.remoteowner IS NULL and o.linkname IS NULL
|