SYS.DBMS_FEATURE_AUM dependencies on DBA_TABLESPACES
Line 27: from dba_data_files df, dba_tablespaces ts
23: for ts_type in
24: (select retention, count(*) tcount, sum(size_mb) size_mb
25: from
26: (select ts.tablespace_name, retention, sum(bytes)/1048576 size_mb 27: from dba_data_files df, dba_tablespaces ts 28: where df.tablespace_name = ts.tablespace_name
29: and ts.contents = 'UNDO'
30: group by ts.tablespace_name, retention)
31: group by retention)