Tablespace free space monitoring, including AUTOEXTEND

Hi folks,

The OpenView team here where I work currently has just turned on database 
monitoring for several 10.2.0.4 production databases, built by a vendor.  This 
application creates and drops tablespaces as part of its regular operations.

The OpenView tablespace monitoring is periodically reporting that tablespaces 
in these databases are near 100% capacity, even though that isn't the case.  
For example, it's reporting that a 2 GB tablespace is 99% full, even though the 
tablespace has the capacity to expand to 4 GB.

Does anyone have SQL handy that reports on tablespaces that are "almost" full, 
and that also takes into account tablespaces that autoextend?

Lou Avrami
--
http://www.freelists.org/webpage/oracle-l

Other related posts: