eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

SYS.DBMS_FEATURE_ZMAP dependencies on SUM$

Line 77: FROM sum$ s

73: FROM (SELECT sumobj#, clstobj#, detailobj#, mflags, c.flags as cflags, clstfunc, numjoins,
74: numaggregates, numdetailtab, zmapscale, xpflags
75: FROM ( SELECT sumobj#, detailobj#, mflags, numjoins, numaggregates, numdetailtab,
76: zmapscale, xpflags
77: FROM sum$ s
78: RIGHT OUTER JOIN sumdetail$ sd
79: ON (s.obj# = sd.sumobj#)
80: WHERE bitand(s.xpflags,34359738368)=34359738368
81: AND bitand(sd.flags,2) = 2

Line 109: FROM sum$ s

105: IF (is_used = 1) THEN
106: -- ratio of tables with zone maps versus total # of tables in percent
107: SELECT (COUNT(detailobj#)/COUNT(obj#))*100 INTO zmap_ratio
108: FROM ( SELECT detailobj#
109: FROM sum$ s
110: JOIN sumdetail$ sd
111: ON (s.obj# = sd.sumobj#)
112: WHERE bitand(s.xpflags,34359738368)=34359738368
113: AND bitand(sd.flags,2) = 2