Solution from the space monitoring scripts
From: Mladen Gogala <no_at_email.here.invalid>
Date: Fri, 16 Jul 2010 16:37:35 +0000 (UTC)
Message-ID: <pan.2010.07.16.16.37.35_at_email.here.invalid>
For years, I had my own scripts that were calculating the available free space from dba_free_space and dba_data_files. I just discovered the DBA_TABLESPACE_USAGE_METRICS table which has the necessary information, presented in an easily usable way:
Date: Fri, 16 Jul 2010 16:37:35 +0000 (UTC)
Message-ID: <pan.2010.07.16.16.37.35_at_email.here.invalid>
For years, I had my own scripts that were calculating the available free space from dba_free_space and dba_data_files. I just discovered the DBA_TABLESPACE_USAGE_METRICS table which has the necessary information, presented in an easily usable way:
desc DBA_TABLESPACE_USAGE_METRICS
Name Null? Type
- --------
TABLESPACE_NAME VARCHAR2(30) USED_SPACE NUMBER TABLESPACE_SIZE NUMBER USED_PERCENT NUMBER
-- http://mgogala.byethost5.comReceived on Fri Jul 16 2010 - 11:37:35 CDT