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
Thursday, July 2, 2009
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment