Datafile Size

From NazimWIKI
Revision as of 23:08, 8 November 2019 by Admin (talk | contribs) (Created page with "In my case, I used the following scripts to list the datafiles incorrectly set to unlimited, i.e. growing to 32768M. <blockquote><pre> SELECT target_name , file_name...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
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;