Tablespace free space monitoring, including AUTOEXTEND

  • From: Lou Avrami <avramil@xxxxxxxxxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Fri, 02 Jul 2010 15:14:11 -0400 (EDT)

Hi folks,

The OpenView team here where I work currently has just turned on database 
monitoring for several 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

Other related posts: