Re: Tablespace free space monitoring, including AUTOEXTEND

  • From: Yechiel Adar <adar666@xxxxxxxxxxxx>
  • Date: Wed, 14 Jul 2010 09:00:49 +0300

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-l


Other related posts: