Größe der Datenbank ermitteln:

>
  1. BREAK ON tablespace_name SKIP 2
  2. COMPUTE SUM OF allocated_bytes, free_bytes ON tablespace_name
  3. COLUMN allocated_bytes FORMAT 9,999,999,999
  4. COLUMN free_bytes FORMAT 9,999,999,999
  5.  
  6. SELECT a.tablespace_name, a.file_name, a.bytes allocated_bytes, b.free_bytes
  7. FROM dba_data_files a,
  8. (SELECT file_id, SUM(bytes) free_bytes FROM dba_free_space b GROUP BY file_id) b
  9. WHERE a.file_id=b.file_id
  10. ORDER BY a.tablespace_name;
  11.