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


Other related posts: