Listado Tablas - Registros - MB

SELECT

DBA_SEGMENTS.OWNER, DBA_SEGMENTS.SEGMENT_NAME, DBA_SEGMENTS.SEGMENT_TYPE, DBA_SEGMENTS.bytes/

 

1024/1024 AS MB, DBA_TAB_STATISTICS.NUM_ROWS
FROM DBA_SEGMENTS LEFT JOIN DBA_TAB_STATISTICS ON (DBA_SEGMENTS.SEGMENT_TYPE = DBA_TAB_STATISTICS.OBJECT_TYPE)
AND (DBA_SEGMENTS.SEGMENT_NAME = DBA_TAB_STATISTICS.TABLE_NAME)
AND (DBA_SEGMENTS.OWNER = DBA_TAB_STATISTICS.OWNER)
WHERE DBA_SEGMENTS.OWNER in (’ARCARDTA’,’ARCARCTL’,’CRPMXCTL’,’CRPMXDTA’,’COMPYCTL’,’COMPYDTA’) AND DBA_SEGMENTS.SEGMENT_TYPE=

 

’TABLE’