Tablespace free space monitoring, including AUTOEXTEND

From: Lou Avrami <avramil_at_concentric.net>
Date: Fri, 02 Jul 2010 15:14:11 -0400 (EDT)
Message-Id: <20100702191411.D459B1D26_at_bellona.cnc.net>



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
Received on Fri Jul 02 2010 - 14:14:11 CDT

Original text of this message