SELECT DISTINCT segment_name, segment_type,bytes/1024/1024 as "Size (MB)"
FROM dba_extents
WHERE file_id = (SELECT file_id
FROM dba_data_files
WHERE FILE_name = '&datafile')
order by segment_type
No comments:
Post a Comment