Well...somehow yes :)
I want to know when its time to do something (add datafile, expand datafile etc)
When a datafile with autoextend set to "on" and a maxsize of 2048 GB i do not want to get active when this file has a current size of lets say 1024 MB and is filled with 512 MB. However, queries on dba_free_space for example will return that only 512 MB of space are left...but in my opinion its 1500 MB...
this script should do it
group by TABLESPACE_NAME) a,
(select TABLESPACE_NAME,bytes/(1024*1024) used
from sys.SM$TS_USED) b
select file_name, bytes/1024/1024 current_size_MB, increment_by*8192/1024/1024 autoextend_size_MB, maxbytes/1024/1024 max_size_MB
and autoextensible = 'YES'
and autoextensible = 'YES';
if you prefer GUI, LAB128 has it
Edited by: zs_hzh on Sep 4, 2008 7:05 AM