Datafile Size

From NazimWIKI
Jump to navigation Jump to search

In my case, I used the following scripts to list the datafiles incorrectly set to unlimited, i.e. growing to 32768M.

SELECT target_name
     , file_name
     , sum (file_size) / 1024 / 1024
 FROM mgmt$db_datafiles_all
HAVING sum(file_size)/1024/1024 > 15000
GROUP BY target_name, file_name
ORDER BY 3 desc;