Re: Tablespace free space monitoring, including AUTOEXTEND
From: Yechiel Adar <adar666_at_inter.net.il>
Date: Wed, 14 Jul 2010 09:00:49 +0300
Message-id: <4C3D5291.9010504_at_inter.net.il>
One of the main problems of this kind of scripts is that they do not check the actual available disk space for auto extend. You can have a definition that show that you have 32 GB available, with auto extend, but you gave only 10 GB on the disk.
Date: Wed, 14 Jul 2010 09:00:49 +0300
Message-id: <4C3D5291.9010504_at_inter.net.il>
One of the main problems of this kind of scripts is that they do not check the actual available disk space for auto extend. You can have a definition that show that you have 32 GB available, with auto extend, but you gave only 10 GB on the disk.
Adar Yechiel
Rechovot, Israel
Lou Avrami wrote:
> Hi folks,
>
> 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
>
>
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Jul 14 2010 - 01:00:49 CDT