DBA Data[Home] [Help]

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)