Thursday, July 2, 2009

Getting tablespace Size


SELECT tablespace_name,
  SUM (bytes) / 1024 / 1024 current_size,
  autoextensible,
  SUM (maxbytes) / 1024 / 1024 max_size
FROM dba_data_files
WHERE tablespace_name like '%'
GROUP BY tablespace_name, autoextensible
ORDER BY 1