Re: Tablespace free space monitoring, including AUTOEXTEND

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: