Re: Tablespace free space monitoring, including AUTOEXTEND

From: Andrew Kerber <andrew.kerber@xxxxxxxxx>
To: avramil@xxxxxxxxxxxxxx
Date: Fri, 2 Jul 2010 14:22:24 -0500

select
  tablespace_name,
  file_name,
  bytes/(1024*1024) SizeMeg,
  maxbytes/(1024*1024) MaxSize
from dba_data_files
where maxbytes - bytes < 'your number'
and autoextensible = 'YES'
order by tablespace_name;

On Fri, Jul 2, 2010 at 2:14 PM, Lou Avrami <avramil@xxxxxxxxxxxxxx> wrote:

> 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
> --
> //www.freelists.org/webpage/oracle-l
>
>
>


-- 
Andrew W. Kerber

'If at first you dont succeed, dont take up skydiving.'

References:
- Tablespace free space monitoring, including AUTOEXTEND
  - From: Lou Avrami

Re: Tablespace free space monitoring, including AUTOEXTEND

Other related posts: