Datafile Size
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;